I am trying to create custom reports for ipcc express enhanced through crystal reports. I cannot connect to the crssql database. I have created a new account on the IPCC server that will be used for accessing the database, and put it into the administrators group.
When i try and access the database through crystal reports OLE DB (ADO) > Microsoft OLE DB Provider for SQL Server I receive an error "login Failed, not associated with a trusted SQL server connection"
I have SQL configured as windows authentication, because when i used mixed mode it caused an error with historical reports.
Can someone help me out with the proper process for providing access to the crssql database?