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 |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
 Posted - 2008-11-28 : 08:38:33
|
| Hi All,We have an urgent client requirement as followingwe need to create a SQL authenticated ID which will accept connections only from our IIS server.System Name IPSQLServer 100.100.1.1IIS 100.100.1.2Any suggestion would be greatly helpful. |
|
|
Elisabeth Redei
Starting Member
15 Posts |
Posted - 2008-11-28 : 13:04:40
|
| Hi,What do mean by "SQL Authenticated ID"? A SQL Server login? A SQL Server login can only map to NT Users and Groups - not machine accounts or IP addresses.You would have to use something like a firewall to do this./Elisabethelisabeth@sqlserverland.com |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-11-28 : 14:53:15
|
| With 2005 SP2 and higher you can use a logon trigger to do this. Be careful writing logon triggers though. If they fail unexpectedly, they can cause massive chaos.There's a good section in the latest Books Online on logon triggers--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Urgent ! need to map SQL authenticated ID to IP