Give access of SQL server to local user

Question

4.00/5 (1 vote)

See more:

Hi,

I have a Business Intelligence tool which connects to SQL Server through ODBC Data Source. I created a local SQL user and created a system DSN with SQL Server Authentication. But when I try to connect to SQL Server using this DSN it is giving me an error saying "Login failed for user 'A'". The user is not a domain user.

Can some one help me how to provide access to sql server 2005 to a non domain user.

Thanks,
Uma

What I have tried:

I tried creating a system DSN with SQL Server authentication giving username and password of local user.

Posted 20-Apr-16 19:51pm

Uma Kameswari

Updated 21-Apr-16 1:03am

v3

Add a Solution

Comments

Herman<T>.Instance 21-Apr-16 3:39am

Is in the ServerProperties under security selected that Server Authentication is set to SQL Server and Windows Authentication mode?
Is the user mentoined in the DSN created as both Login and User?
Does the user have rights enough on the database?

Uma Kameswari 21-Apr-16 6:59am

Server Authentication is set to SQL Server and Windows Authentication Mode.
User is not a domain user. He is from a different domain.
Enough rights are given on the database.

Herman<T>.Instance 21-Apr-16 7:32am

Set DoaminName of user before username, so DOMAIN\USERNAME and try again

Uma Kameswari 25-Apr-16 1:45am

My requirement is i have a short to business intelligence tool. Now I am passing the DSN as command line argument to the shortcut. when i run the shortcut I get error Login failed for user 'A'. my actual user name starts with s.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

deepankarbhatnagar · Answer 1 · 2016-04-21T01:03:00

Solution 2

Please get help from these links below:

Connecting to an SQL Server from a non-domain pc[^]

c# - Access to SQL Server 2005 from a non-domain machine using Windows authentication - Stack Overflow[^]

Providing non-domain Users access to SQL Server application - Microsoft SQL Server - Spiceworks[^]

Posted 21-Apr-16 1:03am

deepankarbhatnagar

Comments

Uma Kameswari 21-Apr-16 8:28am

These solutions will not work for my problem.