I tried to change the protocol to TCP/IP using SQL Server Client
utility, but I was unsuccessful.
Here is how I did it:
1. Started Sql client config util.
2. Went to Advanced tab.
3. Typed the server name in the "Server" edit box.
4. Selected TCP/IP Sockets in the DLL Name combo box
5. Pressed Add/Modify button.
6. Press Done button.
Then I ran ODBC applet in control panel and tried to configure the DSN.
After I pressed Next on the second step, I got the following error message:
Microsoft SQL Server Login:
SQL Server Error: 11
[Microsoft]ODBC SQL Server Driver][DBMSSOCN]General network error. Check
your network documentation.
SQL Server Error: 10061
[Microsoft]ODBC SQL Server Driver][DBMSSOCN]ConnectionOpen (connect()).
Once I changed the protocol back to named pipes, everything worked fine. I
tried this with some variations (e.g., I entered server's IP address in the
connection string edit box, etc.) several times with the same result.
Thanks in advance for your help.