January 6, 2009 at 6:51 pm
Hello
We have a (Production) Primary and Standby databases and the Log Shipping taking place using a domain account for the SQLServices. That way the authentication pass through takes place correctly ; Or else we get Anonymous Login. In our new project , we are not allowed to use domain account for running the SQLServices. Will xp_cmdshell or bcp be of help? I am not familiar with these commands and will be reading more on them soon.
Anyone out there has tried shipping log without domain account? Ideas as usual will be appreciated.
TIA
January 7, 2009 at 7:19 am
I'm not sure how you could.
To move the log ship files you need to be able to move the physical log dumps between two locations, or be able to access them from another share.
If neither side of the equation has the ability to access the share on another then you are not going to be able to accomplish this task.
January 7, 2009 at 12:10 pm
It can be done, but you would need to keep an account on each machine with the same id (and keep the password synchronised). Alternatively could you run the copy step under a domain account outside of SQL (eg robocopy etc)?
January 7, 2009 at 12:17 pm
I would ask if a standby solution is required why on earth you are not allowed to use a domain user account with the correct privileges. AD can be used to restrict the account to only be allowed to logon to the two servers involved.
Failing that matts suggestion will work
---------------------------------------------------------------------
January 7, 2009 at 1:24 pm
You could try to move the logs using FTP then you don't need a domain account for the copy just FTP access.
* Noel
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply