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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy