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

SQL Server 2005 Login Error: Unable to connect to SQL Server

We just upgraded from SQL Server 6.5 to SQL Server 2005.  I'm trying to create a report with Crystal 8.5 (like I normally do for this particular type of report...):
From Standard Report Export, I click the Database button, it displays the Data Explorer window, I expand More Data Sources, I expand Microsoft SQL Server and it displays a Microsoft SQL Server login window.  I enter the information, making sure that the server information is entered as ServerName\SQLServer2005InstanceName.  I then enter the User Id and Password and then I get an hourglass as it tries to connect to SQL Server and populate the Database dropdown box.  When I click on the dropdown box to select the db, I get a Login Error:  Unable to connect to SQL Server.

I know there are other ways to set up the database for a report, but for this one particular type of report, it must be set up with the p2ssql.dll driver.  So please do not reply with other database connection methods.  I just want to know why it doesn't connect to SQL Server.  If I change the server info to the old server, it has no problem connecting to it.  (In case you're wondering, I've super double-checked the password).  Thank you.  Looking forward to your replies.
0
MariaHalt
Asked:
MariaHalt
  • 4
  • 3
1 Solution
 
Kurt ReinhardtCommented:
My immediate thought is that you  may need to update the actual p2ssql.dll driver.  The most recent drivers available for your version Crystal Reports are from December 2004, though, so if you have the most recent service pack, you might already have them.

http://support.businessobjects.com/communityCS/FilesAndUpdates/dbexdrvrwin_en.zip.asp

~Kurt
0
 
MariaHaltAuthor Commented:
Thank you for replying.  I installed the service pack referenced by your link and restarted my computer.  Unfortunately, it made no difference.  
0
 
mlmccCommented:
WHen you upgraded did you install the new MS SQL drivers on your machine?  To use p2ssql you need the MS SQL client installed.

Try using MS SQL OLE instead of the native driver.

mlmcc
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
MariaHaltAuthor Commented:
mlmcc:

Thanks for your reply...I think you're pointing me in the right direction...but I have one minor (?) problem...I can't seem to find the SQL Server 2005 client software to install on my pc (which is where I develop all my Crystal Reports).  There are hundreds of CDs/DVDs here and they all look alike to me, I should probably open a new question, but I'm here now and desperate...which disc has the client software?  The developer's edition?  I'm afraid I'll install the wrong thing.  Arghhh...ppplease help!
0
 
MariaHaltAuthor Commented:
Everyone ignore my previous comment...I've got MS SQL Server Studio Management running on my pc finally!!!  Back to my original problem...Crystal Reports is still not populating the Database dropdown box and I'm still getting the error:  Unable to connect to SQL server.
0
 
mlmccCommented:
Not sure that is the right thing.  Do you have Enterprise manager installed?  Can you connect and see the database using Enterprise Manager?

mlmcc
0
 
MariaHaltAuthor Commented:
mlmcc:  I accepted your answer b/c I was getting no where with the native driver and am converting all the reports to OLE, like you suggested.
0
 
mlmccCommented:
We had many problems with the native drivers, mainly because we had to install them on all the user machines.  We used OLE because it required no additional (other than what the Crystal application installed) dlls or licenses.

Glad i could help

mlmcc
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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