Connecting to sql 2000

[sand133]

Hi I want to connect to a sql 2000 database using the windows credentials of the request. The reason I'm doing this is because certain users have restricted access to some tables.

On IIS i have set windows authentication, question is what else would i need to do.

thanks

 

[ca8msm]

Turn off anonymous access, make sure the users have access to the database and then setup your data access on your ASP.NET page.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]