SQL Not connected from crystal report msg : Unable to connect

Posted on 2011-03-12
Medium Priority
Last Modified: 2012-08-14

I am using crystal report to design reports with sql 2008 , from last 2 days I am not able to connect SQL from crystal report with specific database , I can design report with other database.

I had created many reports from that database but now its not connecting.
pl. help

Question by:rbs1968
LVL 13

Accepted Solution

Rahul Agarwal earned 1000 total points
ID: 35115554
Please check whether the Login details you are provided are correct or not.
if this doesn't solves the problem then check whether driver you used to connect is Native Client or SQL OLE DB Provider. if its Native Client then Change it to SQL OLE DB Provider this may solved the problem.
LVL 101

Expert Comment

ID: 35116595
Are the databases on the same SQL Server?
If so did the permissions change for that database or for some of the tables?


Author Closing Comment

ID: 35127366
Pl. let me know how to do this as I am working on server it self as crystal report also installed on server.

Its working with other database and I had not changes any username password or any persmittion as I am working as SA and using same for connection.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question