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 Reset or change the SA Password in SQL Server.

    Occasionally Remote Programming Software will not connect to SQL  and therefore cannot open.

     

     

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

    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server...

    Download MS SSMS.png

    • Go to the SSMS installation page in a browser.
    • Click on Download SQL Server Management Studio.
    • Right-click the downloaded SSMS setup file and select Run as Administrator.
    • Follow the on-screen prompts to install SSMS.

    3.   Open SQL Server Management Studio.

    Recently Added Software w SSMS.png

    4.   The Connect to Server dialog opens. Select Windows Authentication and select Connect to log you into your server's dashboard.

    Connect Windows Auth select Connect.png

    5.   The Object Explorer opens. The SQL Server Instance name opens and several options should expand below it. If the list doesn’t expand, click on the [+] icon to expand it.

    Object Explorer Screen.png

    6.   Click on the [+] beside Security to expand the folder.

    Object Explorer Security Expanded.png

    7.   Click on the [+] beside Logins to expand the folder.

    Object Explorer Logins Expanded.png

    8.   Double-click sa. It's in the "Logins" group of options. Doing so opens your System Administrator properties window.

    Login Properties sa password.png

    9.   Enter the new Password, then enter it again in to confirm.

    Password Confirm password.png

    10.   Select OK to save changes.

    Login Properties sa password-SAVE.png

     

     

     

     

     

     

     

     

    Version history
    Revision #:
    4 of 4
    Last update:
    3 weeks ago
    Updated by:
    KWS
     
    Labels (2)
    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