troubleshooting Question

Crystal Reports - SQL Database

Avatar of paulrausch
paulrauschFlag for United States of America asked on
Crystal ReportsMicrosoft SQL Server 2005
14 Comments1 Solution3179 ViewsLast Modified:
I have a client who used to use Deltek FMS with Crystal Reports for their Management Software. They migrated to a new system, and kept the old in the event they needed to look back at something. Their old system running Deltek FMS died, and the IT Co. before me had only done what appears to be file level backups. I now need to try and restore the database with what I have.
My Question is, I have located the .mdf and .ldf database files that I believe to be the correct ones; does anyone know how to get Crystal Reports to interface with the database? Its SQL Studio 2005 with Crystal Reports XI. I can attach the database files, but when I attempt to connect to the database via Crystal Reports I get numerous ODBC errors. I am in no way, shape, or form a SQL expert. Any help would be appreciated.
Norman Maina
System Admin / Lead Dev

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros