We installed a new Xenapp 6 on a Windows 2008 r2 server and we had a working citrix farm.

I installed it with the domain administrator credentials.

The login failed.[application]event id: 18456source: MSSQL$CITRIX_METAFRAMELogin failed for user 'NT AUTHORITY\NETWORK SERVICE'. When the Citrix Independent Management Architecture service (Citrix IMA) installs, it defaults to Network Service for the logon security.

Reason: Failed to open the explicitly specified database. We changed this to use our domain administrator account and the issue was resolved.I suspect what I really need to do is create a new account for this service.