December 16, 2009 at 7:59 am
I install SQL server 2005 using my adm id but never got the sa passwork,How can I get or retrive a SA password in SQL server 2005
December 16, 2009 at 8:02 am
If the setup didn't ask you to provide an sa password, it sounds like you setup SQL Server to use only Windows Authentication, is this true?
December 16, 2009 at 8:34 am
There is no way to hack in and retrieve the 'sa' password.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2009 at 9:20 am
no my setting is mix mode window and sql auth.
December 16, 2009 at 9:37 am
Then SQL Server install should have asked for a sa password. If you have forgotten it, you will have to change it as there isn't any way to find what it currently is.
December 16, 2009 at 9:45 am
ok thanks, I will change it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply