• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

SQL Not connected from crystal report msg : Unable to connect

Hi

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

Rajesh
0
rbs1968
Asked:
rbs1968
1 Solution
 
Rahul AgarwalTeam LeaderCommented:
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.
0
 
mlmccCommented:
Are the databases on the same SQL Server?
If so did the permissions change for that database or for some of the tables?

mlmcc
0
 
rbs1968Author Commented:
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now