Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Attaching database Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 4:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:38 PM
Points: 190, Visits: 478
Hi All,
I downloaded the adventureworks2012 database and followed the normal procedure to attach database. I placed the mdf and ldf files in D: drive. when i am trying to attach .mdf file it is throwing error message: OS error 5 (access denied).What is the reason for this.I changed the path to C: and attempted to attach . It went fine and database is in read only mode. I tried to put in normal mode and i am getting the same error.
Post #1450992
Posted Thursday, May 9, 2013 4:32 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, October 31, 2014 10:27 AM
Points: 708, Visits: 3,293
Most likely to be a security issue. What account is the SQL Server service using? Does the account have the required permission on the D drive?

---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1451000
Posted Thursday, May 9, 2013 4:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:32 AM
Points: 34, Visits: 70
agreed with Abu Dina, Please check in Administrative Tools>>services>> Sql server>> Property >> logon
Then check which user is used and see the permissions.
Post #1451001
Posted Thursday, May 9, 2013 4:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:38 PM
Points: 190, Visits: 478
It is running under NT Service\MSSQLSERVER . How to check permissions
Post #1451014
Posted Thursday, May 9, 2013 5:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:32 AM
Points: 34, Visits: 70
Hi m.rajesh


Go to Control panel>>User Accounts

and to see permission on D drive >>right click on d:>>property>>security>>Click on user and see the permission.
Post #1451024
Posted Friday, May 10, 2013 3:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 3:32 AM
Points: 1,639, Visits: 5,721
More information on granting appropriate file system permissions here:

http://msdn.microsoft.com/en-us/library/jj219062.aspx
Post #1451478
Posted Friday, May 10, 2013 4:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 4:25 AM
Points: 122, Visits: 479
I've had this issue, had to get it working. File came from another machine.

I granted "everyone" full access to the file attached it (windows permissions) - sledgehammer approach.

Then removed the permissions afterwards.
Post #1451508
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse