can't configure replication

Someone here inadvertantly removed the distribution database leaving the
replication configs hosed & also some orphan publications. I figured out how
to clean all that up using the repl stored procs & the @.ignore_distributor
flag. Now, however we are unable to re-configure replication - can someone
please help? When trying to configure replication thru server properties it
gets to the configure distributor step & we get "SQL Ent Mgr could not
configure <server> as the Distributor for <server> - Error 14114: 'null' is
not configured as a Distributor - any help is greatly appreciated - thanks!
John F.
I got it, sorry to post & answer my own question - the servername was 'null'
so a simple sp_addserver fixed it - *DOH*
John F.
"John F." wrote:

> Someone here inadvertantly removed the distribution database leaving the
> replication configs hosed & also some orphan publications. I figured out how
> to clean all that up using the repl stored procs & the @.ignore_distributor
> flag. Now, however we are unable to re-configure replication - can someone
> please help? When trying to configure replication thru server properties it
> gets to the configure distributor step & we get "SQL Ent Mgr could not
> configure <server> as the Distributor for <server> - Error 14114: 'null' is
> not configured as a Distributor - any help is greatly appreciated - thanks!
> --
> John F.
|||John F. drukte met precisie uit :
> Someone here inadvertantly removed the distribution database leaving the
> replication configs hosed & also some orphan publications. I figured out how
> to clean all that up using the repl stored procs & the @.ignore_distributor
> flag. Now, however we are unable to re-configure replication - can someone
> please help? When trying to configure replication thru server properties it
> gets to the configure distributor step & we get "SQL Ent Mgr could not
> configure <server> as the Distributor for <server> - Error 14114: 'null' is
> not configured as a Distributor - any help is greatly appreciated - thanks!
Try :
exec sp_dropserver '<servername>'
GO
exec sp_addserver '<servername>','local'
GO
SELECT @.@.SERVERNAME
GO
You must STOP en START the SQL Server Service after this
(from www.sqlteam.com)