I'm not sure where to start with this although I'm sure it's quite common. I've searched all over and it seems the problem and resolutions can vary.
I have a standalone WebServer IIS6. The SQL server is in a domain. The database has granted network service the proper rights to the database. The SQL server also has IIS installed and the only thing I changed between that and the standalone is the connection string IP.
I've tried creating a local account on the SQL box and granted it rights to the DB, didn't work. Using this same config file locally on the SQL server and changing the IP address to localhost everything works great. I can successfully test a connection using a udl file. I was logged in as administrator on the IIS server when I did that and the IIS worker process identity is using the Network Service account. SQL is set to use TCP/IP only and remote connections is enabled. I thought SSPI was the same as Trusted_Connection=Tr ...
Go to the complete details ...