I installed SQL Server 2008 and typed in an instance name of sql2008 but it seems to have been isntalled as a default isntance. Trying to connect using .\sql2000 fails but using just the computer name succeeds. The service is listed with (MSSQLSERVER) as if it is the default instance, but the data directories all have the .sql2008 instance name suffix. So not only is it not what I wanted, but the data directories and service names have inconsistent suffixes. Was there something else I needed to do besides specifying an instance name during installation? Maybe a checkbox I missed?
Is there a way to change from a default instance to a named instance?
Best Answer
Not easily (if at all). You're best off reinstalling. I'd have to go through the installer again, but if you didn't select the Named Instance option it could still let you type in the name for a named instance but leave the option set for the default. Reinstall and double check all the options as you're doing the new install.