TITLE: Microsoft SQL Server Management Studio Express
——————————
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
——————————
ADDITIONAL INFORMATION:
Cannot open backup device ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\backup.bak’. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
Error is :
System.Data.SqlClient.SqlError: The operating system returned the error ‘5(Access is denied.)’ while attempting ‘RestoreContainer::ValidateTargetForCreation’ on ‘C:\Program Files\Microsoft SQL Server\MSSQL\Data\TCM2000_Data.MDF’. (Microsoft.SqlServer.Express.Smo)
1. open up sql server 2005 –> configuration tools–> SQL Server Configuration Manager (I am using SQL Server 2005)–> sql server 2005 services–>SQL Sever Express
2.right click on SQL Sever Express (I assume it is the same for the full version of SQL Server)
3.Choose Properties
4. in the Logon tab – click the built in account radio button and choose ‘Local system’ from the drop down.