I have SQL 2008 r2 installed on a Server 2008 R2 and have been successfully connecting from local domain workstations. Now I have a Windows 8.1 Tablet that is NOT on the domain and I cannot connect to the SQL database. A local user <userid> is defined on the Server and can login with that user/password directly on the Server and run SQL Studio just fine.
Here is the connection string that I am trying to use on the Tablet with no success. Can anyone help point out my error. Thanks.
connectionString="Data Source=<server>;Initial Catalog=<database.;User ID=<userid>;Password=<password>;Integrated Security=False;Pooling=True;Persist Security Info=False "
I consistently get a Login Failed on user <userid>