- Open SQL Server Management Studio and click New Query.
- Type Select @@ServerName to find out the current server name. In our example, we’ll be changing the server name from RKF to REH.
- Next, type sp_dropserver ‘RKF’
- You are now ready to add the correct name by typing sp_addserver ‘REH’.
- Stop sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver.
- Restart SQL server by typing net start msssqlserver.
- Restart SQL server agent by typing net start sqlserveragent.
- Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.
https://community.dynamics.com/product/gp/gptechnical/b/gplesliev/archive/2012/02/02/change-the-name-of-the-sql-server.aspx
No comments:
Post a Comment