How can I create entity model connection by windows account?

Question

1.00/5 (1 vote)

See more:

I have windows account "ABC" which has access to connect to sqldatabase.

my account is "xyz" which i use to work on visual studio.

my question is..

How can i create a entity model using "ABC" windows account on current solution which is running on "xyz".

What I have tried:

i can create connection by sql authentication and pass them the username and password, but cannot pass user name and password when using windows account.

Posted 2-Jul-17 21:29pm

shaprpuff

Updated 3-Jul-17 0:03am

Add a Solution

Comments

F-ES Sitecore 3-Jul-17 6:08am

It'll be easier to just use SQL Authentication. The Windows auth you're using now is for when the account running the code has access, if you want to use a different account you'll probably need to use impersonation such that the code runs under the account with the access, or change the anonymous IIS user to the account with the access. Switching to SQL auth will be the easiest solution though.

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)

TheRealSteveJudge · Accepted Answer · 2017-07-02T23:51:00

This question is about MS SQL Server authentication.
There are two ways of authentication:
- Windows Authentication
- SQL Server Authentication

as described in
Choose an Authentication Mode | Microsoft Docs[^]

The only way to use your database using the 'xyz' account
is to ask your database administrator to grant rights for the 'xyz' account.