I meet a problem and an error:
Cannot open database "dbTest" requested by the login. The login failed.Login failed for user 'machinename'.
The condition is like this:
1 I make my website connect to a remote sql server.
2 This sql server makes only access to a count, such as 'sa' and its password is 'sapw'
3 I write the connect string in web.config like this :
<add name="ConnectionString" connectionString="Data Source=dbTestSource;Initial Catalog=dbTest;Integrated Security=True; User ID=sa;Password=sapw;" providerName="System.Data.SqlClient" />
But the error says "Login failed for user 'machinename'". How could I make my website access to the sql server with the account of "sa"?
View Complete Post