For example, we have a Windows account named drwho
and password in SQL Server 2008. In the connection string, we disabled integrated security and added a user ID And the password value.
and password in SQL Server 2008. In the connection string, we disabled integrated security and added a user ID And the password value.
User Id=THEDOMAIN\drwho;Password=......
However, ASP.NET has always thought We are using SQL Server authentication.
Any suggestions?
You cannot use domain user/pass to connect to SQL Server. If you want to do as a domain user To connect, you need to specify integrated security and run the ASP.NET process as that user.
For more information, please refer to this page of Microsoft.
For more information, please refer to this page of Microsoft.
For example, we are in SQL Server There is a Windows account named drwho
and password in 2008. In the connection string, we disabled integrated security and added user ID and password values.
User Id=THEDOMAIN\drwho;Password=......
However, ASP.NET has always thought we are using SQL Server authentication.
What’s there Suggest?
You cannot connect to SQL Server using a domain user/pass-through. If you want to connect as a domain user, you need to specify integrated security and use that user Run the ASP.NET process as the identity.
For more information, please refer to this page of Microsoft.