I have 2 Windows 2003 servers. A server that our website on it running on IIS6. I have a second server that has an Access database on it that contains login info (and other stuff) for the website. It's also used for a proprietary application we use so I'd rather not have to move it. I have set up an odbc system dsn to the Access database on the remote server. It fails to log in and there is an access denied message in the security log on the server with the database. The server with the website is using it's local IUSR_machine account for the website. I've tried setting up the odbc using the Domain Admin account but, it seems to ignore that. If I make a copy of the Access database and put it on the same server as the website it works fine.
My question is can I add the IUSR_webserver account to the remote database server's users group?
If not, what might some other ways to go about this be? I saw a KB that suggested making the IUSR account on both systems have the same password but, that didn't seem to work.
My question is can I add the IUSR_webserver account to the remote database server's users group?
If not, what might some other ways to go about this be? I saw a KB that suggested making the IUSR account on both systems have the same password but, that didn't seem to work.