I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn't work. All of the reports <old/new> work correctly locally so it must be an ODBC issue? I created a service account and linked both crystal services to this account which has authority to run things but yet I'm still always prompted for username/password with no results ever coming. Ideas??
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!