I am developing simple desktop application that suppose to connect to SQL DB launched on remote server.
Everything going fine, exept that when connecting to DB I get exeption "Login failed for user 'guest'."
So, looks like i need to create some user with password and give him at least 'read rights'. How can I do it.
What I tried:
1. 'sa' name doesn't work.
2. Allow remote connection - enabled.
SqlConnection sqlconn = new SqlConnection("Data Source=126.96.36.199,1433;Network Library=DBMSSOCN;Initial Catalog=remoteDB;User ID=guest;Password=;");