The error occurs because the SQL Server resets the file permissions when the db is detached. Here, ‘ nn’ stands for SQL Server version.įor example, following is the default location of DATA file of MS SQL version 14.Ĭ:\Program Files\Microsoft SQL Server\MSSQL 14.SQLTECH2017\MSSQL\DATAįigure: SQL data folder Reason 2 – SQL Server Resets File Permissions when Database is DetachedĪlthough SQL Server administrator credentials might grant you the privilege to perform several activities, some activities require a different set of permissions.įor instance, your log-in credentials might allow you to remove the database but will throw the “ SQL Server Access denied” error message when you attempt to re-attach it.
The default location for SQL data files is as follows:Ĭ:\Program Files\Microsoft SQL Server\MSSQL.MyInstance\ Note: The database should not be in use when copying the files into the default folder. If they are not present, paste them in the default folder. Check whether the database files are present in their default location or not. Go to the default location of the file folder where the SQL database ( MDF/ LDF) files are stored. Solution – Check the Default Location of the Data File
SQL database files (MDF and NDF) are moved from their default location on the system drive to another location.
Figure: SQL Database Access Denied Error Possible Reasons behind Operating System Error 5 (access is denied) Error and Their Solutionsįollowing are the main reasons that may cause MS SQL ‘access denied error’ when attaching SQL database, along with their solutions: Reason 1 – Default Location of SQL Data Files Has Changed
0 kommentar(er)
