Advertisement

07.20.2007 at 08:27AM PDT, ID: 22709940
[x]
Attachment Details

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

Asked by MariaHalt in Business Objects, Crystal Reports Software

Tags: sql, server, connect, 2005, unable

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.Start Free Trial
[+][-]07.20.2007 at 08:49AM PDT, ID: 19532244

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.20.2007 at 10:50AM PDT, ID: 19533410

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.20.2007 at 02:14PM PDT, ID: 19535298

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Business Objects, Crystal Reports Software
Tags: sql, server, connect, 2005, unable
Sign Up Now!
Solution Provided By: mlmcc
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.24.2007 at 11:43AM PDT, ID: 19558784

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2007 at 08:17AM PDT, ID: 19566239

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2007 at 08:36AM PDT, ID: 19566469

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.03.2007 at 06:58AM PDT, ID: 19624941

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.03.2007 at 08:56PM PDT, ID: 19629892

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32