Can I rename my linked server., i am a newbie i searched online but confusing answers...so experts any opinions...
Renaming the linked server should be done through 2 steps: Configure alias at the source DB server : · RDP to the Source DB server ( Server hosting the DB instance where you are planning to create this new linked server ) . · Open Run>>>Alias>>>Add> select TCP/IP protocol from left panel >>put the connection string within Server name command box>> and assign the appropriate alias( the new name of linked serve)>>>>mark out dynamic port to be static like 1433 Accordingly to your configuration of the destination Configure the linked server to the destination DB Server · Go to the configurations of linked server, drop the current exists one , create another one with the new name used for the above alias … · Right click Linked server and Test connection , it should come out to you with a success message If it still persists, kindly let me know
