SQL 2005 Express Default Instance 1

[agoeddeke]

Hello,

After installing SQL 2005 Express I have to connect using the named instance it created (.\SQLEXPRESS) as part of the data source. If I try to connect without using the instance name it doesn't work.

Is there any way to make this the "default" instance so I can use just the server name as the datasource rather than server/instance?

Thanks,
Andy

 

[mrdenny]

You'll need to reinstall. When installing there's a checkbox that allows you do get to some more advanced options. One of which is to use the default instance or a named instance.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[agoeddeke]

Thanks Denny.

Andy

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com