Problems installing AdventureWorks
I am working with SQL Denali CTP3 and I am trying to download the AdventureWorks database however everytime that I try to download this even the older verision including SQL Server 2008 R2 AdventureWorks it gives me the following error
A fatal error occurred during installation. Details:
Failed object initialization(IsupportInitialize.EndInit). SQL Server WMI provider is not availiable on C_PBREVELANT. Error at object 'DatabaseSelection' in markup file 'DatabseInstaller;Component/databaseselection.xaml' Line 78 Position 3
Is there anything I can do or is there something I am doing wrong to download.
January 26th, 2012 3:58pm
January 26th, 2012 4:01pm
Well i went to the site however there is no download button for it....
January 26th, 2012 4:14pm
Just click on the link, it will download,
January 26th, 2012 4:31pm
Just click on the link, it will download,
January 28th, 2012 12:53am
I am also having the same problem...
January 28th, 2012 1:04am
Manish, I have sql server 2012 RCO free version from Microsoft website, but not able too attach the database, should I need to install sql server 2008?
January 29th, 2012 1:38am
Yes. You will need to attach the .mdf file. If you are attaching using GUI then remove the .ldf file because it does not exist. SQL server will automatically create new .ldf file.
Hopefully, that will resolve the issue.
February 1st, 2012 7:56pm
I
am
still
having
trouble
downloading
the
database.
I
followed
the
instructions
exactly
and
I
am
getting
the
following
error
CREATE
DATABASE
AdventureWorks2008R2
ON
(FILENAME
=
‘C:\Users\brevelant\Desktop\SQL
Statements\AdventureWorks2008R2_Data’
)
FOR
ATTACH_REBUILD_LOG
;
Msg
5133,
Level
16,
State
1,
Line
1
Directory
lookup
for
the
file
“C:\Users\brevelant\Desktop\SQL
Statements\AdventureWorks2008R2_Data”
failed
with
the
operating
system
error
5(Access
is
denied
.).
February 1st, 2012 8:00pm
Try this:
USE
[master]
GO
CREATE
DATABASE
[AdventureWorks2008R2]
ON
(
FILENAME
=
N'C:\Users\brevelant\Desktop\SQL Statements\AdventureWorks2008R2_Data.mdf'
) -- Make sure your data file is this folder.
FOR
ATTACH
GO
February 2nd, 2012 7:00pm
I am now getting an error message when i try to attach the database.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks2008R2'. CREATE DATABASE is aborted.
Msg 948, Level 20, State 1, Line 1
The database 'AdventureWorks2008R2' cannot be opened because it is version 705. This server supports version 700 and earlier. A downgrade path is not supported.
February 2nd, 2012 8:06pm
For some reason none of these answers worked. However I was able to attach the practice database by attaching the database file mdf file through SQL object explorer.....!!!!!!!! :)
February 3rd, 2012 6:17pm
went to msdn forums and found
CREATE DATABASE [AdventureWorks2012] ON PRIMARY
( NAME = N'AdventureWorks2012', FILENAME = N'C:\Temp\AdventureWorks2012.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'AdventureWorks2012_log', FILENAME = N'C:\Temp\AdventureWorks2012_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
GO
and it worked. Shew! 4 days of my life I'll never get back.
November 18th, 2012 11:56pm
Thanks
August 15th, 2015 2:09pm
Other recent topics
