On my development machine I've installed SQL Server Express 2008, but it has the instance name
.\SQLEXPRESS. I want it to be the default instance. I'm pretty sure that I selected the "Default Instance" option in the setup, but apparently it didn't work. Is there any way I can change the instance name now?
It seems that this is a known bug in the installer. It will be fixed when PCU 1 (PubliC Update) comes out, but there's not telling when that's gonna happen. In the mean time there are two workarounds:
- When installing, choose the "Named Instance" option and enter
- Install a named instance, then install another instance and this time the "Default Instance" option will work.
Still, the question remains: is there any way to rename an instance WITHOUT reinstalling? Because the setup was a slow pain. XD