Posted by Erland Sommarskog on 07/28/06 21:35

RAM (r_ahimsa_m@poczta.onet.pl) writes:
> but I have another problem:
> Cannot open backup device 'G:\DemoSQLServer.bak'. Operating system
> error 5(Access denied.).
>
> (Changing drive don't help.)
> I have no problem with accessing drives from other applications. I had
> no problems with SQL Server setup.

Is that a local drive or a network drive?

Presumably the service account for SQL Server does not have access to
this place. Keep in mind that SQL Server is a server application that
logs on its own.

Start SQL Server Configuraiton Manager. Select "SQL Server 2005 Services".
Find the SQL Server service you have problem with. Double-click. Here
you can see under which account SQL Server runs. If you change, you will
have to restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]