OK. This error is different than the prior error for which I provided a script.

It appears you are now trying to attach the DW database.

What is the file path...

The SP1 in your earlier reply is for the OS. SQL Server is at the release version still (RTM).

The database file you are trying to attach is SP1 and...

Yes - please patch your instance from RTM to SP1

Try this to get the server level and sp level

select @@version

New Horizons should be fine - most of it depends on the student and instructor.

based off the file location in PM

USE [master]

GO

CREATE DATABASE [AdventureWorks2008R2] ON

( FILENAME = N'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008R2_Data.mdf' )

FOR ATTACH

GO

Also, what is the service pack level of your Dev...

Is this person completely new to SQL?

If so, then New Horizons may be fine.

Otherwise, I would rather buy a book, computer, and play around with the samples in the book.

post the command you used

I would look for R2 training (2012 would also be viable enough).

Also, consider looking for SQL Saturday events in your area.

http://sqlsaturday.com/

Woot

You didn't change the file path in the query like I pointed out.

That file path must be changed to reflect the location of where you placed the data file on...

Why do you need SQL 2012 on the webserver?

Have you considered alternatives such as 2008 which would provide you a middle ground to jumping to SQL 2012?

http://www.microsoft.com/en-us/download/details.aspx?id=1695

I have several clients running Accpac on SQL Server 2008 R2 as well as just SQL Server 2008. You should be ok with Accpac on SQL Server.

Have you tried following this article?

http://msdn.microsoft.com/en-us/library/cc645923.aspx

Use something like this:

USE [master]

GO

CREATE DATABASE [AdventureWorks2008R2] ON

( FILENAME = N'C:\Database\Data\AdventureWorks2008R2_Data.mdf' )

FOR ATTACH

GO

You will need to change your path. Once you execute that command, you should see...