Opening Remote Programming Software initiates a connection with the database it uses, located in SQL. This connection is normally authenticated using SQL Server Authentication, and with the user name [sa] and default password [RPSsql12345]. If this password needs to be changed, for example to meet a domain’s requirements for a more complex password, SQL Server Management Studio is used to make the change. The following steps may be used to change the System Administrator (sa) password in SQL.
1. Download and install Microsoft SQL Server Management Studio (SSMS).