Posted by Erland Sommarskog on 02/17/07 11:01

(kk035@hotmail.com) writes:
> I'm migrating an IIS/SQL-Server application from Windows NT4.0 and SQL-
> Server 2000 to Windows 2003 Server and SQL-Server 2005.
>
> My problem is that it is not possible to connect local (IIS and SQL-
> Server 2005 are runnng on the same node) using ODBC. Running the
> applikation on a remote IIS (XPPro) all works fine. I can't see any
> differences in the ODBC-configuration.

Error messages? Connection strings?

Running IIS and SQL Server on the same machine is not a very good idea,
from the point of view of performance and security. The latter is
particularly critical, if the web application is on the internet.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]