Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Upgraded SQL Server 2005 to SQL Server 2008, but it still reports 2005 Expand / Collapse
Author
Message
Posted Tuesday, October 16, 2012 8:42 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 12:49 PM
Points: 318, Visits: 440
I upgraded my SS2k5 instance to SS2k8 using the standard upgrade process from MS, but the instance still shows as ss2k5. I don't understand.



Jim
Post #1373316
Posted Tuesday, October 16, 2012 8:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
Did the upgrade succeed? Did you upgrade the database engine or just the client tools? Are you looking at the right instance?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1373322
Posted Tuesday, October 16, 2012 9:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 12:49 PM
Points: 318, Visits: 440
All good questions. I believe I upgraded the engine and the tools. I can't post images here very well, so I'm a little challenged. I already had SSMS2k8 installed. I think I just figured out how to attach an image. The two images attached show SSMS and the Programs Utility for the MS Server 2008 server. What else can I show?

Is it possible that SSMS is forcing a compatibility level, or has the upgrade utility done that? I don't need it. My stuff is quite compatible with SS2k8.


Jim

  Post Attachments 
Capture.PNG (32 views, 59.73 KB)
Capture.PNG (19 views, 61.22 KB)
Post #1373338
Posted Tuesday, October 16, 2012 9:42 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
No, that's not a compat level. I suspect you're connecting to the wrong instance, the services shows a SQL 2005 instance as well as the SQL 2008.

Did you install a named instance instead of upgrading the default instance? That's what it looks like.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1373365
Posted Tuesday, October 16, 2012 9:53 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 12:49 PM
Points: 318, Visits: 440
I agree, that's what it looks like, but I can't seem to find the named instance. How would I find it?

Jim
Post #1373370
Posted Tuesday, October 16, 2012 10:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
Start with SQL Server Configuration manager, or in management studio (the 2008 one) check registered servers.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1373376
Posted Tuesday, October 16, 2012 10:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 12:49 PM
Points: 318, Visits: 440
Capture file 3 shows a T-SQL script that should show all instances on a given machine. I also ran a C# program designed to do the same thing...no joy. Just the one instance. Maybe rerun the installation?

Jim

  Post Attachments 
Capture.PNG (10 views, 33.69 KB)
Post #1373403
Posted Tuesday, October 16, 2012 11:09 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 42,765, Visits: 35,863
Check SQL Server Configuration Manager. The screen shot of installed programs shows 2 SQL installations, one 2005, one 2008 R2.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1373416
Posted Tuesday, October 16, 2012 12:12 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:54 PM
Points: 6,282, Visits: 13,538
open a cmd prompt on the machine and post the output of

NET START



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1373451
Posted Tuesday, October 16, 2012 1:13 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 12:49 PM
Points: 318, Visits: 440
See Capture 4

Jim

  Post Attachments 
Capture.PNG (27 views, 43.94 KB)
Post #1373487
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse