SQL Server Log Shipping Between Standalone\Workgroup Computers
In this article I want to discuss log shipping between servers that are not part of a Windows domain. Standalone windows servers are, instead, part of what is known as a workgroup. The authentication mechanisms in a workgroup differ to that of a domain. In an Active Directory domain, user accounts are centralised for management on what is known as a domain controller. Active Directory uses a multi master replication model catalog to provide centralised administration of objects such as users, groups, computers, printers, etc within a Windows domain across multiple domain controllers. Member servers and workstations are then joined to the domain and become able to share their resources as well as access other resources via domain wide accounts. In a Windows workgroup, each server is essentially a standalone account management system (SAM) and manages its own users, groups, printers, etc. How does a server\computer in a windows workgroup seamlessly access...