Setting the ASP.NET ConnectionString to a specific domain user

Question

Hi,

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?

Answer 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.

Answer 2

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

Answer 3

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.

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