Restore Filelist Only Issue -- sql server new users

sql server new users : Restore Filelist Only Issue

G. Ray Giacalone
3/21/2006 4:50:32 PM

The following command works great on all of my SQL Instances EXCEPT on new
boxes with new SQL2005 installations:

use master
restore filelistonly
from disk = '\\sqlcluster\SQLBackups\ASG-GP\VE\VE_db_200603210200.BAK'

I run the script with Domain Admin priviledges and the SQL Logs tells me
that "access is denied".
What I am missing out of the security puzzle to make this work?

Thanx!!

Tom Moreau
3/21/2006 8:41:44 PM

What exactly do you mean by:

"I run the script with Domain Admin privileges ..."

The RESTORE is going to run under the account under which the SQL Server
Service is running. Perhaps you're running it under LocalSystem?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
The following command works great on all of my SQL Instances EXCEPT on new
boxes with new SQL2005 installations:

use master
restore filelistonly
from disk = '\\sqlcluster\SQLBackups\ASG-GP\VE\VE_db_200603210200.BAK'

I run the script with Domain Admin priviledges and the SQL Logs tells me
that "access is denied".
What I am missing out of the security puzzle to make this work?

Thanx!!

G. Ray Giacalone
3/22/2006 11:31:53 AM

YES...My SQLServices was logging in as a local account and not allowed to do
remote operations across the network.

THANK YOU TOM!!!

[quoted text, click to view]

Tom Moreau
3/22/2006 6:43:34 PM

My pleasure! :-)

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
YES...My SQLServices was logging in as a local account and not allowed to do
remote operations across the network.

THANK YOU TOM!!!

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn