Setting the ASP.NET ConnectionString to a specific domain user

Question

We have a windows account in the SQL Server 2008 called drwho for example and a password. In the connection string we disabled integrated security and added User Id and password values.

User Id=THEDOMAIN\drwho;Password=......

However ASP.NET keeps thinking we are using SQL server authentication.

Any suggestions?

edosoft · Accepted Answer · 2010-01-21 09:38:26Z

5

You cannot connect to SQL server using a domain user/pass. If you wish to connect as a domain user, you need to specify integrated security and run your ASP.NET process as that user. See this page at Microsoft for more information.

answered Jan 21, 2010 at 9:38

edosoft

17.4k25 gold badges81 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris S · Accepted Answer · 2010-01-21 09:38:56Z

4

You will have to use impersonate to do this. As far as I'm aware you can't pass domain usernames/passwords in connection strings only a trusted connection, .e.g.

<identity impersonate="true"
          userName="domain\user" 
          password="password" />

answered Jan 21, 2010 at 9:38

Chris S

65.6k53 gold badges225 silver badges240 bronze badges

1 Comment

Codesleuth Over a year ago

But remember this modifies the whole process to run as this user, so you may bump into resource permissions when doing this. Also, have a look at CryptProtectData to help encrypt the password stored in the config file. See: msdn.microsoft.com/en-us/library/72wdk8cc.aspx

Rippo · Accepted Answer · 2010-01-21 09:35:51Z

-1

the best place to check the validity of your connections strings is here

I suspect that you have not quite got the format correct.

answered Jan 21, 2010 at 9:35

Rippo

22.5k14 gold badges83 silver badges118 bronze badges

Comments

Paddy · Accepted Answer · 2010-01-21 09:36:25Z

-1

Have you had a look at http://www.connectionstrings.com/? Always a good resource if you're having connection problems.

answered Jan 21, 2010 at 9:36

Paddy

34k15 gold badges82 silver badges121 bronze badges

Collectives™ on Stack Overflow

Setting the ASP.NET ConnectionString to a specific domain user

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related