Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How do I get SQL installed like this?

Author  Topic 

Back2Basic
Starting Member

3 Posts

Posted - 2008-06-23 : 11:41:28
Hey all,

How do I install a SQL Server 2005 Express to have no instance?

I have a SQL 2005 Server Enterprise which has no instance, just the server name, even when pointing to the DB, you just use the server name and the DB name.

I am not any good in SQL, but need to configure SQL Express for a project I am busy with and would like it if I could only have a name, and not an instance.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-06-23 : 11:45:41
do a default install.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!
Go to Top of Page

Back2Basic
Starting Member

3 Posts

Posted - 2008-06-23 : 12:49:35
When I do a default install, then SQL Express installs this <SERVERNAME>\SQLEXPRESS, and I need it to only be <SERVERNAME>.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-23 : 23:15:09
If the machine has default instance already, you can only add named instance on it.
Go to Top of Page
   

- Advertisement -