sql server replication: Cant Configure Distribution -- sql server replication

Re: Cant Configure Distribution

Hilary Cotter
9/21/2006 9:52:39 AM

sql server replication:

can you try this?
sp_adddistributor @distributor=@@ServerName
sp_adddistributiondb 'distribution', @security_mode =1

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Cant Configure Distribution

EightBits
9/21/2006 1:03:02 PM

Hello,

Every time that I try to enable Distribution (Right Click Replication and
select 'Configure Distribution') I get the error "SQL Server is unable to
connect to server SQLSRV\SQL. SQL Server replication requires the actual
server name to make a connection to the server.....". This server has never
been renamed as I have seen when looking into other issues. It was a fresh
install of SQL 2005, and we installed to a named instance as oppose to a
default. When I run select * from sys.servers I only get my instance name,
and if I run select @@servername I aslo get my instance name (SQLSRV/SQL).
To me this would indicate that everything should work as far as naming, but I
still cant get it.