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 |
|
jproberts
Starting Member
3 Posts |
 Posted - 2006-05-25 : 10:52:01
|
| As part of a security audit, I've been asked to confirm a few of the settings of our SQL Server installation. Not being a DBA I've no idea where to look to find how the following are currently configured:SQLDebugger.Authentication mode.User id security (Permissions are applied to Windows groups or database roles, not individual user ids).Cross database chaining.Can someone help me to find out how these are configured, please.Never been in any kind of trouble that I didn't walk into with both eyes open. |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-25 : 13:33:44
|
| Hi for Authentication mode:right click on the server and go on properties=>go to general tab and check the authentication mode..and in security tab u can look for users and there default databases..Cant say anythin about other two thingsRegardsNitin |
 |
|
|
jproberts
Starting Member
3 Posts |
Posted - 2006-05-25 : 18:50:01
|
That's great, thanks. Half way there already  J-PNever been in any kind of trouble that I didn't walk into with both eyes open. |
|
|
|
jproberts
Starting Member
3 Posts |
Posted - 2006-05-28 : 09:00:02
|
| Three quarters now, there's a check box for "Allow cross-database ownership chaining" (which I assume is what they meant) on the security tab. Thanks, you've been a great help.Regarding the SQL Debugger being enabled or not, I think I'll take the approach that I'm not going to be able to find out, so I'll just run a script to disable it regardless of its current setting.J-PNever been in any kind of trouble that I didn't walk into with both eyes open. |
|
|
|
|
|
|
SQL Server Settings