I have 3 seperate physical servers:
- Old Webserver (IIS6; Windows Server 2003)
- New Webserver (IIS7; Windows Server 2008)
- DB Server (SQL 2008; Windows Server 2008)
These are all non-domain standalone machines.
The sites on the new webserver connect to the db server for their data. I accomplished this by setting up a local user on each machine and the IIS 7 sites are in an app pool that has it's identity set to the created local user account. I am using windows authentication to connect to the db server.
Now, I am trying to migrate databases off of the old web server onto our db server and reconfigure the web sites to connect to the db server for their data.
So, I created the local user account on the old webserver to match the account on the db server, set up a new app pool with identity set to the local user account. The site is running, when the site goes to connect to the database server I get the error:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.