topic Re: TCP/IP not enabled error in Server Management - Systems Insight Manager

TCP/IP not enabled error

Sam Moayedi — Mon, 14 Apr 2008 04:38:52 GMT

Hello All,
Installation of SIM 5.2 on HP server with WIN 2003R2 X64 with SP1 and SQL sever 2005 SP2
fails with error "TCP/IP Protocol is not enabled for specific database server. Please use the SVRNETCN.exe to enable the TCP/IP protocol"
I run SVRNETCN.exe and it is empty (General and Network Libraries tab) as shown in attached file but configuration management shows TCP/IP has been enabled.
Where else do I need to check?
Thanks for your help

Re: TCP/IP not enabled error

V Deepak Kumar — Mon, 14 Apr 2008 05:57:43 GMT

Make sure TCP/IP library is present from the libraries tab.

Re: TCP/IP not enabled error

Sam Moayedi — Mon, 14 Apr 2008 06:19:14 GMT

Thanks Kumar for the quick response but as I mentioned Libraries is empty how can I add them
Is SQL 2005 still using SVRNETCN or not
Thanks

Re: TCP/IP not enabled error

V Deepak Kumar — Mon, 14 Apr 2008 06:47:18 GMT

Best way would be to reinstall.
Stop SQL Services
If thats not an option
Download all the network libs mentioned in the attached image with the version shown and download them to the SQL INstall directory. Dump them into this "C:\Program Files\Microsoft SQL Server\MSSQL\Binn"

Start SQL Services
A nice article on "http://msdn2.microsoft.com/en-us/library/aa174500(SQL.80).aspx"

Enable TCP/IP and Named Pipes from SVRNETCN.
Hope this helps.
Thanks
Deepak

Re: TCP/IP not enabled error

V Deepak Kumar — Mon, 14 Apr 2008 06:49:14 GMT

Forgot to attach the image.
If reinstall is not an option try the steps mentioned earlier.
Thanks
Deepak

[If my solution works assign me points]

Re: TCP/IP not enabled error

Sam Moayedi — Mon, 14 Apr 2008 07:11:50 GMT

Hello Kumar
Are you running SQL 2005, is it the same in 2005?

Re: TCP/IP not enabled error

Sam Moayedi — Mon, 14 Apr 2008 08:32:57 GMT

I contacted Microsofr and this is their response regarding SVRNETCN.exe
"That tool is for SQL Server 2000, not 2005. For 2005, you use the "SQL Server Configuration
Manager".
So How am I going to install SIM on SQL server 2005 since it is checking SVRNETCN.exe to verify network libraries and they are blank in SQL server 2005
Thanks for your help

Re: TCP/IP not enabled error

Change_happens — Mon, 14 Apr 2008 08:47:56 GMT

yes 2005 uses "Server Configuration
Manager" so in this u have to . SQL 2005 uses diff port may be that is disabled in ur PC.
or u can add that library in Alias section of manager.
Type cliconfg in RUN and see Alias add it there. or Just enable port it or see below:
whole information:
http://support.microsoft.com/kb/839269