@@servername = NULL 1

[Moonrider]

Hi !

I wanted to set up my sql server for replication
I always get the errormessage :
"Error 14114 : '[null]' is not configured as distributor"

the statement
SELECT @@servername
returns NULL

I tried to change that with "sp_addserver ..."
and got 3 times '1 row affected'
afterwards I restarted my sql server service
but I still got the same answer

actually all I want is a replication set up
can somebody help me ???

my servers name is 'NET'
I tried the same on another PC
servers name 'LNET' but the same error
I am working in a working group
with fixed IP-Numbers

both of the PC's are running 'W2K SERVER'

thanks for any reply

 

[mrdenny]

When doing the sp_addserver you need to include the local flag.

sp_addserver 'servername', 'local'

That should fix it.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Moonrider]

Praise God !!!

Thank you very much
it worked
and also the replication

sometimes it is so easy

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)