Login to SQL Server

Question

Login to SQL Server

Raghavender Chavva

SSCrazy Eights

Points: 8669
More actions
April 13, 2010 at 4:11 am

#142544

Hi All,
We have SQL Server 2005 installed on local system.
I have access to that instance through 'sa' only. I dont have windows login to that system.
Now the issue is I have forgot the 'sa' login password and no is there to help me in this issue.
Don't know whether that instance had builtin login or not.
Can any one help me ?
Thanks in advance!!
Thank You.
Regards,
Raghavender Chavva

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

try selecting windows authentication and login to the system. If you have not removed builtin\administrators(it's present by default), you'll be able to login using ur windows login..

Pradeep Singh

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 2

ps. (4/13/2010)
try selecting windows authentication and login to the system. If you have not removed builtin\administrators(it's present by default), you'll be able to login using ur windows login..

Its also not working......

Thank You.

Regards,
Raghavender Chavva

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 3

hi,

Is it possible to run from CMD prompt.....

if possible we can execute the commands...the authentication mode is set to Mixed mode....

& Then restart the server.....

Correct me if i am wrong......:discuss:

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 4

Sasidhar Pulivarthi (4/13/2010)
hi,
Is it possible to run from CMD prompt.....
if possible we can execute the commands...the authentication mode is set to Mixed mode....
& Then restart the server.....
Correct me if i am wrong......:discuss:

Its already set to Mixed Mode only....

any way can you tell me how to execute the commands from Command Prompt ?

Thank You.

Regards,
Raghavender Chavva

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 5

We can execute from SQLCMD

try with links given below...

http://www.sqlservercentral.com/Forums/Topic411075-145-1.aspx

http://www.databasejournal.com/features/mssql/article.php/3660226/SQL-Server-2005-Command-Line-Tool-SQLCMD--Part-II.htm

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 6

ok.....Thank you.

Can any body give me the solution how to connect to the SQL Server ?

Thank You.

Regards,
Raghavender Chavva

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 7

For this one I have a solution, suggest me whether it can be a feasible solution or not:

As SQL Server is running on local groups --- > We will create a new user on that system and change the SQL Sever service accounts to that new user ---> and then we will login to the server using that new user and then we can login to that instance ?

Thank You.

Regards,
Raghavender Chavva

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 8

Try whats stated at-->http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

MJ

NJ-DBA SSChampion Points: 13834 More actions · Answer 9

unless you explicitly removed BUILTIN\ADMINISTRATORS login from the server, you should be able to log in using windows authentication with an user who is a member of the local ADMINISTRATORS group on the server... you're sure the account you tried with was in the administrators group?

If that's not going to work than the method described above (using single user mode) shouldn't work either as that method assumes you have access through windows authentication.

If that's the boat you're in, I think you need to basically recover the instance- perform a reinstall, set and sa password, restore all the databases except master.