June 19, 2010 at 10:04 am
Hi, could somebody explain to me step by step how to attach these databases, I am going crazy.I am running Win 7, I downloaded the files but when I try to attach them I get error message 5 and 5123.It has to do with the new security which I cannot understand. If I take ownership of the Sql server, the Adventure works files and everything else involved I should be able to do it. No way, why the hell do they make it so difficult, at least they could have a good tutorial about it or are we supposed to become all scientist to run a stupid database.Thank you
October 6, 2010 at 2:53 am
What action did you take immediately before getting the message?
October 7, 2010 at 10:54 am
Error message 5 usually means Access Denied. this is probably because the account your SQL Service is running under doesn't have permissions to the location where the file is stored. This is a seperate userid from the one you logged into your box with. Take a look at your services list to see what the database engine credentials are and then give that account permissions to the directory where the files are located.
October 27, 2010 at 11:18 am
please send me the site through which i can download adventure works database 2008.
October 27, 2010 at 11:21 am
please provide me some complex queries using joins and sub queries and self join and corelated query and using some funtions.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply