how to supress instance name while logging to sql server 2005?

microsoft.public.sqlserver.programming

19 May 2006 11:00 PM

cooltech77

Hi,

I am using SQL server 2005 express edition on win XP installed on my machine.
when I use the SQL server Management studio, I have to enter
machinename\SQLExpress .How can I connect using just machinenname and omit
the SQLExpress instancename?what settings do i need to do?

Thanks for your help.

regards,
cooltech@77

20 May 2006 4:57 AM

Omnibuzz

SQLExpress is the default instance name that is given to that edition when
you indtsll it. You could have changed it during the installation. You can
now only uninstall SQL Express and reintall it as the default instance.
But I would suggest you not to do that and leave it as it is, so that when
you are going for developer edition or any other edition at a later stage,
you might want it to run under default instance.
Hope this helps.