Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 555
  • Last Modified:

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,
0
talal
Asked:
talal
1 Solution
 
mathavraCommented:
try

sp_addserver 'MyServer', local, MyServer

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

Thanks for your answer.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now