Thanks for the reply.
In Q176377 it makes reference to fixed but for Kerberos only...
1) Is this a method that can be defined in the connection string?
Comment from Q:
By eliminating the need for IIS to create an authenticated connection to SQL
Server, you can work around this problem. To do this you must use a data
source name (DSN) that does not look out to the network for the SQL Server
and instead looks directly to the local machine. This can be done by using
the "(local)" setting in a System DSN.
2)Does this mean if the programmer was to use a Local DSN on the web server
it would do a trusted connection to the remote SQL? Assume it was defined
as such in the local DSN creation. In the past they have used DSN-Less
connection strings.
Nothing wrong with your domain. See:
http://support.microsoft.com/kb/176380/EN-US/
http://support.microsoft.com/kb/176377/EN-US/
--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserv...y/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running
IIS