Microsoft SQL Server Management Studio

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shenoda
    New Member
    • Jun 2013
    • 1

    Microsoft SQL Server Management Studio

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Attach database failed for Server 'SHENODA-PC'. (Microsoft.SqlS erver.Smo)

    For help, click: http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&ProdVer= 9.00.3042.00&Ev tSrc=Microsoft. SqlServer.Manag ement.Smo.Excep tionTemplates.F ailedOperationE xceptionText&Ev tID=Attach+data base+Server&Lin kId=20476

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlS erver.Connectio nInfo)

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

    Unable to open the physical file "Z:\My Work\church members\data base\church_mem bers.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

    For help, click: http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&ProdVer= 09.00.3042&EvtS rc=MSSQLServer& EvtID=5120&Link Id=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    That's a simple enough error. Whatever account is trying to access that file does not have the permission to access that file.

    That's all we can say at this point since we have no code to look at.

    Comment

    Working...