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 |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2006-05-27 : 10:16:56
|
| I have a domain which have 180 nodes. I need to find / restrict the users to access sql server from specific system. No body can use our live database who are not under the list. How can i achieve this.Autoconnection spool is there or not like domain list for a domain server.I need this urgently. Please help me out.amit kumar madhukar |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-05-28 : 03:40:28
|
| How is the SQL server authentication configured? Whatever is your authentication method, you might want to control the granting of permission on the SQL Server side (and not from the OS). Meaning, you have to search the SQL Server users/roles for the permissions you have granted.May the Almighty God bless us all! |
 |
|
|
|
|
|
Data accessing from different system