Solved

Non-Domain Tablet Login to Server SQL 2008 R2 Fails

Posted on 2014-04-03
3
341 Views
Last Modified: 2014-04-03
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>
0
Comment
Question by:ariggs1042
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Patrick Bogers
ID: 39976182
If SQL2008 R2 is in mixed authentication mode you need to create a local SQL user, not a local server user.
0
 

Author Comment

by:ariggs1042
ID: 39976252
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
 
LVL 20

Accepted Solution

by:
Patrick Bogers earned 500 total points
ID: 39976291
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question