Versions Compared

Old Version 7

changes.mady.by.user Daniel Stuart-Kelly

Saved on

compared with

New Version Current

changes.mady.by.user Daniel Stuart-Kelly

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Repair Jira Macros

Problem

Create Failed for JobStep "ETL1-iQSonar-Extract"

...

Solution - To rename a computer that hosts a stand-alone instance of SQL Server

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

Panel
bgColor#fff

  1. Check if name is the old server name

    Code Block
    sql
    sql
    SELECT @@SERVERNAME AS 'Server Name';

  2. Run following command

    Code Block
    sql
    sql
    sp_dropserver 'old_name';
GO
sp_addserver 'new_name', local;
GO


  3. Restart the SQL Server service
  4. Check new name of server


  5. Code Block
    sql
    sql
    SELECT @@SERVERNAME AS 'Server Name';


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

Panel
bgColor#fff

  1. Check if name is the old server name

    Code Block
    sql
    sql
    SELECT @@SERVERNAME AS 'Server Name';

  2. Run following command

    Code Block
    sql
    sql
    sp_dropserver 'old_name\instancename';
GO
sp_addserver 'new_name\instancename', local;
GO


  3. Restart the SQL Server service
  4. Check new name of server


  5. Code Block
    sql
    sql
    SELECT @@SERVERNAME AS 'Server Name';


...