SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 error while logging
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ssss28
Starting Member

18 Posts

Posted - 04/15/2008 :  16:48:02  Show Profile  Reply with Quote
I restarted the service.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/15/2008 :  16:52:02  Show Profile  Visit tkizer's Homepage  Reply with Quote
What is the data value for ProtocolList in the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib

Does the Tcp key exist under SuperSocketNetLib?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/16/2008 :  11:00:24  Show Profile  Reply with Quote
What is the data value for ProtocolList in the following key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib

: - Is this the same as the list of IP addresses available in the TCP/IP properties in SQL Server Configuration Manager?

Does the Tcp key exist under SuperSocketNetLib?
Yes, I have the Tcp folder under SuperSocketNetLib. This has 3 more sub folders whose names are IP1, IP2, IPAll.

The display name of IP1 says "Specific IP Address" and the IP Address is my machine address.

The display name of IP2 says "Specific IP Address" and the IP address is the default address.

The display name for IPAll says "Any IP address" and this does not have any IP address but has a Tcp port which is 1433.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/16/2008 :  13:36:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
In the SQL Server log towards the bottom (around the time when the service was restarted or the server rebooted), do you see a line like this?:

Server is listening on [IPAddress <ipv4> PortNumber].

We should test if you can telnet to the server and port. Open up a cmd window. Type: telnet ServerName PortNumber

Also try telnet IPAddress PortNumber.

If you don't get an error but rather get a blank screen, then it is working properly.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/16/2008 :  13:48:19  Show Profile  Reply with Quote
Following is the message I got from the error log file of the SQL server:

"2008-04-16 13:44:08.70 Server Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use."
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/16/2008 :  13:53:07  Show Profile  Visit tkizer's Homepage  Reply with Quote
Aha, so it's unable to use 1433! Could you try a different port (via Config Manager) and restart the service? It is recommended to pick a port over 10000 anyway to lessen hacking risks.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Edited by - tkizer on 04/16/2008 13:53:20
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/16/2008 :  13:56:49  Show Profile  Reply with Quote
How do I try a different port (via Config Manager)? Please help.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/16/2008 :  14:00:12  Show Profile  Visit tkizer's Homepage  Reply with Quote
In Configuration Manager, select "Protocols for MSSQLSERVER" under SQL Server 2005 Network Configuration. Double click on TCP/IP. Go to the second tab. At the bottom in IPAll, leave TCP Dynamic Ports blank and then type in a port for TCP Port. Click OK and then restart the service "SQL Server (MSSQLSERVER)" in the Services applet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/16/2008 :  14:06:38  Show Profile  Reply with Quote
Can I give any number for the port number or do I need to give a specific number?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/16/2008 :  14:11:44  Show Profile  Visit tkizer's Homepage  Reply with Quote
Any number below 65536 I believe. I recommend that it be over 5 digits though, so over 10000.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/16/2008 :  14:18:22  Show Profile  Reply with Quote
I have given 10001, but still I am getting the same error

Server TCP provider failed to listen on [ 'any' <ipv4> 10001]. Tcp port is already in use."
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/16/2008 :  14:23:23  Show Profile  Visit tkizer's Homepage  Reply with Quote
I'm not sure how to do it, but you are going to need to figure out what is blocking the ports. Perhaps you can try disabling your virus scanner.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/16/2008 :  22:34:10  Show Profile  Reply with Quote
You can get all used port on the server with 'netstat -a'.
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/17/2008 :  11:26:16  Show Profile  Reply with Quote
I got all the listening ports using netstat, but I could not see the default port 1433 or the one I have stated which is 10001.

With netstat, the state of some ports was Listening, some were Established and some were time_wait. Can anybody please explain what these states mean?

I do not know how to unblock the ports. Can anybody please help me in this issue?

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/17/2008 :  12:42:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
Do you have a server administrator that you can have help you? This isn't a SQL Server problem anymore, so I can't be of much help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

ssss28
Starting Member

18 Posts

Posted - 04/17/2008 :  13:43:10  Show Profile  Reply with Quote
Thank you very much for your help till now.

Can you please advice whether uninstalling the SQL server and re-installing help to fix the issue? I do not have much data in the database.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36817 Posts

Posted - 04/17/2008 :  13:44:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
I doubt that will fix it as something is blocking the port.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000