Skip to Content
0
Former Member
Jan 14, 2011 at 06:15 AM

how to change the name of the named instance in MS sql server 2008 R2

453 Views

Hi Gurus

I have installed a SAP ECC 6 ehp4 on MS sql server 2008 R2 with MS windows 2008 R2 OS. While installing sql server i have selected named instance from window(default instance, named instance). and given name QAS.

and installed ECC6 ehp4 ABAP engine successfully. now i want to change the name of mssql server's named instance name to DEV.

kindly let me know

which one is the best and easy solution

1. changing the name of named istance at database level and SAP.

2. or uninstalling the existing SAP, DB and start from scratch.

if first is the best, what would be the steps

Thanks in advance

balaji