I installed SQL Server 2008 Express on a virtual 2008 R2 Server, configured with separate drives for the various data directories (database, Temp DB and Backup)
I am part of an Admin group and had access to the these drives prior to the install. After the install completed, I wanted to move a mdf and ldf files to the respective drives to attach the database only to find that I no longer had access to the drives,
the machine was restarted after installing sql server successfully (no error reporting during the install).
This is the first time I have done it like this (separate drives) and after spending hours trying to find a solution figured I would turn here for some guidance.
I guess I have two questions:
Is it normal for the server install to restrict access to the various drives? I appreciate that this is done for security purposes. Should these drives security setting be altered ? If so, how ?
Secondly, if this is how its done, ho ...
Go to the complete details ...