January 20, 2009 at 3:37 am
I feel that this may be a stupid question but is there anyway a 'sa' password can be retrieved when the developer has lost it (the password)?
In a less than ideal way, the developer installed the software package which included SQL Server 2005 without DBA involvement. I know that the sa password will lock if too many attempts are made.
I'm on more training next week so I'm catching up fast !
Thanks
Madame Artois
January 20, 2009 at 3:45 am
S Hodkinson (1/20/2009)
I feel that this may be a stupid question but is there anyway a 'sa' password can be retrieved when the developer has lost it (the password)?In a less than ideal way, the developer installed the software package which included SQL Server 2005 without DBA involvement. I know that the sa password will lock if too many attempts are made.
I'm on more training next week so I'm catching up fast !
Thanks
try your combinations . the last step is to copy all the database's .mdf and .ldf files. uninstall the sql server, install it again and then attach the databases
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
January 20, 2009 at 3:48 am
If this is a SQL Express installation done by a software package, you might be lucky that you can find the sa password in the connection string. Way too often apps include the unenecrypted password in some configuration file.
If you can't find it that way, you can reset the password without knowing the old one when you logon with a sysadmin account. Either use SSMS or sqlcmd.exe.
[font="Verdana"]Markus Bohse[/font]
January 20, 2009 at 3:51 am
He didn't create any backups either. I've also tried to amend my password priveleges (on the server side) but it wouldn't let me do it.
Madame Artois
January 20, 2009 at 4:55 am
Can you try logging on the the machine with an account that's a windows administrator, then try to connect to SQL with windows authentication. Providing this is not on Vista/Server 2008 and the builtin\administrators group has not been removed, then you should, as the windows admin, be able to log in as sysadmin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2009 at 6:48 am
GilaMonster (1/20/2009)
Can you try logging on the the machine with an account that's a windows administrator, then try to connect to SQL with windows authentication. Providing this is not on Vista/Server 2008 and the builtin\administrators group has not been removed, then you should, as the windows admin, be able to log in as sysadmin.
Absolutely brilliant!! I've been able to give myself sysadmin rights. I knew there must be some way round it.
I shall leave the developer to the attentions of senior management.
Thanks for all the assistance, guys
Madame Artois
January 20, 2009 at 6:56 am
S Hodkinson (1/20/2009)
I shall leave the developer to the attentions of senior management.
😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply