Connection SQLServer2005 failed with error message:
Error type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft] [ODBC SQL Server Driver] [DBNETLIB] General network error. Please check your network documentation.
My connection string is: Driver={sql Server}; Server=192.168.10.139;database=testfax; uid=sa;pwd=xxxx;
Oddly enough, I will be able to connect to the server (local) or native name (Pcwhat), but the IP is not connected, even if writing 127.0.0.1 is unsuccessful.
Then finally found the answer on the Internet, because the TCP/IP protocol is not enabled (by default is disabled), so as long as the start of this protocol can be, see:
After this configuration, the other computer can be connected to the database through the IP address, do not believe it try it!
Connection SQLServer2005 failed--[MICROSOFT][ODBC sql Server Driver][dbnetlib] General network error. Please check your network documentation