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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-07 : 11:05:24
|
| Joe writes "I have only a Windows authetication to log into my sql server database on windows professional os and I mistakenly denied access to my windows login details on the database. I now cannot login into my server any more. Please HELP.Thanks." |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-07 : 14:10:58
|
| If you know your sa password you can change to mixed mode authentication by editing the following registry keyHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServerLoginMode change it from 1 to 2HTHJasper Smith |
 |
|
|
|
|
|
Editing sql server registration properties