home  »  Blogs  »  timmurphy  »  murach's sample DB

murach's sample DB

change text size: A A A

posted 2/8/2010 by timmurphy

Has anyone tried to attach murach's sample DB for SQL Server 2008? I tried by using the "simple" steps outlined in the book and got these errors:

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "C:\Murach\SQL Server 2008\Databases\AP.mdf". Operating system error 5: "5(Access is denied.)".

Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "C:\Murach\SQL Server 2008\Databases\AP_AllObjects.mdf". Operating system error 5: "5(Access is denied.)".

Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "C:\Murach\SQL Server 2008\Databases\Examples.mdf". Operating system error 5: "5(Access is denied.)".

Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "C:\Murach\SQL Server 2008\Databases\ProductOrders.mdf". Operating system error 5: "5(Access is denied.)".

It would be nice to use for the exercises at the end of chapters.

Here's the query, from their batch file:

CREATE DATABASE AP
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\AP.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\AP_log.ldf')
  FOR ATTACH
GO

CREATE DATABASE AP_AllObjects
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\AP_AllObjects.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\AP_AllObjects_log.ldf')
  FOR ATTACH
GO

CREATE DATABASE Examples
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\Examples.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\Examples_log.ldf')
  FOR ATTACH
GO

CREATE DATABASE ProductOrders
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\ProductOrders.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\ProductOrders_log.ldf')
  FOR ATTACH
GO

 

 

 

To rate this blog entry please  register or login

Author

timmurphy timmurphy (Member since: 1/30/2010)

View timmurphy 's profile

Comments (3)

  • bulentgucuk 2/9/2010 12:53:46 AM by:  bulentgucuk
    It looks like you're having file access permission. I recommend you to check the security permissions for each file and add the account you're running the t-sql to attach the files with full control permissions. HTH
  • timmurphy 2/9/2010 10:19:33 PM by:  timmurphy
    The answer is you must turn off User Account Control before running the supplied batch files. Complete directions for this are on page 754 of murach's. I hope no malicious software tries to attack during this process!
  • dustinryan 2/9/2010 10:45:54 PM by:  dustinryan
    Good to know. Eventually you'll just get so fed up with UAC that you'll turn it off and use a third party tool for protection.

Post a comment

Comment (No HTML)  

Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

timmurphy's latest blog posts

  • Another error message that doesn’t make sense, or does it?
    3/5/2010
    I was going back through a project and cleaning up a few things (you know…trying to use best practices, etc.) and got this error: Error: Failed to lock variable "Dts.Variables("intAuditRowsInserted").Value = 0" for read/write access with error 0xC0010001 ...
  • I love my new friend – SSIS
    3/2/2010
    Yesterday was my first day to actually do a project with SSIS that means something in the real world. We had a deadline to meet and needed to extract part of the data from several files, combine the needed info into one file and make sure that there was n...
  • Webinar Series 101
    2/22/2010
    This morning I got up early (since I work midnight - but only 3 more days...sweet) and listened in on the Pragmatic Works Webinar with Jorge Segarra. Check it out at http://www.pragmaticworks.com/resources/webinars/ . This was the first of a series design...
  • This Is "Querious"
    2/16/2010
    Have you ever worked on a query and believed it was perfect but you keep getting error messages and so you tweak it again and fix what you think might be wrong only to get another error message. I know this is going to sound stupid but that happened to me...
  • Previous ACID reference
    2/14/2010
    Sorry, the reference to ACID in my previous blog was inserted into the code section. In case you were wondering, ACID is an acronym for “Atomicity Consistency Isolation Durability” which are the 4 properties of a database transaction (or at least a good o...

Latest community blog posts

  • MikeMollenhour Using Temp Tables in Data Flow Source Stored Procedure
    3/11/2010
    Many times while working with SSIS I have had issues where I would like to add a temp table to a stored procedure that is a source for my SSIS dataflow. One work around for this is create a temp table variable instead. The issue with this is if many rows ...
  • BradSchacht SQL REPLACE for editing Configuration Tables
    3/10/2010
    Package Configurations in SSIS are key to making your packaged portable across the entire development process.  The problem you being to face with configuration files is the quantity that you collect.  Recently I was working on a project where we had paca...
  • BradSchacht Calculate the Date of the Previous Sunday
    3/10/2010
    There are a number of ways that you can calculate dates using T-SQL.  A common practice is to find the first day of the week which can be accomplished easily by using the following function.select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)However, you will ...
  • Bevans Back to Basics
    3/10/2010
    Today I figured I go back to basics with this blog since a majority of the visitors to this site are primarily DBA's and Database Guru's. This may turn into a series but for now we will discuss a bit of a feared power of sql server, and that is the fact t...
  • PatrickLeBlanc Using a CTE with a T-SQL Pivot Statement
    3/9/2010
    During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE).  In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the deri...