Note: These errors typically indicate network/installation-related issues. To help prevent these types of problems in the future, review the Database Administration Guide and our system requirements before installing or updating.
Try each of the following steps in order until the error is resolved:
- Verify that the user name and password you are using is correct.
- Verify the SQL Server service is running on the server and attempt to login at the server.
- Verify the version of the executable being used on the workstations matches the one on the server.
- Verify the database is online. Then, detach and reattach the database to the Blackbaud Management Console.
- Rename the BBUPDATE.INI file on the workstation.
- Determine the server's IP address and then attempt to PING the SQL server by IP address and by server name (DNS name) from a command prompt
- If the PING by IP address fails, contact a qualified IT professional for assistance with TCPIP. See Microsoft solution 325487 for more information
- If the IP Ping connects but the PING by server name fails or reports a different IP address than the one found on the server, contact a certified IT professional to address the name resolution problem on the DNS server, or, as a temporary fix, add information to the HOSTS file of problem machines.
- If your database is integrated with another Blackbaud product and that other product is installed on a separate server, verify that you are able to successfully ping and connect to that server as well. For example, if The Raiser's Edge and The Education Edge are integrated together but reside on separate servers, ensure that you can access both The Raiser's Edge server as well as The Education Edge server.
- Determine which version and edition of SQL Server is being used (SQL Server Standard or Enterprise Edition or MSDE). If using SQL Server 2005, refer to Knowledgebase solution BB245576 for changes which need to be made to SQL Server in order to use it with Blackbaud databases.
- If using the full version of SQL Server verify the authentication method being used by SQL Server
- [SQL Server Full version only] If using Windows Only authentication, first add the proper permissions needed for users in a Windows Only authentication environment
- [SQL Server Full and MSDE versions] If Using Mixed mode authentication or once permissions have been added for users in Windows Only authentication try to PING the server by IP address and by server name from DOS
- If the PING by IP address fails, contact a qualified IT professional for assistance with TCPIP. If the IP Ping connects but the PING by server name fails, have a certified network professional address the name resolution problem on the network or add information to the HOSTS file of problem machines
- Determine the port number and protocols being used by SQL Server.
- If Enterprise Manager is installed, make sure the port is not being used by another instance of SQL Server. If it is, change port for the Blackbaud product to 5050.
- If Windows XP SP2 is installed, or another firewall is running, verify the correct port number is opened in the firewall.
- If using SQL Server Standard or Enterprise Edition, verify the authentication method being used by SQL Server.
- If using Windows Only authentication, first add the proper permissions needed for users in a Windows Only authentication environment
- Verify you are running MDAC version 2.8 or higher. If not, download and install the latest version of the MDAC.
- Telnet the port being used by SQL Server to verify the connection is possible
- If Telnet connects, set the DSN for the product to use the port specifically and manually set the port on the server for all workstations
- If Telnet fails, contact a qualified IT professional for assistance troubleshooting the telnet utility
Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
If Blackbaud hosts your database, Contact Support and reference this article.
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.
If this error occurs when logging into the sample database, try these steps:
- Detach the sample database
- Download a new copy of the sample database (The Raiser's Edge) and (The Financial Edge/The Education Edge)
- Attach the sample database via the Blackbaud Management Console
- Log into the application on the Blackbaud Management Console server
- If prompted, update the database
- Attempt to log in from the workstation