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 |
|
db_sysadmin
Starting Member
27 Posts |
 Posted - 2006-08-01 : 12:59:54
|
| Hey there,I'm using MSDE/Windows 2000 and I cant connect to sa account. blank password doesn't work...I don't know what to do, I keep uninstalling SQL Server and reinstalling it, and it won't work.Thanks a bunch! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-01 : 13:51:30
|
| You need to allow mixed security.go to the registry findSOFTWARE\Microsoft\microsoft sql server\MSSQLServer\LoginModein hkey local machine(something like that - do a bit of searching to get the key)set it to 2.Should now allow a sql server login.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-08-01 : 14:08:15
|
Nigel,quote:
Should now allow a sql server login.
Doesn't he need to stop and start SQL Server before the logins will work?Ken |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-08-01 : 21:28:54
|
| when you installed, which account did you use? use that account or add your account to the local administrators group then try windows authenticationHTH--------------------keeping it simple... |
|
|
|
|
|
|
Not associated with a trusted SQL Server con...