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 |
|
w0lfshad3
Starting Member
2 Posts |
 Posted - 2008-12-19 : 11:12:35
|
| I went into the <username> with Management Studioit had Login on Disabled in Security, i put it on Enabled i remember, after a while i moved it back to Disabled as i didn't notice any improvement with my problem. But to my surprise it said account disabled. Furthermore i can't login with anything else or the users i make from SQL configuration management. How do i reset this so i can log in to management studio and databases again please? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
w0lfshad3
Starting Member
2 Posts |
Posted - 2008-12-19 : 11:31:15
|
| I don't remember removing anything.In windows auth mode it sais cannot connect to user: ".exactly like that: ".Because is not related to any trusted connections.And in SQL Auth mode it sais login failed for user: <myuser> and <my password> that i set for it from sql configuration manager.I don't know any default logins. I tried u:sa p:sa it didn't work.Know any others? If i repair or uninstall/install SQL Server will it be fixed? Any other way to reset this? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
i locked myself out of SQL Server engine