How to Rename the Microsoft SQL Server
- 1). Open the SQL Server Query Editor from the Start menu of your system.
- 2). Enter the command: "sp_dropserver 'old_name'" without quotes. Enter the command "go" just after it.
- 3). Enter the command "sp_addserver 'new_name', 'local'" without quotes, followed by "go" under it. Press the "Submit Query" button.
- 4). Open a command prompt. Press "Start," click "Run" and enter the text "cmd".
- 5). Restart the SQL Server Service by entering the command "net stop mssqlserver", followed by "net start mssqlserver" without quotes. Press "Enter" after each command.
