Having trouble installing AdventureWorksDW2012 in SQL 2012

Question

Having trouble installing AdventureWorksDW2012 in SQL 2012

halifaxdal

SSCoach

Points: 19741
More actions
February 14, 2017 at 2:32 pm

#321668

Hello,
I believe this has been discussed before but I am a bit confused now:
I have a local SQL 2012 installed on my laptop, here is the screenshot:
I have downloaded AdventureWorksDW2012 from CodePlex, when I attached the mdf to my local server, I got the compatibility error below:
So in my case, how can I install the AdventureWorksDW2012 database?
Thank you very much.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

halifaxdal SSCoach Points: 19741 More actions · Answer 1

It turns out my local SQL is NOT 2012, but actually 2008R2!

select @@VERSION
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
    Jun 17 2011 00:54:03
    Copyright (c) Microsoft Corporation
    Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Would that mean upgrade is the only path? Thanks.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 2

What is the output of admin cmd "net start", what is shown in the Sql Server Configuration Manager and in Services? Possibly you may have more than one instance running on the machine,
😎

Sue_H SSC Guru Points: 90860 More actions · Answer 3

halifaxdal - Tuesday, February 14, 2017 2:45 PM
It turns out my local SQL is NOT 2012, but actually 2008R2!
select @@VERSION
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
    Jun 17 2011 00:54:03
    Copyright (c) Microsoft Corporation
    Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Would that mean upgrade is the only path? Thanks.

You would need to upgrade to install the 2012 version or install the SQL Server 2008 R2 version of Adventure Works to work with your current SQL Server version.

Sue

halifaxdal SSCoach Points: 19741 More actions · Answer 4

Thanks all, I upgraded it and installed the sample database problem free.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

halifaxdal - Tuesday, February 14, 2017 6:21 PM
Thanks all, I upgraded it and installed the sample database problem free.

Good to hear it all worked out - thanks for posting back.

Sue