We are updating a Crystal Report to connect to SQL server (the database was moved from Oracle), and we are trying to make it connect to SQL server using an active directory account. I was able to get this working on my local machine using my own account, but when I deploy it to the Crystal Enterprise server, the connection fails. It appears to be using a username of "<domain>\<machine name>$". How do we change this to use a specified account?
What makes this even more puzzling is that the Crystal Enterprise CMS database is on SQL server, and it uses "<domain>\CrystalEnterprise" to connect to that.
The connection string I am using in the report is DRIVER={SQL Server};Persist Security Info=True;Database=<database name>;Server=<server name>\MSSQLV05;Trusted Connection=True
We are using BusinessObjects Enterprise 11.0 and SQL Server 2005.