I'm trying to create a publication on a Windows 2003 server running SQL
server 2005. I'm getting the following message when I try to create a
disctributor:

SQL Server is unable to connect to server '123abc'
Additional Information:
SQL Server replication requires the actual server name to make a connection
to the server. Connections through a server alias, IP, or any other
alternate name are not supported.
Specify the actual server name, ''.(Replication .Utilities)

Why is the system telling the acutual name is ''?

How do I resolve this issue? I've tried everything to get this working.


Thanks

There could be an issue with the server's name:

Use Master
go
Select @@Servername

This should return your current server name but if it returns NULL then try:

Use Master
go
exec Sp_DropServer 'OldName'
go
Use Master
go
exec Sp_Addserver 'NewName', 'local'
go

Then stop and Start SQL Services.

HTH,

Paul Ibison

I did the select of the server name and received a null as the result. I
tried the add 'exec Sp_DropServer '1234'' and then 'exec Sp_AddServer '1234',
local'. I'm want the server name to remain the same.

The 'Configure Distribution Wizard' continue to give the same results:

Specify the actual server name ''.(Replication.Utilities)

Thanks

"Paul Ibison" wrote: