CODEWITHSUNDEEP
asp.netweb-configconnection-string
Google
Google

Reputation: 31

Setting the ASP.NET ConnectionString to a specific domain user

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?

Upvotes: 3

Views: 11917

Answers (4)

Chris S
Chris S

Reputation: 65426

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" />

Upvotes: 4

edosoft
edosoft

Reputation: 17271

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.

Upvotes: 5

Paddy
Paddy

Reputation: 33857

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

Upvotes: -1

Rippo
Rippo

Reputation: 22424

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

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

Upvotes: -1

Related Questions