Solved

Non-Domain Tablet Login to Server SQL 2008 R2 Fails

Posted on 2014-04-03
3
337 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 19

Expert Comment

by:Patricksr1972
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 19

Accepted Solution

by:
Patricksr1972 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

920 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now