September 21, 2011 at 10:27 am
I have recently upgraded one of my database servers to SQL 2005 from SQL 2000. After the upgrade I rebooted and when I look in SQL Server Management Studio the version is still 8.0. How can I correct this as it appears that all components installed accept for the base SQl Server Components?
September 21, 2011 at 10:31 am
Where / how did you collect that info?
September 21, 2011 at 11:26 am
The info was gathered from SQL Server Studio Manager when you highlight the server
September 21, 2011 at 11:29 am
Can you post a screenshot? I just can't make heads or tales with this atm, I have 2K5 and it reads 9.
September 21, 2011 at 11:36 am
Are you sure you're connecting to the right instance?
Did you do an in-place upgrade or did you install SQL 2005 alongside SQL 2000?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2011 at 11:36 am
Screen shot attached.
September 21, 2011 at 11:38 am
cmorris 6147 (9/21/2011)
Screen shot attached.
That's the server level. That server is sql 2000.
The tools version is in help... about.
September 21, 2011 at 11:40 am
Microsoft SQL Server Management Studio9.00.5000.00
Microsoft Analysis Services Client Tools2005.090.5000.00
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer8.0.6001.18702
Microsoft .NET Framework2.0.50727.3623
Operating System5.1.2600
Shouldn't the server level read version 9.00.5 after the upgrade though?
September 21, 2011 at 11:41 am
Ninja's_RGR'us (9/21/2011)
cmorris 6147 (9/21/2011)
Screen shot attached.That's the server level. That server is sql 2000.
Which is the point of the question, that an (apparently) upgraded server is still the old version.
Either the connection is to the wrong instance or the upgrade failed.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2011 at 11:48 am
The upgrade must have failed then as there is only 1 instance on the server. Just double checked to be sure that it did not create a new one and only the default instance is there.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply