TheBugSlayer
Programmer
I am tryng to setup replication on a server but am getting an error because the server has been registered as (local); replication doesn't work with such names as '.' or '(local)'.
My problem is how do I rename the server since its on the same box? More clearly, the machine name is SRV1 but SQL Server is registered as '(local)'.
Although when I try to create the publication from another machine it fails with an 'Access denied' error.
Your help is highly appreciated.
My problem is how do I rename the server since its on the same box? More clearly, the machine name is SRV1 but SQL Server is registered as '(local)'.
Although when I try to create the publication from another machine it fails with an 'Access denied' error.
Your help is highly appreciated.