Is it possible to install SQL Server 2005 without an instance name? I installed the CTP a while back to test/play and I *have* to connect to it as SQL-DEV/sql2k5dev where SQL-DEV is the server name and sql2k5dev is the instance name. In SQL Server 2000 you could simply connect to the server name only. So, I was hoping I could to the same in SQL Server 2005. Did I miss something obvious on the install?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 2005 without an Instance Name
- Thread starter ChadJK
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
If you specify an instance name than you must use the instance name when connecting. However yes you can install without an instance name. There should have been a checkbox for using the default instance. They only reason this wouldn't have been available would be if there is already a default instance installed on the server.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question