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 |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2010-11-03 : 11:51:33
|
| hiMy SQL server 2008 is using windows authentication mode, and i have accidentally disable the windows admin account at the SQL security login. Now i can't login at all. how should i solve this? thanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
Posted - 2010-11-03 : 21:28:40
|
| i followed through the link and went on step by step. when i issued sqlcmd -e it display administrator is disabled. What should i do now? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-11-04 : 00:48:10
|
| You should try one of the other methods that are mentioned on the discussion thread of that article.Also, did you verify that your login is a windows admin on that server?CODO ERGO SUM |
|
|
|
|
|
|
Accidentally Disable windows administrator