Monday, February 13, 2012

Attaching AdventureWorks database

Today I installed SQLEXPR.EXE that I found here:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

I made sure that I downloaded the 64-bit version.

I then wanted to download and install the Adventure Works database located here: http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

Since I am running Vista 64-bit, I downloaded and installed AdventureWorksDB_x64. It wouldn't install. I got "Access is denied" and CREATE FILE error plus several others.

I then uninstalled it and downloaded AdventureWorksDB - this is the X86 version. It installed fine.

Can anyone explain what am I missing? Thanks!

Hi,

there is no SQL Server Express 64bit Edition. But you will have to download the 64bit framework to make a successfull installation.

If the setup installed the files of the sample databases properly, go for it. There is no difference in the database, only in the installer package according the 64bit difference.


Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment