Hi

I want to use Windows Authentication to access my SQL server 2000 .

I have my Sql Server and Server on which my Asp.net application lies on different servers

how do I go ahead

Thanks

Hi

A domain trust is a useful way to allow users from a trusted relationship domain to access services in a trusting domain, so the domain the SQL Server is in, trusts the domain that the requesting user is defined in. SQL Server will authenticate Windows credentials with it's domain controller. For cross domain authentication, domain controller controller should be able to authenticate credentials from both domains. This is accomplished through domain trusts

I am sorry but actually my domain is same but they are on different servers

I have changed the post the Subject

Thanks

Hi

ASP.NET use  NT AUTHORITY\NETWORK SERVICE (IIS6) as anonymous account for IIS machine A to login with SQL server B. In the destination SQL instance, You can add two new logins: [ServerName]\ASPNET and NT AUTHORITY\NETWORK SERVICE (the NT AUTHORITY\NETWORK SERVICE login is not required if the WSUS server is running Windows 2000 Server). Here you can find more information

http://forums.asp.net/p/881639/912907.aspx#912907

http://forums.asp.net/p/1159952/1914660.aspx#1914660