Post reply

SQL Server Registration

  • January 30, 2004 at 7:32 am

    #81888

    I have a Remote SQL server and a Local server, i was able to register the remote server.

    Now what happend is, the default port of Remote server 1433 is changed to 2433.

    Do i need to do any changes in my LOcal server (Server Network Utility , Client Network Utitlity) to connect to Remote server. Thing is that some times it is connecting but not always.

     

    please suggest

     

  • January 30, 2004 at 8:02 am

    #492342

    If it's set to 2433, that means someone likely set it to hide the server. Not a big deal. Yes, when making the connection, you should specify the port. How are you making the connection? Linked server connection?

     

    K. Brian Kelley
    @kbriankelley

  • January 30, 2004 at 8:38 am

    #492356

    Bkelley,

    I am making the connection through EnterPrise Manager,

    Enterprise Manager ----->Microsoft SQL Servers ---->SQL Server Group

    then right click  and select New SQL Server Registration

  • January 30, 2004 at 8:57 am

    #492359

    Either create an alias using Client Network Utility or register the server as <server name>,2433 and that should work.

     

    K. Brian Kelley
    @kbriankelley

  • January 30, 2004 at 12:05 pm

    #492389

    I created an Alias in my local machine (Microsoft Sqlserver -->Client Network Utility-->Alias) i gave the following details

    Local Machine

    ----------------

    TCP / IP is selected

    Server Alias : Serv1

    Server Name : x.x.x.x (IP of the remote server)

    Dynamically Determine Port : Unchecked, and port numer is specified as 2433

    Remote Server

    ------------------

    In the Remote Server , Server Network Utility

    Only TCP/IP is enabled.

    TCP/IP Default port is 2433

    If i try to connect from EM, with the alias Serv1, it is giving the error : Server Does not exist or Acces denied..

     

    i tried changing the server port with 109,21,443,8080,80 etc.both on Remote server and Local Server..

    Still the same trouble

    I am able to reach the remote server through http (port 80) and ftp (port 21 and 443)

     

     

     

  • January 30, 2004 at 12:09 pm

    #492390

    Is this remote server hosted and/or out of your control? Behind a firewall, etc?

     

    K. Brian Kelley
    @kbriankelley

  • January 30, 2004 at 4:24 pm

    #492418

    If you can connect on certain ports and not others, some type of packet filtering is occurring. Most likely a firewall.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • January 31, 2004 at 6:00 am

    #492436

    Yes it is behind the firewall, The remote server is under my control, but Network  and Firewall is handling  another team of engineers.

    What my aim is, i should be able to register Remote SQL server without changing those network settings...

    I know some ports are opened in the network like 80 (HTTP),443 (SSL),109 (POP)

    out of these only HTTP (80) is used by other users .

    443 and 109 is enabled but nobody is using, can i make use of 443 or 109 ?

  • January 31, 2004 at 9:37 am

    #492440

    It's probably a better solution to coordinate with the other team of engineers for a specific port other than 80, 109, or 443. For that matter, other than 1433 as well. That way they can ensure ACLs are in place to restrict what IP addresses can access the SQL Server, etc.

     

    K. Brian Kelley
    @kbriankelley

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply