January 22nd, 2004, 09:33 PM
Unable to register SQL Server
I have two servers, one running 2000 Server, one running 2003 Server. MSSQL is installed on both. From my home computer, I am able to register the SQL server on the 2000 server, but I am not able to register the 2003 server. ALso, I am unable to register the 2000 server on the 2003 server. It appears that I can not register anything in or out of the 2003 server. The firewall is turned off...so there should be nothing to block it. I can ping it, connect to it, etc....everything except register the SQL. SQL SP3 is installed. Is there something by default in 2003 that is blocking any SQL ports or something?
Thanks for any help!
January 23rd, 2004, 02:36 PM
What version are the MS SQL Servers? Have you checked that port 1433 is open on the Windows 2003 Server? Perform a netstat -an from a dos window to verify.
And yes, by default, MS `attempted` to secure ports in the 2003 release.
January 23rd, 2004, 03:44 PM
Thanks so much for the help! Both servers are running SQL 2000. I performed the netstat, it listed this for port 1433:
TCP 0.0.0.0:1433 0.0.0.0. Listening
I did notice that there are other ports listeningm but they have the server IP where the first set of zeros is. Is this the problem? The firewall is turned off for testing...is there somewhere else in 2003 that ports are blocked?
January 23rd, 2004, 04:38 PM
From a remote host dos window try this:
telnet win_2003_ip_address 1433
Do you get a connection refused or is a connection made?
January 23rd, 2004, 07:55 PM
Could not open connection to the host, on port 1433: Connect failed.
January 23rd, 2004, 11:54 PM
If you could not telnet to port 1433 on the remote server then you can check the following. (Not complete)
The MS SQL server is actually listening on port 1433. Have you been able to successfully log in locally to this machine? Verify that it is using 1433.
You are not getting dropped at a router/firewall/TCP port restriction
January 23rd, 2004, 11:58 PM
That is correct. I can successfully log into the SQL server locally on itself. I know SQL is running, and that it is listening on that port. But, I am unable to go in or out from that server. I basically wanted to double check that there were no special port blocks in the new 2003 that I did not know about. I think I have narrowed it down to the server ISP blocking something. I will post the results if/when I find them.
January 24th, 2004, 12:15 AM
Wait. You did not mention that this machine was hosted by an ISP, which will most likely block port 1433 from inbound/outbound connections unless you request that the port be open.
January 24th, 2004, 12:24 AM
None of my other servers have ever been blocked. I have had them at FastServers and MileHighNetworks. This one is currently at ServerBeach. Just testing it out.
January 24th, 2004, 12:26 AM
I recently set up with a new ISP, and I had to explicitly ask that a port I was accustomed to being open with previous ISP, be opened for me. Different strokes for different folks.