SQL server 2012

[Former Member]

Hi,

We installed one system with one system ID and then we renamed to a different one using the sapinst, but on the SQL server management , on the properties the Database name appears as the old one:

The correct one should be DE1, how can we update it?

Thanks a lot, Sapera

[Former Member]

Hi,

You have a named instance of SQL Server rather than a default instance installed (refer to "What's the difference between installing a Default Instance vs Named Instance?)

What you have highlighted (\QE1) is actually the named instance for SQL Server.

The recommendation from SAP when using SQL Server and installing using a named instance is to use the SID (QE1 in this case).

Unfortunately it is NOT possible (as far as I am aware) to change the instance name of a SQL Server named instance.  it is not supported by Microsoft to do this, hence SWPM won't change it when you do the system rename.

From a SAP perspective the name of the named instance is irrelevant, you could all it \ABCD if you really wanted to, so leaving it as \QE1 will not affect the operation of the system.

If you really insist or need to "change" it, then the only option would be to install a new SQL named instance (<server>\DE1) and then perform a system copy (recommend detach/attach method with SWPM) to move the database to the new SQL instance.  You can then de-install the old SQL Instance.

Thanks.

Colin

[Matt_Fraser]

Hi Sapera,

This is not so much a Windows or even SQL Server question as a question, so I would recommend asking a moderator to move this thread to that space. You'll likely get better responses there.

Cheers,

Matt

[Sriram2009]

Hi

Using the old SAPINST you did the system copy or Using the SWPM you can rename the SID?

Regards

SS