SQL Replication (@@ServerName)

Hello I am getting the following error trying to work with replication between 2 SQL servers.
By the way, I am not sure if this matters but i want the distributor to be SQL 7 and the client to be
SQL 2000.

The error i am getting is:
SQL Server Enterprise Manager could not complete the wizard because @@SERVERNAME for '' is NULL.
Use sp_AddServer to set @@ServerName

By the way, I tried to execute sp_AddServer and restarted the server but did not work. This is What
i typed:
Exec sp_AddServer 'MyServer'
It did not return any error. But it did not help.

Please help.
Thank you,
Who is Participating?
mathavraConnect With a Mentor Commented:

sp_addserver 'MyServer', local, MyServer

and recycle the server.
talalAuthor Commented:
Sorry, it took me awhile.

Thanks for your answer.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.