Sql server access problems
Hello, I'm trying to access sql2000 from IIS6, but no matter what I try, i keep getting denied. When I run the code from webmatrix, it works perfectly, despite the fact, that I'm accessing sqlserver across two domains, but when I publish the app on IIS6, they run from the same domain, but different servers.
system.Data.SqlClient.SqlException: Login failed for user 'intranet'.
Dim connectionString As String = "Data Source=srv221;database=intranet;uid=intranet;pwd=p assword;"
And I tried different combinations of: