Non-Domain Tablet Login to Server SQL 2008 R2 Fails

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.

  <connectionStrings>
    <add name="Bluelight.e_finity.Console.Settings.efinityConnectionString"
      connectionString="Data Source=<server>;Initial Catalog=<database.;User ID=<userid>;Password=<password>;Integrated Security=False;Pooling=True;Persist Security Info=False "
      providerName="System.Data.SqlClient" />
  </connectionStrings>

I consistently get a Login Failed on user <userid>
ariggs1042Asked:
Who is Participating?
 
Patrick BogersDatacenter platform engineer LindowsCommented:
That is what i mean Yes.
Other solution could be adding the local user to a security group which has rights in SQL server. Check in security-> logins
0
 
Patrick BogersDatacenter platform engineer LindowsCommented:
If SQL2008 R2 is in mixed authentication mode you need to create a local SQL user, not a local server user.
0
 
ariggs1042Author Commented:
I am using Windows Authentication when on the Server and have a <server>\<user> created on the Server.  That is the user id/password that I use in the connection string.  Are you suggesting that I need to create a SQL user from the SQL Studio on the Server and assign privs to the database, then use that user/password on the connection string?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.