Install SQL Server Management Studio

Learn how to install SQL Server Management Studio 2019 to view and edit Advance Steel databases.

In order to view and edit the contents of Advance Steel databases, you need to use SQL Server Management Studio 2019. This is an alternative to using the Management Tools application, because there are some operations (such as adding a new table to a database) that can only be done using the SQL Server application.

To install SQL Server Management Studio 2019 :

1. Make sure that your Windows operating system is up-to-date.
2. Access Microsoft® SQL Server 2019 Management Studio.
3. Click the Download button.
4. Run SSMS-Setup-ENU.exe.
   Note: Before you run the installer, make sure Advance Steel is closed.
5. Check the "I accept the terms in the license agreement" box and click Next in the License Agreement frame.
6. In the Ready to Install the Program frame, click Install.
7. When the installation is complete, click Finish to exit the installer.
8. To access SQL Server Management Studio, use the Windows Start menu, or create a desktop shortcut for easier access.

First-time start of SQL Server Management Studio

1. Start the tool from the Windows Start menu - to find it, type "Management Studio" in the search box.
2. In the Connect to Server window, enter "(LocalDB)\AdvanceSteel2024" in the server name field.
   Note: Starting with Advance Steel 2021, a separate instance is created for each version, and the instance name format is AdvanceSteel[version].

Click Connect to start SQL Server Management Studio.