Cannot create publication on SQL2000

Question

Post reply

Cannot create publication on SQL2000

BobTheElder

Mr or Mrs. 500

Points: 503
More actions
November 8, 2002 at 1:15 pm

#79598

I've recently installed new servers using Win2000 and SQL2000. In attempting
to create a publication for replication I get the following error:
Error 18483: Could not connect to server 'X' because 'distributor_admin' is
not defined as a remote login at the server.
I have another server on which I upgraded from SQL7 and it has a login
'distributor_admin' but the new install servers do not. I have executed the
TSQL:
exec sp_adddistributor @distributor = N'X', @password = N''
GO
but get the above error with a ref to 'Procedure sp_adddistributor, Line
130' where it failed. When I look in the procedure it appears that it should
create the login 'distributor_admin' but it fails.
Any help appreciated.
Bob

Viewing 8 posts - 1 through 7 (of 7 total)

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

Mkumari Hall of Fame Points: 3498 More actions · Answer 1

Can you give the details on how you are connecting to the SQL Agent.

Mkumari Hall of Fame Points: 3498 More actions · Answer 2

I am sorry, I mean How you are starting the SQL Agent services.

BobTheElder Mr or Mrs. 500 Points: 503 More actions · Answer 3

quote:
I am sorry, I mean How you are starting the SQL Agent services.

SQLServer and SQL Agent start at bootup using a login that has full privilages.

I had no problem with Replication on the previous server using NT/SQL7; after installing SQL2000 on the new server I attached all the databases I had detached from the previous version.

I have since hacked the 'distributor_admin' login from the upgraded server into the logins of the new server but still get the same error when I attempt to set up a publication.

Thanks

Bob

Mkumari Hall of Fame Points: 3498 More actions · Answer 4

Just to make sure can you double check if the user with which you are trying to start the SQL Agent services is in the local Admin group.

jmadren SSCrazy Points: 2055 More actions · Answer 5

If you haven't done so already, run the "Configure Publishing, Subscribers, and Distribution..." wizard in EM for your database. This will ensure that everything is configured correctly, including the user account for SQL Agent.

Jay

Jay Madren

BobTheElder Mr or Mrs. 500 Points: 503 More actions · Answer 6

Again appreciate the response.

Mkumari - The SQL Agent login is in the local Admin group.

jmadren - I've tried both the "Configure Publishing, Subscribers, and Distribution..." wizard and "Create and Manage Publications..." with the exact same results; the 18483 error.

Bob

BobTheElder Mr or Mrs. 500 Points: 503 More actions · Answer 7

In continuing to troubleshoot this problem I came upon the Remote Servers tab under Security in EM which had an entry. I deleted that entry and was warned that a remote server was attached. I found the connected server and deleted that.

Then when I ran the 'Configure' on the Replication tab in server properties I received an error that said the 'current server name' couldn't connect to the 'old server name' We renamed the server as the SQL7 box was still active while we were building the new W2K box.

I found an instruction on SWYNK.com to run

sp_dropserver 'oldservername'

sp_addserver 'newservername'

after a server rename.

I did that but then received the error 14114: '(NULL)' is not configured as a distributor. When I again attempted to configure for replication. However MS Knowledgebase 302223 describes the fix for that and I am now up and replicating.

Thanks for all who commented.

Bob