	Product(s):	Promis.e, Bentley Substation
	Version(s):	08.11.12.137 - 08.11.13.140
	Environment:	N/A
	Area:	Database Platform Support
	Subarea:	N/A

Problem Description

What happened to SQL Server Management Studio? After installing SQL Server I do not have SQL Server Management Studio installed.

Explanation

Beginning with the 08.11.12.137 version of Promis.e and Bentley Substation, the included SQL Server 2014 Express installation package does not include SQL Server Management Studio (SSMS). This is to reduce the size of the download, which is much larger when SSMS is included with SQL Server 2014 Express compared to previous versions.

Note: SQL Server Management Studio is not required for Promis.e or Bentley Substation to function or connect to a project database. It is useful for managing databases and for [[Creating and Updating the Project Database|creating project databases]] as an alternative to the Project Database Utility accessible from within the software.

Steps to Resolve

Download SQL Server Management Studio compatible with the version of SQL Server installed. As noted above, SQL Server 2014 Express is included with Promis.e and Bentley Substation version 08.11.12.137.

Download SQL Server Management Studio 2014

Go to http://www.microsoft.com/en-us/download/details.aspx?id=42299
Click the Download button.
Check the box next to "MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe" if SQL Server was installed via the promis.e or Bentley Substation package, or if the SQL Server installed is otherwise known to be 32-bit. Choose the 64-bit file if the 64-bit version of SQL Server was installed (this is not the case if installed via promis.e or Bentley Substation).
Click Next. The download should begin.

Install SQL Server Management Studio 2014

Run the downloaded file. The file for installing the 32-bit application is named SQLManagementStudio_x86_ENU.exe
The default directory for extracted files is generally acceptable, click OK on the Choose Directory box.
On the SQL Server Installation Center dialog that appears, click "New SQL Server stand-alone installation or add features to an existing installation".
Click Next until the Installation Type step appears.
Choose "Add features to an existing instance of SQL Server 2014".
Click Next until the Feature Selection step appears.
Set the check box for "Management Tools - Basic". The check box for "Management Tools - Complete" can optionally be set but is not required to install SQL Server Management Studio.
Click Next to install.

Original Author:

Matt_P