none
DPM 2007 error attach database RRS feed

  • Question

  • Hi folks,

     

    The database (MS$DPM2007$) was accidentally detached. When I try to attach by MS SQL Server Management Studio, I get the following error:


    c:\Program Files\Microsoft DPM\SQL\MSSQL.1\MSSQL\DATA
    Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. 

    If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.


    The message states permissions issue but no change was made, was only detach the database.

    I did an installation of DPM 2007 in a testing machine to simulate the error and really, if detach the database, I can no longer attach again.

     

    Thanks!!!

    Monday, September 13, 2010 9:33 PM

Answers

  • Hey,

    I know that the database of DPM is quite well protected :-).

    In your test environment, could you overwrite the ACL of the directory so that admins or your user get all the rights necessary on the file system?

    If that doesn't work, could you login with the specific user created during the install to management studio and try the attach again

    Just my 2 cents,

    Cheers,

    Mike Resseler


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Tuesday, September 14, 2010 7:13 AM
    Moderator

All replies

  • Hey,

    I know that the database of DPM is quite well protected :-).

    In your test environment, could you overwrite the ACL of the directory so that admins or your user get all the rights necessary on the file system?

    If that doesn't work, could you login with the specific user created during the install to management studio and try the attach again

    Just my 2 cents,

    Cheers,

    Mike Resseler


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Tuesday, September 14, 2010 7:13 AM
    Moderator
  •  

    Hello Mike,

    Thanks for the tip ... After testing all accounts, I discovered that I needed to add the account MICROSOFT$DPM$Acct in the DPM and SQL folders (C:\Program Files\Microsoft DPM) and child folders.

     

    Thanks again.

    Thursday, September 16, 2010 2:30 AM