Discussion Locked

Error creating MSSQL publication

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I try to create a publication on MSSQL server using the publication wizard I get the error:

SQL Server Enterprise Manager could not complete the wizard because @@SERVERNAME
for '' is NULL.
Use sp_addserver to set @@SERVERNAME

I have tried to set the server name using the store procedure but without any
luck.

2 replies

by mtnsqs

You will need to be logged on as sa to do the sp_addserver.

Once done check that @@SERVERNAME is set properly.

by ptdnet

I've tried this and unfortunately it didn't work. If I run sp_helpserver I get localhost and the proper server name.

This discussion is closed to new replies.