Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 different account

Author  Topic 

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-01-09 : 16:54:20
I completey forgot this and I had this question on my last test. How would I log in as the SA account in SQL server?? Also how do you find out what the password is or do I just create another pass word
how do I find out what the sa password is

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-09 : 18:51:09
You just type in sa when it prompts you for the SQL credentials. Passwords are encrypted and we will not assist with helping finding them out as that is a security issue.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-01-09 : 18:54:39
I understand the reason why I was asking is becuase the person who use to handle it is no longer with us and I am the person in charge of sql now.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-10 : 15:07:45
Then connect with an account that has local admin privileges (by default they get sysadmin) and then change the password. You will then be able to connect with it using the new password.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -