Problem installing sample DB adventureworks2008 SR4.

Question

HI!

 

I am trying to install smaple adventureworks2008 database (SQL Server 2008 SR4). I have a problem installing Adventureworks2008 DB. rest of them are installed. What should i do to install Adventureworks2008 DB. I tries to run the script instawdb file. But ii is giving me an error.

 

 

Thanks,

Answer 1

Can you post the error that you are getting?

 

Answer 2

The AdventureWorks2008 database has requirements that the other databases do not.  That is, you must have full-text search installed and enabled and you must have FILESTREAM enabled.  The steps for ensuring these are setup correctly are documented here: Database Prerequisites . Once you have completed these steps, you can successfully install the sample database. 

If you have already the prequisites installed correctly, then please provide the exact error message that you get.

Regards,

Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 3

HI!

 

When I try to execute the Adventureworks2008 DB it gives me following error.

Msg 5105, Level 16, State 2, Line 2
A file activation error occurred. The physical file name '$(SqlSamplesDatabasePath)AdventureWorks2008_Data.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'AdventureWorks2008', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 911, Level 16, State 1, Line 2
Database 'AdventureWorks2008' does not exist. Make sure that the name is entered correctly.

 

 

Please let me know how I can install Adventureworks2008 DB.

 

Thanks,

 

Answer 4

It sounds like you are trying to install the database from the installation script.  I do not recommend installing the database in this manner.   Notice that the first error message you are getting lists an invalid folder for the location of the .mdf file  You would need to edit the script to specify a correct folder location and then make sure that you have all of the associated .csv (data )files downloaded as well.

It will be much, much easier for you if you simply go back to Codeplex and run the installation again from there. 

Regards,

Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 5

HI!

 

That's what I did. I went to codeplex and install the Aventureworks2008 SR4. Then I open SSMS but Adventureworks2008 was missing. It wasn't installed. SO, How can i installed now Adventureworks2008. Please give me the steps to install Adventureworks2008 DB.

 

Thanks,

 

Answer 6

This is unusual if you have taken care of the database prerequisites successfully.  I suggest that you do the following steps, just so we can make sure that you're starting from a clean baseline.

1. From Control Panel | Add/Remove Programs, uninstall AdventureWordsDB.

2. From http://msftdbprodsamples.codeplex.com/, click the green download button for SQL Server 2008 SR4.

3. When you get to the installation page titled "Database Selection", make sure that there is a checkbox next to AdventureWorks OLTP 2008.  If there is a yellow caution icon, click the More Information button.  This will display whatever prerequisite is missing from your installation of SQL Server.  These items must be corrected before you can continue the sample database installation.

4. Assuming you get a check in the checkbox for AdventureWorks OLTP 2008, click through the remaining pages of the installation wizard.

5.  If there are errors during the installation, they should be displayed at the end.  Please record these errors.

6. Finally, if you do get any errors, please post the errors along with your OS version and version of SQL Server.  This will help us do additional diagnostics.

Thanks for your patience.

Gail

 

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 7

HI Gail,

 

I have followed all steps that you have mention above. I have uninstall Adventureworks2008 SR4 DB and then install it again. When the installation  completed  without any error, I opened SSMS and found all the databases attached except Adventureworks2008 DB. SO, I opened up the script file located at (C:\Program files\Sql Server\100\tools\samples\Adventureworks2008 OLTP\instawdb). Then I followed all steps mention on the below link and still it gives me an error.

http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Installer%20Help

Error:

Msg 5120, Level 16, State 106, Line 2
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER1\MSSQL\DATA\Documents". Operating system error -2147024891: "0x80070005

This error I am getting when it try to create the database. Please let me know if you have any idea about this error.When I check the given path in the error, I don't see any file or folder named Documents.

 

Thanks,

 

 

Answer 8

The Documents folder is suppose to get created during the installation and is used to store FILESTREAM data for a column in the database.   I believe that the error message you're getting is related to a permissions problem related to the account running the SQL Server service.  If you have NT AUTHORITY\NETWORK SERVICE as the account running the instance of SQL Server, it may not have sufficient privilege to create the Documents folder or write to it. 

Here's a couple of things to try.

1.  Run Management Studio as administrator. (right-click SQL Server Management Studio and select Run As Administrator).

2.  Execute the instawdb.sql script.  (hopefully this will give you sufficient permissions to create the Documents folder and successfully install.  If it doesn't, then try the following:

1. Manually create the folder C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER1\MSSQL\DATA\Documents.

2. Give the account that is running your SQL Server service full permissions to modify that folder.

3. Try the installation script again (or alternatively, try running the .exe from Codeplex again.

In the meantime, I'm forwarding this post to someone on the Samples team to see if they have any addtional insights or suggestions.

Regards,

Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 9

THank you Gail......

Answer 10

Sounds like you were successful.   Would you mind telling us which steps solved the problem?  That way others that run into the same issue will know what to try.

Thanks,

Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 11

Where is the instawdb.sql script? I did steps 1 and 2 of the second set of instructions. Running the AdventureWorks exe again still gives me a fatal error. I would try running the script but I can't find it.

Answer 12

Hi David,

By default the SR4 executible should copy the installation file to C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 OLTP.   What is the fatal error that you're getting? 

 

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 13

Hi!

 

I am trying to install Adventureworks 2008 and I am getting the following error.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'filestream_access_level' does not exist, or it may be an advanced option.

HOw can i resolve it??

 

Thanks,

 

Answer 14

Hmm, it sounds like you may be trying to install the database on a version of SQL Server lower than SQL Server 2008.  Please run the following query and report back with the results:

SELECT @@VERSION

 

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 15

Thanks Gail...

Now it works..

 

Answer 16

I have followed all your discussion and still get the error messages below, is it because I am using SQL Server 2008 EXPRESS version. Thanks,

Msg 102, Level 15, State 1, Line 31

Incorrect syntax near ':'.

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)

Jul  9 2008 14:43:34

Copyright (c) 1988-2008 Microsoft Corporation

Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

Started - 2012-06-26 16:01:51.663

*** Dropping Database

*** Enabling FileStream

Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.

*** Creating Database

Msg 5105, Level 16, State 2, Line 2

A file activation error occurred. The physical file name '$(SqlSamplesDatabasePath)AdventureWorks2008_Data.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 1802, Level 16, State 1, Line 2

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Answer 17

Please try the SQL install script for AdventureWorks2008 at http://msftdbprodsamples.codeplex.com/releases/view/89502. Make sure you change the SqlSamplesDatabasePath and SqlSamplesSourceDataPath to point to the appropriate paths. If needed, I can upload the database file to our CodePlex site. Please let us know if this option works for you.

To install AdventureWorks2008 OLTP database from script

1. Download AdventureWorks 2008 OLTP Script.zip.
2. Copy the DDL script files to C:\{AdventureWorks 2008 OLTP Script Path}.
3. Open C:\{AdventureWorks 2008 OLTP Script Path}\instawdb.sql in SQL Server Management Studio.
4. Update the script path variables.

If necessary, change the :setvar SqlSamplesDatabasePath variable to your SQL Server 2008 path. The default path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER \MSSQL\DATA.
Change the :setvar SqlSamplesSourceDataPath variable to the path containing the .csv files.

5. On the Query menu, click SQLCMD Mode.
6. On the Standard toolbar, click the Execute button to run the script.

Answer 18

Also, if you want to upgrade to SQL Server 2012 Express , you can download and attach a database file. The database file is at http://msftdbprodsamples.codeplex.com/releases/view/55330. SQL Server 2012 Express : http://msdn.microsoft.com/en-us/evalcenter/hh230763

Answer 19

Derrick,

Thanks so much this time it worked. I finally installed the AdventureWork database to my SQL 2008 Server EXPRESS. I believe it was step 5 you listed that solved my problem. Thank you so much.

 "5. On the Query menu, click SQLCMD Mode. "

But I have another error below,

*** Creating Full Text catalog and indexes

Msg 7609, Level 17, State 5, Line 5

Full-Text Search is not installed, or a full-text component cannot be loaded.

** An error was encountered during execution of batch. Exiting.

Does this one have to do with EXPRESS version?

Please help again. Thank you so much,

Answer 20

The Full Text Search feature is not installed by default. If you did not select the FTS option during setup, you can go into SQL Server 2008 Express maintenance mode and add the FTS feature. Maintenance mode is available in Programs and Features by selecting Microsoft SQL Server 2008 Express and clicking Uninstall/Change.

If Full Text Search was installed then try enabling it with EXEC sp_fulltext_database 'enable'

Or you might need to restart the SQL Server (SQLEXPRESS) service in SQL Server Configuration Manager. Select SQL Server (SQLEXPRESS), right click, and select Restart.

Answer 21

Derrick,

I use Programs and Features by selecting Microsoft SQL Server 2008 Express and clicking Uninstall/Change. When I click "Add" feature, it prompted me a "Browse for Folder" window and asked for "Browse for SQL Server 2008 installation media". I tried almost every single folder under "Microsoft SQL Server 2008 Express" and got "the folder is not a valid installation folder" message. Which folder should I pick?

Thanks for help,

Answer 22

I upgraded SQLEXPRESS (2008) to with SQLEXPRESS with Advanced Services. And then, add feature with Full-Text search. It went successfully.  

Answer 23

Great! Glad that it went well for you.

When you see answers and helpful posts, please click Vote As Helpful,Propose As Answer, and/or Mark As Answer

Answer 24

Derrick,

Thanks for the SQLCMD mode tip, to be fair to MS it's mentioned in the comments section at the top of the script but no one ever reads that :-)

Answer 25

For the SQL Error message beginning "sql msg 5105 level 16...", it was definitely an issue with not running the script in SQLCMD mode (which is a big aha!-moment since it's a commented warning in all caps that precedes the environment variables), and it resulted in the T-SQL's parser not being able to properly evaluate the variables (e.g. $(SqlSamplesDatabasePath), et al).

Thanks, Wendy!

The sad part is, I successfully installed these just the other day.  I've been learning too much recently...my FIFO buffer has been cleared for more input.  Johnny-5 Alive styles...NEED MORE INPUT!!