Home > Archive > MS SQL Server > November 2005 > TCP/IP fails on SQL Server 2000 on Win2k3









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author TCP/IP fails on SQL Server 2000 on Win2k3
Sam

2005-11-10, 8:23 pm

I have windows 2003, running SQL2k, SP4 installed.

I had disabled TCP.IP for a while. Recently added it back, restarted the
services.
it doesnt seem to be running on 1433 (checked it using netstat -an). i see a
UDP 1434, but thats about it.

does any one know why this problem exist? what is the solution to get it
back listening on TCP 1433?

I do have an warning on event log says: SuperSocket info: (SpnRegister) :
Error 8344. no other errors.

Please help!
Sam
Absar Ahmad

2005-11-11, 7:23 am

Please go to 'SQL Server Network Utility'. This can be either opened from the
'Start -> Programs -> MIcrosoft SQL Server -> Server Network Utility' or from
'the EM -> Properties Box of the SQL Server -> Network Configuration'.

Then select 'Properties' for the TCP/IP.

"Sam" wrote:

> I have windows 2003, running SQL2k, SP4 installed.
>
> I had disabled TCP.IP for a while. Recently added it back, restarted the
> services.
> it doesnt seem to be running on 1433 (checked it using netstat -an). i see a
> UDP 1434, but thats about it.
>
> does any one know why this problem exist? what is the solution to get it
> back listening on TCP 1433?
>
> I do have an warning on event log says: SuperSocket info: (SpnRegister) :
> Error 8344. no other errors.
>
> Please help!
> Sam

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com