|
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
Navigation:
[Reply to this message]
|