I have an issue with one of our development SQL Server Servers. We have databases that use full text search catalogs. Just some background info, our servers are configured to use separate drives for logs, data, and the default installation location This server is a virtual machine. When I try to create a new full text search catalog, it forces me to create it in the default installation directory, citing that you can't create a catalog on a removable drive. This seems kind of contrived since this is a VM, none of the drives are "physical", and the drive it will let me install it on isn't any less "removable" than the the others.

It does this on any of the test servers, but for this conversation the specifications are:

Windows Server 2008-R2 x64 Standard Edition

SQL Server 2005 9.0.5057

VMware vCenter Server

All of these drives are attached to the vm as Hard disks, not mapped drives. drives

But when creating a new catalog, I always receive an error unless I put the catalog on the same drive the instance is installed on.


Is this just a quirk with sql server, or is there a work around? I know in newer versions of sql server, the catalogs are stored internally, and so this isn't an issue, but a number of our servers are still and will stay for quite some time on sql server 2005. Has anyone else seen this issue? Did you find a solution?

1 Answer 1


Use a folder other than the root of the hard drive. UAC is preventing you from writing to the root of the drive.

  • That did the trick. Maybe I'm just oblivious, but I've never read this anywhere. Do you know if and where this is documented? Just for future reference? Thanks again.
    – jwhaley58
    Commented May 12, 2013 at 19:25
  • It's a standard rule of UAC that non-privileged accounts (anything but the local administrator account) can't create files in the root of hard drives.
    – mrdenny
    Commented May 12, 2013 at 22:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.