SunQuest
           MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old January 22nd, 2004, 09:33 PM
MKSolutions MKSolutions is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 12 MKSolutions User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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!

Matthew

Reply With Quote
  #2  
Old January 23rd, 2004, 02:36 PM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
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.
__________________
El éxito consiste en una serie de pequeñas victorias día a día

MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html

Reply With Quote
  #3  
Old January 23rd, 2004, 03:44 PM
MKSolutions MKSolutions is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 12 MKSolutions User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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?

Thanks!

Reply With Quote
  #4  
Old January 23rd, 2004, 04:38 PM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
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?

Reply With Quote
  #5  
Old January 23rd, 2004, 07:55 PM
MKSolutions MKSolutions is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 12 MKSolutions User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Could not open connection to the host, on port 1433: Connect failed.

Reply With Quote
  #6  
Old January 23rd, 2004, 11:54 PM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
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

Reply With Quote
  #7  
Old January 23rd, 2004, 11:58 PM
MKSolutions MKSolutions is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 12 MKSolutions User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Thanks again!

Matthew

Reply With Quote
  #8  
Old January 24th, 2004, 12:15 AM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
Smile

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.

Reply With Quote
  #9  
Old January 24th, 2004, 12:24 AM
MKSolutions MKSolutions is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 12 MKSolutions User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Reply With Quote
  #10  
Old January 24th, 2004, 12:26 AM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
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.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > Unable to register SQL Server


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway