Unable to launch configure distribution wizard

PROBLEM

When attempting to launch the configure distribution wizard I receive the following error:

SQL Server is unable to connect to server ‘ABC-LAP-DEF03’.SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘ABC-LAP-DEFGHI’.

Note the second server name in the error is different from the first.

SOLUTION

1. Drop all servers found in select * from sysservers (It may be sufficient just to drop the local server)

2. create the server name for my local using sp_addserver @server=’SERVERNAME’, @local=’LOCAL’

and then recreate the rest of the servers.

3. restart the server service

4. I always connect using “localhost” when I attempted to configure distribution I was greeted with the same error, however when I changed my server to the actual server name it worked.

Advertisements

One Response to “Unable to launch configure distribution wizard”

  1. Scott Says:

    For SQL Server 2008 R2 users connected to a database other than master that’s select * from sys.servers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: