October 18, 2011 at 9:14 am
Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).
Please verify SQL Server Service Account & its privileges.
October 18, 2011 at 9:35 am
The service run with same windows login which has sysadmin privileges on both the servers.
October 18, 2011 at 9:52 am
The service run with same windows login which has sysadmin privileges on both the servers.
Can you login to physical box with SQL Server Service Account & access this files?
'\\server1\d$\backup\TLshipping\testdb.bak'
October 21, 2011 at 7:44 am
Can we setup logshipping between two servers which are not part of a single domain.
They are two independent servers.
October 21, 2011 at 8:13 am
You have both the servers running under the same service account? They are not in the same domain, so how did you manage that?
Did you use identical local account? or do you have cross domain trust set up?
-Roy
October 21, 2011 at 8:18 am
They are not running with the same service account.
October 21, 2011 at 8:22 am
October 21, 2011 at 8:25 am
Do you have cross domain set up? How do you make sure that the Service account of Server A has all access to the Folder in Server B to copy the log files over?
-Roy
October 21, 2011 at 9:30 am
Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).
I've had issues before using the admin shares like that across servers. Get rid of it. Create an actual share on the \\server1 that points to the proper directory, grant the appropriate "Sharing and Security" and change your path to be:
\\server1\LogShipping
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 9 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply