How to update sqlservername on production without affecting operation
I working setting up relication with non-trusted domain.On the publisher i want to configure the distributor, i get an error indicating i have to use the server name instead of the IP-Address or alias.I tried the server name but i notice i keep getting the same error: SQL Server is unable to connect to server'myserverip' Additional information: SQL Server replication requires the actual server name to make a connecti on to the server. Connections through a server alias,IP address, or any other alternate name are not supported Specify the actual server name 'WIN_2JQ9XXXXX'.(Replication.Utilities) But with the server: myservername i can connect with it through management studio. My linkserver uses the same servername without problem. when i run this script: Select @@SERVERNAME i got 'WIN_2JQ9XXXXX' at the same time i cannot login to management with this name:'WIN_2JQ9XXXXX'. Now my only option is to drop and create the same name:myservername.Since the link server is using this with out problem i want to Drop WIN_2JQ9XXXXX and give it a name:myservername and add this to the
domain.Is there a better approach i can take since it is a production server.