Setting up SQL Server Management Studio
 |
This topic contains and refers to SQL Server 2017–specific information. If you have installed a different SQL Server version, you must search for your version-specific information at
https://docs.microsoft.com.
|
SQL Server Management Studio or SSMS is a tool that allows administrators to manage SQL Server instances and perform administration tasks. SSMS is not installed as part of the Windchill Modeler installation. To use SSMS, you should download and set it up on the Windchill Modeler SQL Server instance. For a list of all supported versions of SQL Server, see the Release Notes document.
If your Windchill Modeler installation uses the default MODELER instance, you can add SSMS as an additional feature.
Download SQL Server Management Studio (SSMS)
To add to SSMS to an existing SQL Server instance, do the following:
1. Run the SQL Server Management Studio .exe setup.
2. Click New SQL Server stand-alone installation or add features to an existing installation. The SQL Server 2017 Setup wizard appears.
3. In the Setup wizard, under Installation Type, select Add features to an existing instance of SQL Server 2017.
4. Select an instance from the drop-down list, and then click Next.
5. In the Feature Selection page, select the Manage Tools - Basic check box, and then click Next.
6. Confirm that the installation succeeded, then click Close to finish.
Connecting to the Database engine using SQL Server Management Studio
For more information, refer to the following section in the SQL Server help:
Connecting with Management Studio