Post reply

Sql Server Replication does not support nicknames

  • April 17, 2004 at 4:13 am

    #108131

    I am trying to work with replication. While I am setting up replication on the 

    sql  server and I'm having a problem. They named the server as local which

    gives me an error when I try to setup replication.

    The error is :

    "SQL Server does not support nicknames, such as "." or "(local)", as a

    server names. Delete the SQL Server registration for this server and

    register it using  the actual server name."

    I tried a lot to slove it.. but i was not able to do it.

    When we use Select @@ServerName it Gives me actula Machine Name ie. DBServer. But in Enterprise Manager its showing [Local].

    Thanks in advance

    Priyesh 


    Priyesh

  • April 20, 2004 at 8:11 am

    #503494

    In Enterprise Manager try right clicking and Deleting the SQL Server Registration, then re-register the server this time using the servername rather than (local) and then try setting up replication again.


    Shamless self promotion - read my blog http://sirsql.net

  • April 20, 2004 at 8:22 pm

    #503573

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503572

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503571

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503570

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503569

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503568

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503567

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503566

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503565

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503564

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503563

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 20, 2004 at 8:22 pm

    #503562

    Thanks for the suggestion.

    But there is no other way than deleteing the server registration.????


    Priyesh

  • April 21, 2004 at 4:54 am

    #503616

    You are not dropping the server, rather re-registering it with the correct name rather than (local)


    Shamless self promotion - read my blog http://sirsql.net

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

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