Replication error 18483

Question

Replication error 18483

Ed7

SSCrazy Eights

Points: 8519
More actions
January 11, 2008 at 1:39 pm

#178099

I setup trans replication between sql 2005 (subscriber) and sql 2000 (publisher).
When config the distributor, I run into an error 18483 could not connect to server 'GHS0023RPT' because 'distribution_admin' is not defined as a remote login at the server.
I search in forum and find many answers but not really help.
1. I already setup server alias on sql 2000 and sql 2005.
--- SQL Server client Network utility (sql 2000)
--- SQL Server Configuration Manager (sql 2005)
2. On sql 2000. I validate the window server 2003 property. The computer name is "GHS0023RPT'.
3. Select @@Servername. It returned "GHS023RPT'.
Please help.
TJ

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

wayne gillett SSC Enthusiast Points: 110 More actions · Answer 1

I might be a bit late with this answer but I noticed a difference in the computer name (item2) and @@servername (item3). If that was the point you were making then you could run the following script. It will correct the error. You will have to stop and start SQL.

-- Use the Master database

USE master

GO

-- Declare local variables

DECLARE @serverproperty_servername varchar(100),

@servername varchar(100)

-- Get the value returned by the SERVERPROPERTY system function

SELECT @serverproperty_servername = CONVERT(varchar(100), SERVERPROPERTY('ServerName'))

-- Get the value returned by @@SERVERNAME global variable

SELECT @servername = CONVERT(varchar(100), @@SERVERNAME)

-- Drop the server with incorrect name

EXEC sp_dropserver @server=@servername

-- Add the correct server as a local server

EXEC sp_addserver @server=@serverproperty_servername, @local='local'

Link for script: http://support.microsoft.com/kb/818334

Wayne

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 2

Ed7

SSCrazy Eights

Points: 8519

January 23, 2008 at 12:00 pm

#771014

It resolved. Thanks a lot for your help.

alpeshpradhan SSC-Addicted Points: 432 More actions · Answer 3

so you mean to say that machine name specified in windows and sqlserver name should be same while creating distributor?

I am facing similar issue in which my machine name is "IP-0AC11DDC" and sqlserver name is "SQLSERVER1"

when i tried to make this server as distributor, it tried to make connection to "IP-0AC11DDC" and throen message "microsoft sql server, error: 18483" could no connect to "IP-0AC11DDC" becasue 'distributor_admin' is not defined as remote login at the server.

please clarify.

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 4

Hello,

Can you explain your database replication environments?

Are you setting up PULL Transaction database replication with a remote distributor or

PUSH Transaction database replication with local distributor?

Thanks,

Edwin