Sometimes when we try to configuration relpication we might receive the below error which says that "SQL Server replication requires the actual server name to make connection to the server"
This can happen during the situations
In the second case, to fix the issue we need to update the system catalogs by dropping and adding the server and restarting the SQL Server services. The updation of system catalogs can be done using the below queries.
This can happen during the situations
- When you are connected to the server in object explorer using the IP address
- When the actual server host name hosting the SQL server database engine is changed
In the second case, to fix the issue we need to update the system catalogs by dropping and adding the server and restarting the SQL Server services. The updation of system catalogs can be done using the below queries.
USE master GO EXEC sp_dropserver 'OldServerName' USE master GO EXEC sp_addserver 'NewServerName',local
4 comments:
Very nice post sandesh. keep post like this errors and scenarios..
Thanks,
Prasad
How do you connect to a server over the internet without a VPN, without IP address/URL, without an alias, using a hostname (and in my case with a port specified) ?
Without access to server you cannot connect to it. You should be inside the LAN or you should have access through VPN to connect to the server.
Mua vé máy bay tại Aivivu, tham khảo
Vé máy bay đi Mỹ
giá vé máy bay mỹ về việt nam
vé máy bay từ đức về sài gòn
bay từ nga về việt nam
chuyến bay từ anh về việt nam
ve may bay tu phap ve viet nam
Chuyến bay cho chuyên gia nước ngoài
Post a Comment