Sql 2005 express security

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Testing Center » SQL Server Security Skills » Sql 2005 express security

Sql 2005 express security

Rate Topic

Display Mode

Topic Options

Author

Message

leoninicarlo

Posted Saturday, June 19, 2010 10:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 07, 2010 7:20 AM
Points: 1, Visits: 5

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

Post #939970

SQLSophist

Posted Wednesday, October 06, 2010 2:53 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:29 AM
Points: 27, Visits: 312

What action did you take immediately before getting the message?

Post #999061

Bill Scott - Alternate Me

Posted Thursday, October 07, 2010 10:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 03, 2010 8:41 AM
Points: 6, Visits: 94

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.

Post #1000713

neerajtri1

Posted Wednesday, October 27, 2010 11:18 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 11:56 AM
Points: 14, Visits: 397

please send me the site through which i can download adventure works database 2008.

Post #1011768

neerajtri1

Posted Wednesday, October 27, 2010 11:21 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 11:56 AM
Points: 14, Visits: 397

please provide me some complex queries using joins and sub queries and self join and corelated query and using some funtions.

Post #1011770

« Prev Topic | Next Topic »

Permissions