SQL 2005 log shipping can work without AD. It can run on standalone but you will need to create a local user account with local admin rights with same username and password at both source and destination SQL server. Once user created, configure the SQL server service and SQL agent service to start with this account. Always remember to restart the services mentioned before proceeding to the following steps. Make sure the following are ready:- 1. Shared folders (with right permission for the SQL account startup account) at both source and destination server. 2. SQL agent service must be started Steps to configure Log Shipping on SQL Server 2005 1. Create a new user Account named “sqlagent” on both computers. Use the exact same user name and password. 2. Make sure File Sharing is enabled on the local area connection between the server. Also enable file sharing in Firewall. 3. Optional - Make sure the local network connection is not regular LAN. It must be a gigabit card with near zero
This is meant for educational purpose.