How to Connect to SQL Server

Question

How to Connect to SQL Server

Raghavender Chavva

SSCrazy Eights

Points: 8669
More actions
August 10, 2010 at 3:11 am

#238646

Hi Team,
We have a SQL Server 2008.
But we are unable to connet to it as we lost the login credentials(we are the administrators). Already removed Built In/Administrators, lost the sa password, unable to connect using Service accounts.
Can ay body suggests if we start the SQL Server services in single user mode, will it possible for windows administrators to connect to SQL Server 2008...I think its possible in SQL Server 2005, but not sure about 2008.
Thank You.
Regards,
Raghavender Chavva

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

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

Adiga One Orange Chip Points: 27284 More actions · Answer 1

I hope you have the logon credentials of the SQL Server Service Account. If the service account has interactive logon privilges, logon to the server with the Service Account Details and re-set the password.

Also you can try running SSMS with Service Account details using "Run as" option.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

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

Adiga (8/10/2010)
I hope you have the logon credentials of the SQL Server Service Account. If the service account has interactive logon privilges, logon to the server with the Service Account Details and re-set the password.
Also you can try running SSMS with Service Account details using "Run as" option.

here Unfortunate thing is that we have lost Service accounts passwords also.

Thank You.

Regards,
Raghavender Chavva

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 3

Check this...

http://www.mssqltips.com/tip.asp?tip=1441

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

Vincy-856784 Ten Centuries Points: 1298 More actions · Answer 4

Do you have Mixed Security Mode enabled or just SQL Security Mode?

If you have mixed mode and you're the Administrator (windows) for that server then you don't need any other password. You can just log into that SQL Server using windows authentication. But if you're using just SQL Mode, not sure but others might give you some ideas.

Good Luck!

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

Vincy-856784 (8/10/2010)
Do you have Mixed Security Mode enabled or just SQL Security Mode?
If you have mixed mode and you're the Administrator (windows) for that server then you don't need any other password. You can just log into that SQL Server using windows authentication. But if you're using just SQL Mode, not sure but others might give you some ideas.
Good Luck!

Yes it's has Mixed Mode.

but no luck.

Thank You.

Regards,
Raghavender Chavva

OD DE Newbie Points: 5 More actions · Answer 6

OD DE

Newbie

Points: 5

August 12, 2010 at 3:39 am

#1205882

Hi

rest the Service Account password

Daniel

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 7

Have you tried the DAC connection? or Dedicated Access Connection?

Vincy-856784 Ten Centuries Points: 1298 More actions · Answer 8

If it is Mixed Mode and u r the Admin to that box and you logged in as administrator, then you do not need any other password to log in to SQL server.

Either your not the Administrator to that box (windows server) or its not setup as mixed mode.

If you can log into that box as Administrator, then you should definitely be able to get into SQL server as well if the SQL Server is running. If you're the admin, have you checked the event log?

Remember you must log in to the box with Admin privileges and first verify that all the SQL Services are running. If not goto the services on the Administrator Tools and start those services. You can set the service account, start and stop the services there. Unless you use the custom account you don't need the password to start the services. Even if you used custom then change it to Network or some other system account and start them.

Good luck,