I am trying to connect to my SQL 2000 Server through an aspx page using window authentication. I get the error message. My connection string is:
conNorthwind = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Northwind" );
My server is named SaintAndrews. I get the following error Login failed for user 'SaintAndrews\ASPNET'.
Can anyone help me out with this?