Friday, March 23, 2012

How to enable TCP/IP on SQL Server

Hi all:
i have tried enabling the TCP/IP protocol in SQL Server using the Server
Network utility and Client Network Utility.Once I restart the server I check
the error log which says
SQL server listening on Shared Memory, Named Pipes.
2005-03-19 23:45:14.96 server SQL Server is ready for client connections
Can anyone please guide me on how to resolve this problem ..
ThanksHi
Run "server Network Utility" in the SQL Server Start Menu
Or from the command line "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\svrnetcn.exe" (path depends where you installed SQL
Server)
Or in Enterprise Manager, right click on the server, select properties, then
click on Network Configuration Button.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"VHK" <VHK@.discussions.microsoft.com> wrote in message
news:41ECE136-B55E-49EA-8C82-11356923DC6E@.microsoft.com...
> Hi all:
> i have tried enabling the TCP/IP protocol in SQL Server using the Server
> Network utility and Client Network Utility.Once I restart the server I
check
> the error log which says
> SQL server listening on Shared Memory, Named Pipes.
> 2005-03-19 23:45:14.96 server SQL Server is ready for client
connections
> Can anyone please guide me on how to resolve this problem ..
> Thanks
>

No comments:

Post a Comment