Posted by zieglers on May 10, 2006
I wanted to share my experiences just after configuring on a single server with two instances. I used to have problems with logshipping at the phase of restore job on the standby instance. The problem was service account of SQL Server Agent running on the standby server. In order to provide a good and clear demonstration, I set up two instances on a single server rather than setting up two distinct servers with one instance on each. Doing so, I was able to overcome the difficulties and problems due to permissions related with SQL Server Agent. Simply, both agent services were running with local system account. So, it worked! That way, I was also able to prevent the need of installing an additional server or a domain.