Question

Locked

how to configure SQL 2005 replication

By jazzygodfrey ·
hi, i am trying to configure replication on my local machine where sql server is, and it gives me the following error when
i right click replication--configure distribution, what could be the problem?;

SQL Server is unable to connect to server 'IS-GODFREY'. (Configure Distribution Wizard)


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, 'PSPF-PC'. (Replication.Utilities)

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

how to configure SQL 2005 replication-SOLVED

by jazzygodfrey In reply to how to configure SQL 2005 ...

I found out that somehow my server name was renamed, it was not equal to the instance name when i ran sp_@@SERVERNAME
OR'
SELECT @@SERVERNAME As [@@SERVERNAME],
CAST(SERVERPROPERTY('MACHINENAME') AS VARCHAR(128)) + COALESCE('' +
CAST(SERVERPROPERTY('INSTANCENAME') AS VARCHAR(128)), '') As RealInstanceName


I ran the query
exec sp_dropserver [oldservername]
GO
exec sp_addserver [newservername], 'local'
GO

and then Restarted the sql server service
and boom!

I can now configure replication!
solved my own puzzle!

Back to Networks Forum
2 total posts (Page 1 of 1)  

Hardware Forums