Important Cookie Information

This website uses absolutely necessary cookies. If you consent to the use of convenience cookies, please click “Yes, I agree.” By clicking on “Privacy Settings.” you can change this setting at any time and withdraw your given consent. Icon down see more You can find detailled information in our Privacy Policy Icon forward-right
Icon up see less

Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    How to troubleshoot Database Connection Failed error when opening RPS.

    When Remote Programming Software opens, a secure connection is made to the database which is located in an instance of SQL. If the connection to SQL is not successful or the database is not accessible, the Database connection failed error will display (see figure 1).

    Database Connection Failed.png

    Figure 1  Database connection failed error

    • This article discusses some possible causes for the database connection to fail, select Details for more information.
    • Some common causes for the database connection to fail are; failure to connect to the SQL Server, failure to open the database or failure to authenticate the user (see figure 2).

    Database Connect Failed 3 reasons.png

    Figure 2  Three common causes for the database connection failure

    • Review the information displayed in details, then select OK to open the Database Settings Page (see figure 3). This page may also be accessed by selecting Config and System from the front page of RPS.
    • Note the following settings which are applied during a basic installation of RPS;
      • SQL Server Name: The Computer Name followed by back-slash [\] and the name of the SQL instance where the database is located, e.g. [computer-name\SQL Instance Name]. The default SQL instance name is BOSCHSQL.
      • SQL Database Name: The name of the database used by RPS. The default database name is RPSDB.
      • Authentication: The method for authenticating the database connection. The default entry is SQL Server Authentication.
      • User Name: The user to be authenticated when using SQL Server Authentication. The default entry is sa (system administrator).
      • Password: The password used to authenticate the user when using SQL Server Authentication. The default password is RPSsql12345.

    System Configuration page.png

    Figure 3  System Configuration Page

    1.   Failure to connect to the SQL Server. Details displays:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. (Provider: SQL Network Interfaces, error: 26 – Error Locating Server\Instance Specified).”

    In this case the connection to the SQL Server has failed causing the database connection to fail. Press OK and return to the Database Settings page. Troubleshoot using the following steps;

    • Check for a correct SQL Server name entry with the following format; [computer-name\SQL Instance Name]. Be sure that a backslash [\] is used between items.
      • [Computer-name] represents the name of the computer with SQL installed.
      • [SQL Instance Name] represents the name of the SQL Instance where the RPS database is located. Note that there may be more than one instance of SQL on the PC. The correct instance name must be entered here.
    • Open Computer Services using the steps below to verify; 1) SQL is installed, 2) the correct instance name is entered in Database Settings, and 3) the related service is running.
      • Right-click on This PC or Computer and then select Manage and Computer Management opens.
      • Windows Computer Icon.png
      • Select Services and Applications and then select Services to open Computer Services (see figure 4).
      • How to access Services.png
      • Figure 4  How to access Services and Applications
      • A list of computer services displays as in figure 5. Identify the SQL Server service with the RPS database, e.g.  SQL Server (instance-name) from the list. Verify this instance name was entered correctly in the Database Settings page under System Configuration (see figure 3).  If the service is not listed, then the instance is not installed on this PC. 
      •  
      • Locate the SQL Service.png
      • Figure 5  Locate the SQL Service
      • Note the Status and Startup Type for the Service. If status does not display Running, right-click on the service and select Start. If the Startup Type does not show Automatic it must be changed from the properties page. Access the properties page by double-clicking on the SQL Server service. Select Automatic from the drop-down list in the properties page as displayed in figure 6.
      • Set Service to start automatic.png

    Figure 6 Verify the Service is running and Startup is Automatic

    2.   Failure to open the database. Details will display;

    “Cannot open database “[database name]” requested by the login. The login failed. Login failed for user ‘sa’”.

     In this case the database failed to open after the connection was made to SQL. Press OK and return to the Database Settings page.  Troubleshoot using the following steps;

    • Verify the Database Name entry is correct.
      • Navigate to the following path and note the name in brackets and verify it was entered correctly in Database Settings;
        • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.BOSCHSQL\DATA\[database name]
    • Press Upgrade Database. This updates the database tables as well as verifies correct ability to ‘write’ data to the database.
    • Verify the RPS installation was executed by right-clicking on the installation file and selecting ‘run as administrator’ (see figure 7 ). This permits the system to make required changes to the registry as well as grant read/write permissions to files & folders where needed.

    Run As Administrator.png

    Figure 7 Install with Administrator Privileges

    • Attempt to create a new database.  As a possible last resort, this will validate that the login method had the ability to create a new database and has write permissions to update tables.

    3.   Failure to authenticate the user: Details will display;

    “Login failed for user sa”.

    In this case the RPS uses SQL Server Authentication to authenticate the database connection, using the user/password entered in Database Settings.  The problem may be caused by an incorrect password or one which doesn’t meet domain restrictions for complex passwords.  Press OK and return to the Database Settings page. Troubleshoot using the following steps;

    • Manually enter the default user name and password loaded with a basic install of RPS; User Name: sa and Password: RPSsql12345. Change Authentication from SQL Server Authentication to Windows Authentication in Database Settings. If the connection fails proceed to the next step.
    • Use Microsoft SQL Server Management Studio to verify a correct password is used, or to create a new password which satisfies the domain requirements for complex passwords. Examples are;
      • Minimum number of characters.
      • Upper case characters.
      • Lower case characters.
      • Numbers between 0-9.
      • Non-alphabetic (special) characters (for example, !, $, #, %)

     Download and install Microsoft SQL Server Management Studio (SSMS).

    Download MS SSMS.png

     Figure 8  Download SSMS

    •  Click the Download SQL Server Management Studio link.
    • Right-click the downloaded SSMS setup file and select Run as Administrator.
    • Follow the on-screen prompts to install SSMS.
    • Welcome to SSMS Install screen.png

     Figure 9  Welcome to install screen

    •  Select Install.

    SSMS Restart Required.pngFigure 10  Select Restart

    •  Select Restart to complete the installation(see figure 10).

     Open SQL Management Studio.png

    Figure 11  Open Management Studio

    •  Open SQL Server Management Studio (see figure 11).

     Connect Windows Auth select Connect.png

    Figure 12  Log in using Windows Authentication

    • The Connect to Server dialog opens. Select Windows Authentication and then select Connect to log into the server's dashboard (see figure 12).

     Object Explorer Screen.png

    Figure 13 Object Explorer

    •  SQL Server opens to the Object Explorer page with configuration options (see figure 13).

     Object Explorer Security Expanded.png

    Figure 14  Object Explorer Security expanded

    • Double-click on Security or click on [+]to expand the folder (see figure 14).

     Object Explorer Logins Expanded.png

    Figure 15  Object Explorer Logins Expanded

    • Double-click on Logins or click on [+]to expand the folder and then double-click on the user; sa (system administrator) to open the Login Properties page (see figure 15).

     Login Properties sa password.png

    Figure 16  Login Properties sa password

    •  The login properties for user: sa opens to the General page.
      • Enter the default password RPSsql12345 in Password and again in Confirm Password.
      • Select OK at the bottom of the page.

    Note that the overall settings in Microsoft SQL go beyond the scope of this article. The assistance of a qualified SQL administrator may be needed when the steps in this article have not resolved the "Database Connection Failed" error.

    Version history
    Revision #:
    18 of 18
    Last update:
    Tuesday
    Updated by:
     
    Labels (3)
    Contributors
    Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist