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

Drive missing from Enterprise Manager

Hi,

I have an SQL cluster on Windows 2003 with 2 drives (1 for dbs and 1 for logs). Both of these drives are accessible from Windows explorer.

In Enterprise Manager only the db drive appears as a location to house dbs and logs.

I can't work out how to get the second drive to appear and adding the path manual doesn't work as I end up with the other drive letter appending to the front eg "y:\z:\logs"

Has anyone seen this or have any ideas how to fix it?

Help much appreciated.What's your cluster like? Active/Passive or Active/Active?|||The cluster is active/passive.

Just figured it out, I forgot to add the log drive to the dependennce list for the SQL service.