We are in the process of migrating our existing SQL databases to SQL 2008 R2 running on Windows 2008 R2 x64. I have build 5 new servers. These are virtual machines running on VMWare 4.1
I have created a C: drive and S: swap as VMDK's. I have installed Snapdrive 6.3.0 and created G:, H:, I:, and J: drives. They are all QTrees created on a FAS2040.
G: will be used for the databases
H: will be used for the logs
I: will be used for the system databases
J: will be used for Snapinfo
Our DBA logs into any one of these servers and has full administrator rights to the server including the drives. He has been given these rights via an Active directory group which is a member of local administrator's group.
He has full rights all of the drives but after installing SQL 2008R2 he gets a 'access denied' error to the G: H: and I: drives. All other drives are fine.
I have installed SnapManager for SQL v5.1 after the SQL installation and configured the server but still he gets access denied.
Has anybody else found this issue and if so what did you do to resolve it?
Please help!
Aaron