Post reply

Registering server

  • August 5, 2005 at 1:26 pm

    #186881

    I have a second instance of SQL isntalled on one of my servers. I am able to register the second instance using servername on EM however if i try registering thru IP Address it fails and shows up message as

    Reason: Invalid Connection

    ConnectionOpen: Invalid Instance.

     

    if i check from cluster administrator i see the correct Ip address but on trying to connect using that teh error shows up. Can anyone help me  if they have had this problem before.

     

  • August 5, 2005 at 10:35 pm

    #580222

    additional instances must be identified by IP AND port numbernote the comma after the ip address)

     you should also be able to connect to the instance by connecting to IPaddress,port;

    ie 65.34.234.179,1207

     

    you use that format whether it is in QA, a connection string in ASP or .NET; it's not ip-colon-port like a web page, it's ip-comma-port.

    see this post for a similar issue; there's is a script to run in QA to find which port the instance is listening too; it may not be 1433 as you are expecting.

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=184041#bm185404

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 7, 2005 at 9:42 am

    #580277

    You should also be able to register by name.

Viewing 3 posts - 1 through 3 (of 3 total)

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