Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 5.1.0.88016

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.

error

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?

share|improve this question

migrated from stackoverflow.com May 12 '13 at 9:01

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 2 down vote accepted

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

share|improve this answer
    
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 May 12 '13 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 May 12 '13 at 22:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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