Drives missing from requester...how come ?

I'm trying to attach to a database that's stored in my D: partition on my disk. The disk has partitions C: D: E: F:

But when I choose "Attach", and open the requester to select the database-file, only drives C: and E: are shown.

All other programs lists the partitions right.

Where have D: and F: gone to ?

YOu will only see fixed drives of the server, so if you are remote administering the server, you won′t see the local drives in the folder dialog.

HTH, Jens K. Sü?meyer.

http://www.sqlserver2005.de|||

All partitions are on the same physical disk. Why isn't E: also hidden then ?

And how can I be able to use drive D: ? The drives are still hidden either if I administer the server by Remote Desktop, or if I work directly on the computer.

|||

My guess is that this is a permissions issue. SQL Express runs in the context of Network Service, which is a limited user account. Check the NTFS permissions on your other drives and determine if the Network Service account has appropriate permissions.

Mike