problem with Configure Replication...(SQL SERVER 7.0)

[cdnamm]

Hello everyone,
I want to configure the replication by going to Enterprise Manager -> Replicate Date -> Configure Replication. SQL Server will display the wizard and as soon as I clicked Next the error message "SQL Server Enterprise Manager could not complete the wizzard because @@SERVERNAME for '' is NULL" will pop up. I already add the server name for this server using sp_addserver, but it still give me the message again the next time I tried. Could somebody help please? Thank you!
cdamm

 

[cutiger93]

Looks at the sysservers table. You probably have a null value in there where the servername should exist.
Select * from master.dbo.sysservers

You servernet name should resemble your servname

 

[cdnamm]

Hi,

I already check that, the srvname does exist.

cdnamm