MS SQL Server - SQL Server 2005 Installation

Author

SQL Server 2005 Installation

Cindy

2006-03-14, 3:23 am

Hi. I'm not sure what's going on, but after installing SQL Server 2005
Enterprise edition, an edition check (using Select Serverproperty
('Edition')) is showing up as SQLExpress. Not to mention, that is the
default server name off my root. What's going on? My guess is I
installed VB Studio 2005, that came with the Express edition, before
the Enterprise edition.

1) How do I make the default server be ENTERPRISE?
2) How do I override the Express Edition?

Uninstalling ALL of SQL Server does not seem to work. It still seems
to have some Express junk roaming around.

Thanks in advance.

Cindy

Tibor Karaszi

2006-03-14, 3:23 am

There's no such thing as a default server. First check whether each of your instances is a named or
default instance. If the way you have setup the instances doesn't suit you, you need to reinstall,
since you cannot change instance name or named to default or vice versa.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Cindy" <cindyc100@hotmail.com> wrote in message
news:1142317575.458274.77650@u72g2000cwu.googlegroups.com...
> Hi. I'm not sure what's going on, but after installing SQL Server 2005
> Enterprise edition, an edition check (using Select Serverproperty
> ('Edition')) is showing up as SQLExpress. Not to mention, that is the
> default server name off my root. What's going on? My guess is I
> installed VB Studio 2005, that came with the Express edition, before
> the Enterprise edition.
>
> 1) How do I make the default server be ENTERPRISE?
> 2) How do I override the Express Edition?
>
> Uninstalling ALL of SQL Server does not seem to work. It still seems
> to have some Express junk roaming around.
>
> Thanks in advance.
>
> Cindy
>

John Bell

2006-03-14, 3:23 am

Hi Cindy

You can use SQL Server Configuration Manager to show the instances of SQL
Server that are running.

When you un-installed SQL Server did you remove SQL Express as well? If you
installed Enterprise before installing SQL Express then you should be able to
specify that it is the default instance.

The help file in the setup bootstrap\help directory\{Langid} directory has
information regarding manually removing SQL Server 2005.

John

"Cindy" wrote:

> Hi. I'm not sure what's going on, but after installing SQL Server 2005
> Enterprise edition, an edition check (using Select Serverproperty
> ('Edition')) is showing up as SQLExpress. Not to mention, that is the
> default server name off my root. What's going on? My guess is I
> installed VB Studio 2005, that came with the Express edition, before
> the Enterprise edition.
>
> 1) How do I make the default server be ENTERPRISE?
> 2) How do I override the Express Edition?
>
> Uninstalling ALL of SQL Server does not seem to work. It still seems
> to have some Express junk roaming around.
>
> Thanks in advance.
>
> Cindy
>
>

Sreejith G

2006-03-15, 3:23 am

Hi just found this when i was trying to migrate my 2000 analysis services...

********************
********************
******************
If you remove the default instance of SQL Server 2000 Analysis Services
after you have migrated its databases, you can use the Analysis Services
Instance Rename tool to make a named instance of SQL Server 2005 Analysis
Services the default instance on the server.
********************
********************
******************

Do we have such kind of Instance rename tool for Sql Server...

--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]

"John Bell" wrote:
[color=darkred]
> Hi Cindy
>
> You can use SQL Server Configuration Manager to show the instances of SQL
> Server that are running.
>
> When you un-installed SQL Server did you remove SQL Express as well? If you
> installed Enterprise before installing SQL Express then you should be able to
> specify that it is the default instance.
>
> The help file in the setup bootstrap\help directory\{Langid} directory has
> information regarding manually removing SQL Server 2005.
>
>
> John
>
> "Cindy" wrote:
>

John Bell

2006-03-15, 3:23 am

Hi

AFAIK there is is not one, you would have to install the new instance and
use the sp_detach_db/sp_attach_db methods to transfer the databases as
described in http://support.microsoft.com/kb/224071 If you are using master
also check out Books online as this gives information about moving the
resource database (if they are to be in a different location)

John

"Sreejith G" wrote:
[color=darkred]
> Hi just found this when i was trying to migrate my 2000 analysis services...
>
> ********************
********************
******************
> If you remove the default instance of SQL Server 2000 Analysis Services
> after you have migrated its databases, you can use the Analysis Services
> Instance Rename tool to make a named instance of SQL Server 2005 Analysis
> Services the default instance on the server.
> ********************
********************
******************
>
> Do we have such kind of Instance rename tool for Sql Server...
>
>
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
>
>
> "John Bell" wrote:
>

Sponsored Links