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.
| Author |
Topic |
|
jayp369
Starting Member
26 Posts |
 Posted - 2007-08-10 : 14:10:33
|
| My predecessor, did not document the password for sa and had disabled the builtin admin account, is there another way in or will i have to re-install SQL 2005Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-10 : 14:33:47
|
| If you don't have any other sysadmin accounts to use, then you won't be able to gain access to the SQL Server with sysadmin privileges.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-08-10 : 15:34:47
|
| This is a rather unorthadox approach (IMO), but completely applicable and should present an option or two for the OP.http://www.simple-talk.com/sql/t-sql-programming/temporarily-changing-an-unknown-password-of-the-sa-account-/ |
|
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-08-10 : 16:04:10
|
| ThanksI think this will workJay |
|
|
|
|
|
|
sa Password