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?

Solution 1

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.

Solution 2

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