Results 1 to 12 of 12

Thread: Registration Problem

Threaded View

  1. #1
    Join Date
    May 2009
    Posts
    41

    Registration Problem

    Hi

    I am facing problem while registering a server on my local system.

    We have an SQL SERVER 2005 on Windows server 2003 machine and the port is dynamic (say 1078). i am able to register the server on my local machine without any problem.

    Now we have prepared one more SQL SERVER 2005 but this time on Windows server 2008 with the same dynamic port.

    i am not able to register this server on my local machine.

    I am getting following error message:

    TITLE: New Server Registration
    ------------------------------

    Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

    ------------------------------
    ADDITIONAL INFORMATION:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 121)

    For help, click: http://go.microsoft.com/fwlink?ProdN...1&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    I am sure about all the logins and passwords!!

    is there any different option we need to choose or sth when we install SQL Server 2005 on windows server 2008 machine???

    We are using TCPIP for connectivity!!
    And the port mentioned above is open from my system!!

    Please suggest
    Last edited by yogesphu; 08-17-2009 at 04:12 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •