Solved

Non-Domain Tablet Login to Server SQL 2008 R2 Fails

Posted on 2014-04-03
3
334 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

771 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

11 Experts available now in Live!

Get 1:1 Help Now