SQL Server problem

[Nikolay Petrov]

I get errors while I try to connect from ASP .NET Web Service to a SQL
server.
After an hour of debuging I found that the problem is the authentication
between ASP .NET worker process and the SQL server.
After I changed the user in web.config file for the ASP .NET service
everything went well.

My question is how to make the SQL connection to work with the ASP .NET
worker account?

TIA

 

[Jeff Johnson [MVP: VB]]

I get errors while I try to connect from ASP .NET Web Service to a SQL
server.
After an hour of debuging I found that the problem is the authentication
between ASP .NET worker process and the SQL server.
After I changed the user in web.config file for the ASP .NET service
everything went well.

My question is how to make the SQL connection to work with the ASP .NET
worker account?

I could be wrong, but I believe that account is a local account, not a
domain account. This means that you won't be able to use Windows
Authentication to connect to your SQL Server, and sending a user ID and
password will be your only alternative.

 

[Nikolay Petrov]

Tnanks

I could be wrong, but I believe that account is a local account, not a
domain account. This means that you won't be able to use Windows
Authentication to connect to your SQL Server, and sending a user ID and
password will be your only alternative.

 

[Greg Burns]

Are these computers (the web server and IIS) on the same domain?

If they are, you can set up a local ASPNET user on the SQL box and use
passthrough authentication.

"Reset the ASPNET account's password to a known value and then create a
duplicate account (with the same name and password) on the remote computer."

Under: "Process Identity for ASP.NET"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch08.asp

Another good link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html/secmod15.asp

HTH,
Greg