We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

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

Medium Priority
5,003 Views
Last Modified: 2013-11-15
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.
Comment
Watch Question

Kurt ReinhardtSr. Business Intelligence Consultant/Architect

Commented:
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

Author

Commented:
Thank you for replying.  I installed the service pack referenced by your link and restarted my computer.  Unfortunately, it made no difference.  
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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!

Author

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.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Not sure that is the right thing.  Do you have Enterprise manager installed?  Can you connect and see the database using Enterprise Manager?

mlmcc

Author

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.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.