I have a vb.net app connecting to a sql database.
When I run the app on the PC running Sql Server it logins ok.
When I try and run the app on a different PC, I get the following error
System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'.
I am using the following connection string
Dim connstring As String = "server=BM-PC;Initial Catalog=EquinexMasterSql;User ID=username;Password=password;Trusted_Connection=False;"
It looks like the users, login and database security is configured correctly
in Sql Server Management Studio.
Any suggestions are most welcome.
When I run the app on the PC running Sql Server it logins ok.
When I try and run the app on a different PC, I get the following error
System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'.
I am using the following connection string
Dim connstring As String = "server=BM-PC;Initial Catalog=EquinexMasterSql;User ID=username;Password=password;Trusted_Connection=False;"
It looks like the users, login and database security is configured correctly
in Sql Server Management Studio.
Any suggestions are most welcome.