From the Query Analyzer run

master..xp_fixeddrives

It will display all available fixed drives.

>I have tries to create a database where the mdf and log reside in the d: but Enteprise Manager cannot locate this drive. I have login as the Adminstrator. What I should do to make this work?