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?