SQL Server 2005 login authentication across different domains
Posted on 2009-12-29
I am trying to find a database authentication solution across different domains (computers) using only SQL Server 2005 login credentials. I am not using a table with login accounts but need to use the login accounts in SQL Server. One computer is the database server "XYZ" with SQL Server 2005 and the other is a web server "ABC" with many similar .NET applications. On the web server "ABC" the .NET apps are written in both C#/VB.NET with "Integrated Security=SSPI" in the connection string like shown below:
Persist Security Info=False;Data Source=XYZ;Initial Catalog=DATABASE_NAME;Integrated Security=SSPI" providerName="System.Data.SqlClient
The web server "ABC" is using IIS 6.0 with "Enabled Anonymous Access = unchecked" and "Integrated Windows Authentication = checked". The database server "XYZ" has server authentication "SQL Server and Windows Authentication mode = checked" and has login accounts under "Security --> Logins --> (XYZ\username1, XYZ\username2, XYZ\username3, ...)" but when trying to access these accounts from the web server "ABC" the login accounts used are (ABC\username1, ABC\username2, ABC\username3, ...) The issue seems to be that the web server domain "ABC\username" is trying to access the database "XYZ\username" so is there a code solution (dll, web service, .net code, whatever...) where the ABC --> XYZ is switched or is there a setting that I am missing?