When I configure it using TCP/IP, I can connect (Tested using the option thrown by ODBC configuration) but unfortunately ASP pages (which I am trying to run, are written by someone else and of-course are undocumented) throw following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Specified SQL server not found
/includes/filename.asp, line 12
My connect string is as below:
Provider=SQLOLEDB.1; Data Source=SQL_SERVER; Persist Security Info=True; Initial Catalog=Contracts; User Id=u_id;PASSWORD=uid123
Somewhere in the server configuration (do not have server installed in the location I'm writing this message from) there is a dialog box where you tell what communication protocols are enabled on server side. Make sure that Named pipes are enabled. There is also Client network configuration utility. Look into it.
I am having somewhat of the same problem. I am trying to use SQL Server 7.0 on an XP Pro/IIS 5.x installation as well. The install seemed to go fine and I can register both a server group and a local SQL server.
However, when I try to connect to the SQL server Enterprise Manager throws, I get the following error message (without the Begin and End statements, of course... )
[Begin error message]
A connection could not be established to <my XP machine name> - You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server.
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the <my XP machine name> node) and try again.
[End error message]
Can anyone help me decipher exactly what it is the Enterprise Manager wants here and where I can download these components?