I'm in the process of rebuilding our production publisher for use in our lab. I've taken a BARS generated backup .tar of the production publisher and am trying to do a recovery on an identical server in the lab.
When I do this I get the following error and the restore fails:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Now both the servers are running ccm 4.3(1)sr1a on win2003.1.2asr7 and BARS 4.0.12 . All passwords are the same as well as the hostnames and ip addresses. Both servers are MCS 7835 equivalent HP DL380s.
I've tried different backups with the same result.
Has anyone run into this before ?