C:/program files/Microsoft SQL Server/mssql.1/MSSQL/data cannot access the specified path or file on the server. Make sure that you have the required security permissions and the path or

C:/program files/Microsoft SQL Server/mssql.1/MSSQL/data cannot access the specified path or file on the server. Make sure that you have the required security permissions and the path or file exists. Solution:

Today, I want to log on to my default instance in SQL 2005 as an SQL Server. However, in this mode, the database cannot be restored. When I select the source device -- add, the following error occurs: C:/program files/Microsoft SQL Server/mssql.1/MSSQL/data cannot access the specified path or file on the server. Make sure that you have the required security permissions and the path or file exists.

I checked it online:

① Open the SQL Server Configuration Manager
② Click "SQL server2005 service" on the left, select sqlserver (instance), right-click Properties
③ The logon tab contains a built-in account, which is changed to a local system)
④ Restart the service

 

Problem persists

In Windows, you can restore the database. After restoring the database, you cannot access the restored database under SQL Server Authentication. You can use the database as the default database in this mode and cannot even log on to the database. Check online. It may be because the login name does not have the dbcreator permission and cannot be added to the dbcreator for Windows verification. After a while, add a security object in the login attribute of the login name, select the instance, check all options corresponding to the corresponding permissions, and click OK to solve the problem.

O yeah !! I am so amazing !!! Haha !!!