After Install of 2005 still 2000 Engine!

I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000.

I do not know why setup did not upgrade it. What do I need to do now? I think some new options are now working because of that...

Was your SQL Server 2005 installation successful? And did you do an upgrade, or a separate instance installation? Check to see if you have a second instance of sql server running, this may be your SQL 2005 installation.|||

How to check if I have second instance? How to see all my instances? Thanks

|||look at your services in control panel.|||What should I look exactly at? I see SQl Server (SQl Express) service...|||

That is probably your named instance, which you installed instead of upgraded.

http://msdn2.microsoft.com/en-us/library/ms165614.aspx

You can search msdn for more information regarding your named instance.

|||Is not that SQl Server Express 2005? I had it installed before...|||i just reread your post. where do you see "8.9.193"? if you do "select @.@.version", that will tell you the version of your sql server installation.|||Thanks. I have executed the SQL:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Seems I have still the old version of SQL, however I can not run Enetrprise Manager anymore, it gives me some strange errors. However it seems I can manage this instance as well as SQl Server Express instance from the new SQL Management Studio. The problem is that some options do not work (grayed out). I think the reason is that this version was not upgraded.

Can I upgrade this version without using Setup? My DVD has some scratches...|||

Hi I wonder now. Is it possible that SQL Express 2005 has been upgraded to full version, but the instance is still called SQLExpress, even it is full version SQL Server 2005?

Please let me know. Thanks

|||

I have tried to copy database from SQL 2000 instance but it does not accept this destination name: h001335\SQLEXPRESS

I have checked the speeling, it is correct instance.

Any idea?

|||

After ignoring the previous message I got the following:

TITLE: Copy Database Wizard

The server is SQL Server Express. This application will not work with Express Edition.

BUTTONS:

OK

|||Seems it never upgraded SQL Express.. I wonder... So it seems I have two versions: SQL 2000 and SQl Express. What is the version difference betwen SQL Express and SQl Server 2005? How to tell?|||How to tell the difference between SQL Express 2005 and SQL Server 2005? How to check?|||

Radiogeneris, please read the Books Online that came with your SQL SErver 2005 installation, it will give you a good overview as well as help you better understand your installation process/problems.

You can also access it online at http://msdn2.microsoft.com/ms165606(en-US,SQL.90).aspx.

After you've read the documentation, please feel free to post any follow up questions.

After Install of 2005 still 2000 Engine!

I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000.

I do not know why setup did not upgrade it. What do I need to do now? I think some new options are now working because of that...

Was your SQL Server 2005 installation successful? And did you do an upgrade, or a separate instance installation? Check to see if you have a second instance of sql server running, this may be your SQL 2005 installation.|||

How to check if I have second instance? How to see all my instances? Thanks

|||look at your services in control panel.|||What should I look exactly at? I see SQl Server (SQl Express) service...|||

That is probably your named instance, which you installed instead of upgraded.

http://msdn2.microsoft.com/en-us/library/ms165614.aspx

You can search msdn for more information regarding your named instance.

|||Is not that SQl Server Express 2005? I had it installed before...|||i just reread your post. where do you see "8.9.193"? if you do "select @.@.version", that will tell you the version of your sql server installation.|||Thanks. I have executed the SQL:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Seems I have still the old version of SQL, however I can not run Enetrprise Manager anymore, it gives me some strange errors. However it seems I can manage this instance as well as SQl Server Express instance from the new SQL Management Studio. The problem is that some options do not work (grayed out). I think the reason is that this version was not upgraded.

Can I upgrade this version without using Setup? My DVD has some scratches...|||

Hi I wonder now. Is it possible that SQL Express 2005 has been upgraded to full version, but the instance is still called SQLExpress, even it is full version SQL Server 2005?

Please let me know. Thanks

|||

I have tried to copy database from SQL 2000 instance but it does not accept this destination name: h001335\SQLEXPRESS

I have checked the speeling, it is correct instance.

Any idea?

|||

After ignoring the previous message I got the following:

TITLE: Copy Database Wizard

The server is SQL Server Express. This application will not work with Express Edition.

BUTTONS:

OK

|||Seems it never upgraded SQL Express.. I wonder... So it seems I have two versions: SQL 2000 and SQl Express. What is the version difference betwen SQL Express and SQl Server 2005? How to tell?|||How to tell the difference between SQL Express 2005 and SQL Server 2005? How to check?|||

Radiogeneris, please read the Books Online that came with your SQL SErver 2005 installation, it will give you a good overview as well as help you better understand your installation process/problems.

You can also access it online at http://msdn2.microsoft.com/ms165606(en-US,SQL.90).aspx.

After you've read the documentation, please feel free to post any follow up questions.

After I update the existed sql 2000 to sql 2005. But I saw the sql is still running v8.0 (

Dear All,
After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
running the 2000 core).
But I remembered that I had selected the options to upgraded the existed
SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
I saw some helps that when I setup the SQL2K5. Add one parameters when
setting up?
Thanks for your helps first,;)
Best Regards,
Benny Ng
Hi Benny
Your databases may be in 8.0 compatability mode, but if you upgraded
correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
If you look in the services applet you should see what services are running.
You should also have the SQL 2005 tools available on the start menu.
John
"Benny Ng" wrote:

> Dear All,
> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> running the 2000 core).
> But I remembered that I had selected the options to upgraded the existed
> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
> I saw some helps that when I setup the SQL2K5. Add one parameters when
> setting up?
> Thanks for your helps first,;)
>
> Best Regards,
> Benny Ng
>
>
|||Dear John Bell,
The command SELECT @.@.VERSION, After running. The result i got is
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
And surely i have the SQL2K5 tools on the start menu. The difference
between my laptop (it's normally installed SQL2K5) is only the SQL engine.
Best Regards,
Benny Ng
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...[vbcol=seagreen]
> Hi Benny
> Your databases may be in 8.0 compatability mode, but if you upgraded
> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> give?
> If you look in the services applet you should see what services are
> running.
> You should also have the SQL 2005 tools available on the start menu.
> John
> "Benny Ng" wrote:
|||Hi
What does the services applet show in terms of instances running? Are you
running the upgrade using the correct version of the CDs? Have you run the
latest upgrade advisor?
John
"Benny Ng" wrote:

> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference
> between my laptop (it's normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
>
>

After I update the existed sql 2000 to sql 2005. But I saw the sql is still running v8.0 (

Dear All,
After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
running the 2000 core).
But I remembered that I had selected the options to upgraded the existed
SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
I saw some helps that when I setup the SQL2K5. Add one parameters when
setting up?
Thanks for your helps first,;)
Best Regards,
Benny NgHi Benny
Your databases may be in 8.0 compatability mode, but if you upgraded
correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
If you look in the services applet you should see what services are running.
You should also have the SQL 2005 tools available on the start menu.
John
"Benny Ng" wrote:
> Dear All,
> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> running the 2000 core).
> But I remembered that I had selected the options to upgraded the existed
> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
> I saw some helps that when I setup the SQL2K5. Add one parameters when
> setting up?
> Thanks for your helps first,;)
>
> Best Regards,
> Benny Ng
>
>|||Dear John Bell,
The command SELECT @.@.VERSION, After running. The result i got is
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
And surely i have the SQL2K5 tools on the start menu. The difference
between my laptop (it's normally installed SQL2K5) is only the SQL engine.
Best Regards,
Benny Ng
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
> Hi Benny
> Your databases may be in 8.0 compatability mode, but if you upgraded
> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> give?
> If you look in the services applet you should see what services are
> running.
> You should also have the SQL 2005 tools available on the start menu.
> John
> "Benny Ng" wrote:
>> Dear All,
>> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
>> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
>> running the 2000 core).
>> But I remembered that I had selected the options to upgraded the
>> existed
>> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
>> Can anyone tell me how can I upgrade the existed SQL2K core to
>> SQL2K5?
>> I saw some helps that when I setup the SQL2K5. Add one parameters when
>> setting up?
>> Thanks for your helps first,;)
>>
>> Best Regards,
>> Benny Ng
>>
>>|||Perhaps you have several instances of SQL Server and you didn't upgrade the instance you are looking
at...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Benny Ng" <benny_wufree@.hotmail.com> wrote in message news:O85gxiIDHHA.628@.TK2MSFTNGP04.phx.gbl...
> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003
> Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference between my laptop (it's
> normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
>> Hi Benny
>> Your databases may be in 8.0 compatability mode, but if you upgraded
>> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
>> If you look in the services applet you should see what services are running.
>> You should also have the SQL 2005 tools available on the start menu.
>> John
>> "Benny Ng" wrote:
>> Dear All,
>> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
>> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
>> running the 2000 core).
>> But I remembered that I had selected the options to upgraded the existed
>> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
>> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
>> I saw some helps that when I setup the SQL2K5. Add one parameters when
>> setting up?
>> Thanks for your helps first,;)
>>
>> Best Regards,
>> Benny Ng
>>
>>
>|||Hi
What does the services applet show in terms of instances running? Are you
running the upgrade using the correct version of the CDs? Have you run the
latest upgrade advisor?
John
"Benny Ng" wrote:
> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference
> between my laptop (it's normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
> > Hi Benny
> >
> > Your databases may be in 8.0 compatability mode, but if you upgraded
> > correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> > give?
> >
> > If you look in the services applet you should see what services are
> > running.
> > You should also have the SQL 2005 tools available on the start menu.
> >
> > John
> >
> > "Benny Ng" wrote:
> >
> >> Dear All,
> >>
> >> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> >> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> >> running the 2000 core).
> >>
> >> But I remembered that I had selected the options to upgraded the
> >> existed
> >> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> >>
> >> Can anyone tell me how can I upgrade the existed SQL2K core to
> >> SQL2K5?
> >> I saw some helps that when I setup the SQL2K5. Add one parameters when
> >> setting up?
> >>
> >> Thanks for your helps first,;)
> >>
> >>
> >> Best Regards,
> >>
> >> Benny Ng
> >>
> >>
> >>
> >>
>
>