classic ASP & SQL 2005

I guess by default the only protocol turned on for SQL 2005 is "shared memory." So if you have a connection string with...

PROVIDER=SQLOLEDB

It will fail... with the following error...

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.

So you have two choices. 1.) Enable TCP/IP for the SQL Server; OR 2.) don't use SQLOLEDB which uses TCP/IP use SQLNCLI. or PROVIDER=SQLNCLI

Note to enable TCP/IP you use the SQL Server Configruation Manager which is one of the Configuration tools...