PlateSpin Forge Appliance ships with Microsoft SQL Server 2014 database engine configured for the PlateSpin database. Initially, the database engine uses a generated a password for the SQL system administrator user (sa). You can use your Windows Administrator credentials and SQL management tools to modify the password without needing to know the generated password.
NOTE:For improved security, we strongly recommend that you modify the password for the SQL Server sa credentials after you set up the Forge appliance in your environment. After you set a custom password for the sa user, you must be able to provide the password when you apply future upgrades for PlateSpin Forge Server software.
The Microsoft OSQL (osql) utility is included in the SQL Server software. You can use this tool to modify the SQL system administrator password for your SQL Server database engine. After you change the password, you must update the information for PlateSpin Server and restart the Platespin Server service.
To modify the SQL Server sa user password:
Log in to the Forge VM as the local Administrator user.
Launch the Administrator Command Prompt.
Modify the SQL system administrator password. Enter
osql -S .\PlateSpinDB -E -Q "ALTER LOGIN sa WITH PASSWORD = '${NewPassword}'"
This OSQL syntax executes the query that follows the -Q option, and then exits the OSQL utility.
This command uses the ALTER LOGIN syntax rather than the sp_password stored procedure as recommended by Microsoft in sp_password (Transact-SQL)
in the Microsoft SQL Server documentation.
For information about syntax and commands for OSQL, see OSQL Utility
in the Microsoft SQL Server documentation.
Update PlateSpin with the new password for the SQL system administrator user. Enter
%PROGRAM FILES%\"PlateSpin Forge Server"\bin\PlateSpin.UpdateConnectionString.exe /instance=.\PlateSpinDB /username=sa /password=${NewPassword}Restart the PlateSpin Server service. Enter
%PROGRAM FILES%\PlateSpin Forge Server\bin\RestartPlateSpinServer\RestartPlateSpinServer.exe