December 19, 2003 at 7:16 am
Hi:
We are currently in the process of testing our
Webserver migration to Win 2000 and came across a
problem while setting up a ODBC dataserver connection
to the SQL database on USAWWWWBOXSTER2(WIN 2K)
servers. When I try to setup the connection on
WWWBOXSTER2 its giving the error message "Login failed
reason: Not associated with a trusted SQL server
connection" . Please advise!.
pls help as it is urgent!!
December 19, 2003 at 8:07 am
The old web server, was it in a trusted domain? Is the new one? If so, make sure you using the same domain account to run the web site (if you're using anonymous connections).
If not, check to see if you were mapping to a particular username (IUSR_<machine name> is usual). This user account will be created when IIS is installed (by default on Win2K). Obviously, if the two machine names are different, the two IUSR accounts will be as well. You can create on the new web server a local IUSR_ account matching the one on the old web server or you can create a local account on the SQL Server matching the new IUSR_ account. Make sure in either case, though, that IIS does not control the password. The password will need to be kept in synch.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply