try to attach to a database file but can't browse folder which contains the file

Posted by Chadworthington on Super User See other posts from Super User or by Chadworthington
Published on 2010-06-04T01:09:51Z Indexed on 2010/06/05 6:03 UTC
Read the original article Hit count: 504

I am trying to attach to database file (*.mdf, *.ldf) that I placed in the same folder as all my other SQL Server databases. I begin the attach by attempting to browse to the folder which contains the db files as well as all of my active database files. I select "attach Database" and click the "Add" button to add a database to the list of databases to attach to. When I do so, I get this error:

TITLE: Locate Database Files - BESI-CHAD
------------------------------

D:\SQLdata\MSSQL10_50.SQLBESI\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.

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

OK
------------------------------

The path is correct and, as I mentioned, it contains all of my other database files so I wouldn't think that permissions should be an issue, but here is what I see for that folder:

alt text

Any idea why I cannot browse to that folder and attach to the db files that I have place there?

© Super User or respective owner

Related posts about sql-server-2008

Related posts about sql-management-studio