Sql Server Replication does not support nicknames

  • 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

  • This was removed by the editor as SPAM

  • 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

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

  • Thanks for the suggestion.

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


    Priyesh

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

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