Having problem with sql server 2019 and I got an error saying mssqlserver is already in use and also tried mssqlserver2 same problem.
Yeah, I see it. Typically renaming it should have done it but seems not working. You can see if this fixes it: THE INSTANCE ID ‘MSSQLSERVER’ IS ALREADY IN USE
If it is for a new installation in your Lab then a rebuild of the VM will be quicker than trying to fix it.
Ricardo
solved the problem I had to restart the virtual machine and also for sql server 2019 it will generate the instance id with weird id number and I had to create new name which is mssqlserver2 and it finally worked.
1 Like