Question Remotely accessing db - winforms app

[DekaFlash]

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)

 

[ss7thirty]

I would try connecting using integrated security or through a regular SQL user account rather than trying to connect through the guest account.

 

[DekaFlash]

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