Windows authenticated connection from ASP.Net to SQL

Question

0.00/5 (No votes)

See more:

Hi,

I have created an application which connects to sql server using SQL server authentication as shown below

add name="ConnectionString" connectionString="Data Source=hostname;Initial Catalog=databasename;User ID=UID;Password=pwd" providerName="System.Data.SqlClient

Now i want to make connectivity using windows authentication i.e Persist Security Info=True;

Can you please help me with the changes that i should make in my ASP.Net application and in SQL server database

Thanks in advance

Posted 26-May-13 20:42pm

vivek ayyakannu

Updated 26-May-13 20:53pm

v2

Add a Solution

3 solutions

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)

**Zoltán Zörgő** · Answer 1 · 2013-05-26T21:08:00

What about looking around here: http://www.connectionstrings.com/sql-server-2008[^]. But I suggest you don't set Persist Security Info to true, even less, because it has no actual use in conjunction with windows authentication.

But be sure to have all necessary circumstances to have windows authentication actually working: http://msdn.microsoft.com/en-us/library/bb669066.aspx[^]

ilia lezhava · Answer 2 · 2013-05-26T21:10:00

Solution 2

use this connection string

XML

<add key="ConnectionString" value="Data Source=hostname;Database=databasename;Integrated Security=SSPI;" />

Posted 26-May-13 21:10pm

ilia lezhava

Comments

vivek ayyakannu 27-May-13 3:16am

Thanks for your answers...
But i would also like to know the changes that i shoul make in SQL server
By asp.net application is windows based authentication.
When i host my application in server it throws me an error login failed for user ""
What user role should i add in my sql server database....

ilia lezhava 27-May-13 3:18am

You must add your windows user in sql database and turn on owner permission.

Osman24 · Answer 3 · 2013-05-26T21:26:00

Solution 3

There would be no owner permission needed. You can just change your connection string like this : Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

It will be enough and it should not give any error. There is no need to change anything else.

Posted 26-May-13 21:26pm

Osman24

Comments

vivek ayyakannu 27-May-13 3:32am

Thanks once again all of you.

Since i got the below mention erroe
'cannot open database requested by the login. the login failed. login failed for user'

I have created an user role [NT AUTHORITY\NETWORK SERVICE], mapped my database to it and gave permission as DB owner.

It resolved my problem.

Thank You.

Osman24 27-May-13 3:51am

Thank you for your response. I have never faced a situation like this. As i know Network Service alredy have these permission. I'm happy for you to solve your problem.

Thank you