Permissions Error

Copper 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.