Affichage des articles dont le libellé est sqlserver. Afficher tous les articles
Affichage des articles dont le libellé est sqlserver. Afficher tous les articles

mercredi 21 mars 2012

SQL Server: Operating System Error 5 (Access Denied)

when i tried to bakup my sqlserver database under win serv 2003 i get a strange error


Cannot open backup device 'C:\***********'. Operating system error 5(access denied). RESTORE HEADER ONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

Cause
The SQL Configuration Manager cannot log in due to shared permissions issue under the executed backup account.

Resolution
  1. Open SQL Configuration Manager
  2. Right-click on the database instance (typically SQL Server: SRVMGRENT) and select Properties from the pop-up menu.
  3. On the Log On tab, change Built-in account to Local System.
  4. Click the OK button.


Nombre total de pages vues