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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Using NT security to access SQL Server from ASP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-06 : 23:17:21
Scott writes "IIS 4, SQL Server 7 SP2, NT4 SP 6a (both machines)
We're using NT security on SQL Server, controlled by membership of local groups on the database machine. Using NTLM security on the intranet web server (separate machine). When a user tries to access data from SQL Server via the intranet I want the data they are allowed to see to be restricted by the rights granted to them on the database server. I've tried setting up a system DSN on the web server and telling it to use NT security but this doesn't work. Any ideas?
Thanks for any help."
   

- Advertisement -