- An ASP.NET worker process (Aspnet_wp.exe) runs under the default ASPNET account.
- You do not enable impersonation on that application.
- You use the SQL Server .NET Data Provider or the OLE DB .NET Data Provider to connect to a database.
- Turn on impersonation on your ASP.NET application. This method works if the impersonated user has access to the computer and to the database server that you access.
- Use Transmission Control Protocol/Internet Protocol (TCP/IP) instead of the named pipes protocol to connect to the database. To do this, add the following attribute to the connection string: For example:
"Network Library =dbmssocn"
"User ID=myUserId;Password=myPassword;Initial Catalog=Pubs;Data Source=myServer;Network Library =dbmssocn"
- Check the database for the protocols that are enabled. For a SQL Server database, run the Server Network Utility to check for specific protocols.