SQL Server 2005 Login Error: Unable to connect to SQL Server
Posted on 2007-07-20
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.