Error setting up distriburor: '(null)' is not configured as a Distribu 1

[NilsBevaart]

I am trying to set up one of our SQL Servers as a distributor. I started out using the wizzard in the Enterprise Manager (using all standard values), where I got the follwing error:
SQL Server Enterprise Manager could not configure 'UNI-SRV-PRD' as the distributor for 'UNI-SRV-PRD'
Error 14114: '(null)' is not configured as a distributer.

I then tried the QA:
exec sp_adddistributor 'UNI-SRV-PRD'
GO
exec sp_adddistributiondb
@database = 'distributor',
@security_mode = 0,
@login = 'sa',
@password = '****',
@createmode = 0

I got the following error:
Server: Msg 14114, Level 16, State 1, Procedure sp_adddistributiondb, Line 157
'(null)' is not configured as a Distributor.

Can anyone help me out?

Nils Bevaart

 

[Catadmin]

Is your server actually registered under that name or are you using the machine name when the server is registered as "local"?

Replication doesn't like the servers registered as local. You need to delete the registration and re-register it under its machine name.

If that's not the issue, please let me know.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[NilsBevaart]

The machine is registered under its name. Not local.

I tried this on the server itsself and on my desktop using a registered server in my EM.

Nils Bevaart

 

[NilsBevaart]

I found the answer. The server was not registered in the master database. Somehow the entry was missing. I added the server with the sp_addserver procedure.
After I stoped and started the server, it registered as a distributer as it should.

Thanks for the help.

Nils Bevaart

 

[SQLScholar]

How can you tell if it is registered on the Master DB?

Thanks

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[NilsBevaart]

I'm not sure (I started the thread a few months ago) but I believe my @@servername gave a null value.


Nils Bevaart

 

[SQLScholar]

Yeah so does mine - all sorted now. Thanks for time

D

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!