?
Solved

SQL Replication (@@ServerName)

Posted on 2001-08-16
2
Medium Priority
?
547 Views
Last Modified: 2012-08-13
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
Comment
Question by:talal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
mathavra earned 600 total points
ID: 6394165
try

sp_addserver 'MyServer', local, MyServer

and recycle the server.
0
 

Author Comment

by:talal
ID: 6464581
Sorry, it took me awhile.

Thanks for your answer.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question