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 |
|
themav54
Starting Member
1 Post |
 Posted - 2003-05-14 : 09:49:33
|
| Hi, I am really new to SQL server 7.0 and I just need a quick question answered. How can I tell what security that I am using? I need to use integrated security and not mixed security. Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-14 : 10:16:34
|
| terminolgy...terminolgy...Do you want Windows Only Security?Go to the properties tab for the server in Enterprise manager and select it (if it's not already).Brett8-) |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-14 : 10:28:46
|
| That's no fun Brett... :)xp_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', 'LoginMode'If this returns 0, then it's mixed.In SQL 2000 it's much simpler:select serverproperty('IsIntegratedSecurityOnly')If 0, then mixed again. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-14 : 11:15:23
|
| Kalle,Hey that's a neat trick...I'm usually a command line kinda guy, but with setting up the security, I usually "set it and forget it" (Ron Popiel rip off).Never had to worry about this, But hey it's good to knowDamn...learned something new AGAIN..Brett8-)Edited by - x002548 on 05/14/2003 11:16:03 |
|
|
|
|
|
|
Integrated Security vs. Mixed Security