KB171007584: Automation Engine - How to change the SQL Server name

Description

If the Windows computer name is changed, the SQL Server name must also be changed because this can give problems with Automation Engine.

Follow the steps given below to rename the SQL Server name:

Logon to the SQL Server Management Studio with an administrative user, default sa.
Click on New Query.
Type Print @@SERVERNAME
Click Execute to see the name of the SQL Server.
If this name does not match with the computer name then perform the next steps:
```
do next query:
sp_dropserver 'name'    -> name found with Print @@SERVERNAME
```

Click Execute.

do next query:
sp_addserver 'newname', local  -> newname= computername

Contents