Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    Security: Access Control

    Sort by:
    ‎05-22-2018 12:45 PM
    Installshield Wizard for Microsoft SQL Server 2005 Express Edition Server Pack 3 (SP3).
    View full article
    ‎05-25-2018 04:57 PM
    This article has some of the rdkypro default passwords.
    View full article
    ‎05-22-2018 11:36 AM
      Related ProductsReadykey Pro Question How can I ensure that clients do not change certain features that require exclusive use of the SQL database for Readykey Pro? Answer Certain activities require that there are not any applications logged into the SQL database. These activities include running a database backup, archive, database setup, or forms designer. In some cases, a server has many clients logged into the database remotely. This makes it difficult to close all client connections. There is an easy way to work around this by running a few SQL commands. Login to SQL Management Studio Express. Expand the Databases folder and find AccessControl (for example, the Readykey Pro database). Right click on AccessControl and select New Query. In the query window, type: sp_who2 [Click EXECUTE]. Look for all SPID that have the login type of lenel. For each SPID number of login type lenel, type: kill (SPID) [Click EXECUTE]. IMPORTANT: Do not kill SPID for SQL Server, as this will kill the Management Studio connection. Run the required application (for example, Database Backup). This method does not prevent future connections to SQL Server. If an exclusive connection is required, the port SQL Server uses can be blocked by a firewall (for example, TCP port 1433). You should block ports with caution because it may also block local connections. A better solution would be to temporarily disable remote connections to SQL Server using SQL Server Configuration Manager.
    View full article
    Top 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