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
 Transact-SQL (2005)
 SQL Server Credentials

Author  Topic 

srkvellanki
Starting Member

14 Posts

Posted - 2009-06-10 : 15:35:32

Hi All,

I installed SQL Server 2005 on my machine with password,i forgot it now.can i get to know the credentials of it.


Regards
Sri

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-10 : 16:00:38
Log on to your machine as Administrator.
Start SSMS.
Login with Windows Authentication with your username from your machinelogin.
Then in a query window:
sp_password @new = 'my_new_password', @loginame = 'sa'



No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -