How to create SQL Instance with lower case(mssqlserver instead of MSSQLSERVER)

Question

I need SQL Instance with lower case i.e mssqlserver instead of MSSQLSERVER,In both CLI and GUI installation it was creating/taking uppercase instead of lowercase(when provided in configuration file or GUI)

1.silent installation via CLI by providing configuration.ini file,The installation was successful but Instance was created on upper case.

2.GUI,The installation was successful but Instance was created on upper case.

Answer 1

It's given in the documentation - https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup?view=sql-server-ver15#to-install-sql-server-2019

For a default instance, the instance name and instance ID are MSSQLSERVER. To use a nondefault instance ID, specify a different value in the Instance ID text box.

Probably, you can create a different named instance with the name you want.

Or try out the steps given in blog here
https://www.sqlservercentral.com/blogs/rename-or-change-sql-server-standalone-default-instance

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Actually i need Default Instance or named Instance with lower case only(for eg:"testsql" or "mssqlserver").In the provided blog it was mentioned in capital letters.

Answer 3

Hi ManikantaVenkateshMattapalli-5560,

Actually i need Default Instance or named Instance with lower case only.

I’m afraid you can’t. Instance names aren't case-sensitive, and even if we change the Instance ID of default instance or named instance to lower case, the instance will be still created in upper case.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.