Question Remotely accessing db - winforms app

DekaFlash

Well-known member
Joined
Feb 14, 2006
Messages
117
Programming Experience
1-3
I have a vb.net application, which I want to access a sql server 2005 from a remote workstation.

When I run the application I get the following exception

System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
 

DekaFlash

Well-known member
Joined
Feb 14, 2006
Messages
117
Programming Experience
1-3
The connection string is currently, is this the correct way to go about it.

Dim connstring As String = "Data Source=BM-PC;Initial Catalog=EMS;Integrated Security = True;TrustedConnection=YES;User Id=u;Password=p;

Thanks
 
Top Bottom