Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

Problem

Create Failed for JobStep "ETL1-iQSonar-Extract"

Error in install of V3 DH
ETL Package deployment failed

For a renamed computer that hosts a default instance of SQL Server, run the following procedures:

Check if name is the old server name
```
SELECT @@SERVERNAME AS 'Server Name';
```

Run following command

sp_dropserver 'old_name';
GO
sp_addserver 'new_name', local;
GO

For a renamed computer that hosts a named instance of SQL Server, run the following procedures

Check if name is the old server name
```
SELECT @@SERVERNAME AS 'Server Name';
```

Run following command

sp_dropserver 'old_name\instancename';
GO
sp_addserver 'new_name\instancename', local;
GO

Remote Logins - If the computer has any remote logins, running sp_dropserver might generate an error similar to the following:

Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44 There are still remote logins for the server 'SERVER1'.

To resolve the error, you must drop remote logins for this server.