Permissions Error

%3CLINGO-SUB%20id%3D%22lingo-sub-3043631%22%20slang%3D%22en-US%22%3EPermissions%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3043631%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20SQL%20Server%202016%20DB%20due%20to%20a%20shortage%20of%20disk%20space%20we%20are%20trying%20to%20move%20the%20DB's%20on%20the%20C%20Drive%20to%20the%20E%20Drive.%26nbsp%3B%20We%20have%201%20DB%20that%20was%20already%20there%20and%20that%20one%20works%20fine.%26nbsp%3B%20I%20can%20copy%20the%20DB's%20we%20want%20to%20move%20to%20that%20folder%20but%20when%20I%20try%20to%20attach%20that%20DB%20to%20SQL%20Server%20I%20get%20a%20permissions%20Error%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

We have a SQL Server 2016 DB due to a shortage of disk space we are trying to move the DB's on the C Drive to the E Drive.  We have 1 DB that was already there and that one works fine.  I can copy the DB's we want to move to that folder but when I try to attach that DB to SQL Server I get a permissions Error???

2 Replies

@RayMilhon , the SQL Server service account needs full access permissions on the drive/sub folders.

See Configure File System Permissions for Database Engine Access

@olafhelper   I've notified our Network Administrator Now I just have to wait for him to respond.  Unfortunately I don't have access to fix it.