Friday, March 9, 2012

non domain log shipping

According to KB article 314515 in regards to having log
shipping set up outside of a domain:
Q3: Do I have to start SQL Server related services under a
domain account as opposed to a local Windows NT account?
A3: It is possible to configure SQL Server services to
start under a local Windows NT account, unless SQL Server
is configured to run as a virtual server in conjunction
with Microsoft Cluster Service. You can use Windows NT
pass-through security for this purpose. Follow these steps
to configure pass-through security:
Create a Windows NT account on the primary, secondary and
monitor computers with the same name and passwords.
Configure SQL Server related services to start under these
Windows NT accounts on all computers.
So what if one of the computers is in a domain and one
isnt. The logins are set up like this:
Source
domain\administrator
Destination
local\administrator
Same passwords on both but Im still having problems.What problem are you having?
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment