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

while attaching db error occur Expand / Collapse
while attaching sample db error occur please help to me
Poll ResultsVotes
TITLE: Microsoft SQL Server Management Studio
0%
0
------------------------------
0%
0
0%
0
Attach database failed for Server 'LAHYASAI'. (Microsoft.SqlServer.Smo)
0%
0
0%
0
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1322+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
0%
0
0%
0
------------------------------
0%
0
ADDITIONAL INFORMATION:
 
100%
1
0%
0
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
0%
0
0%
0
------------------------------
0%
0
0%
0
0%
0
Member Votes: 1, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Tuesday, April 2, 2013 1:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 1, 2013 11:27 PM
Points: 2, Visits: 22
Unable to open the physical file "E:\pubs.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3000&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
Post #1438065
Posted Tuesday, April 2, 2013 1:14 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:52 PM
Points: 896, Visits: 7,077
Usual cause is that the account under which the sql server is running does not have access rights to that file or directory.



And then again, I might be wrong ...
David Webb
Post #1438069
Posted Tuesday, April 2, 2013 2:23 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 42,437, Visits: 35,492
Error 5 is permission denied. The account SQL is running under does not have full control to the folder or file in question.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1438080
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse