Post reply

Can't connect to New Publication Wizard.

  • March 24, 2009 at 7:22 am

    #201437

    I am connected to SQL Srever 2005 in such a format: server_name,port# and I can't avoid port number, it is not default.

    When in SSMS in Replication/Local Publications and tried to create new publication, I receive an error

    "SQL Server is unable to connect to server 'server_name,port#'.

    Additional information:

    SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name is not supported. Specify the actual server name , 'server_name\instance_name'. (Replication.Utilities)"

    As I guess, I should omit port #, but without it I cannot connect to SQL Server, this ia how it was setup by our DBA's. Is there other work around this problem ?

    Thanks

  • March 24, 2009 at 8:47 am

    #965278

    Create a local SQL Server alias. SQL Server replication tools are ***very*** picky about Server Names.

    -Noel


    * Noel

  • March 24, 2009 at 11:53 am

    #965467

    Thanks Noel. This worked.

  • March 25, 2009 at 12:47 pm

    #966205

    glad you got it working.


    * Noel

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

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