Missing drive when attaching database in SQL Management Studio 2005

Question

I'm trying to attach an external mdf file to my SQLEXPRESS instance from within the SQL Management Studio 2005. However, I'm unable to see the drive that the database file resides in under the directory browser within the "Locate Database Files" prompt.

Is there anything that is preventing the Management Studio or the SQL instance from recognising my drive? The drive itself is a local disk installed within my computer.

Answer 1

Check the permissions on the drive root. The folder browser runs under the SQL Engine identity, which may not have access to that drive.

Answer 2

devstuff, thanks a lot for your help! It was the problem with the file permissions.