Resolving Missing SQL Server Management Studio in TIA Portal V13

Overview

After installing TIA Portal V13 SP1 together with STEP 7 V5.5 on a Windows 7 Professional SP1 64-bit engineering station, technicians regularly discover that Microsoft SQL Server Management Studio (SSMS) is absent from the Start menu even though the SQL Server 2008 R2 engine is visible in Control Panel → Programs and Features. The root cause is almost always an incorrect assumption about which TIA Portal installation option installs the SSMS client: SSMS ships only with WinCC Professional, not with WinCC Advanced, WinCC Compact, or WinCC Basic. This article explains the package architecture, identifies which component carries SSMS, and provides a safe path to install SSMS as a standalone tool on a TIA V13 SP1 engineering station without corrupting an existing WinCC Advanced runtime.

Problem Details

The reported symptoms match the canonical case for this issue:

• TIA Portal V13 SP1 installed (with STEP 7 V5.5 in mixed configuration).
• Windows 7 Professional SP1 64-bit operating system.
• SQL Server 2008 R2 components (Database Engine, Native Client, Setup support files) appear in Control Panel → Programs and Features.
• Start → Microsoft SQL Server 2008 R2 → SQL Server Management Studio shortcut is not present.
• Same set of TIA Portal installation packages on a second PC does produce the SSMS shortcut.
• Difference between the two PCs is the presence of WinCC Explorer (WinCC Professional) on the second PC.

The user typically needs SSMS to author a SQL Server database for WinCC / HMI tag logging, alarm logging, or for a custom reporting application. Without SSMS, databases can only be created through the SQL Server Configuration Manager and sqlcmd, which is impractical for production engineering work.

Root Cause

The TIA Portal V13 SP1 setup is a multi-product installer that bundles the engineering tools for SIMATIC S7-1500, S7-1200, S7-300/400, WinCC (TIA) and SINAMICS Startdrive. The WinCC component is split into three separate products with different delivery scopes:

Because SSMS is a tool used to administer the SQL Server Express instance that hosts the WinCC Professional process and alarm databases, it is delivered only inside the WinCC Professional installation media. The Advanced DVD contains the WinCC engineering project components but not the SQL client tools. This is by design: WinCC Advanced stores historical data and recipes in proprietary internal files and does not require SSMS, so Siemens omits it to keep the Advanced installation footprint small.

Identifying the Installed WinCC Edition

Before deploying any SQL tool, confirm exactly which WinCC product is present. The TIA Portal installation writes a registry key under HKLM\SOFTWARE\Wow6432Node\Siemens\Automation\WinCC\TIA that records the product and the build number.

1. Open Start → Run, enter regedit, and confirm the UAC prompt.
2. Navigate to HKLM\SOFTWARE\Wow6432Node\Siemens\Automation\WinCC\TIA\V13.0.
3. Inspect the value ProductName.
   • WinCC Comfort V13 SP1 — SSMS will not be present.
   • WinCC Advanced V13 SP1 — SSMS will not be present.
   • WinCC Professional V13 SP1 — SSMS should be present at Start → Microsoft SQL Server 2008 R2 → SQL Server Management Studio.
4. Cross-check Control Panel → Programs and Features for the entry Microsoft SQL Server 2008 R2 Management Studio.

Additionally, open TIA Portal V13 → Help → About and confirm the list of installed products. The Installed software dialog explicitly enumerates WinCC Comfort, WinCC Advanced, or WinCC Professional.

Solution: Install SQL Server Management Studio Standalone

For engineering stations running only WinCC Comfort or WinCC Advanced where SSMS is required for downstream reporting, install the tool as a standalone application. This path is officially supported by Microsoft and does not require the WinCC Professional media.

Prerequisites

• Administrator account on Windows 7 SP1 64-bit.
• Microsoft SQL Server 2008 R2 installation media (RTM or any service pack up to SP3) or a current SQL Server 2012 / 2014 / 2016 media.
• Approximately 1.2 GB free disk space on the system drive.
• .NET Framework 3.5 SP1 (already installed on TIA V13 SP1 systems).

Step-by-Step Procedure

1. Insert the Microsoft SQL Server 2008 R2 DVD or mount the ISO. If the SQL Server 2008 R2 DVD is not available, an SSMS-only redistributable can be obtained from the Microsoft Volume Licensing Center or the public Microsoft® SQL Server® 2008 R2 Service Pack 2 Express Edition package; the package contains a SQLEXPRWT_x64_ENU.exe installer that includes Management Studio.
2. Run setup.exe as Administrator.
3. Select Installation → New SQL Server stand-alone installation or add features to an existing installation.
4. On the Installation Type page, choose Add features to an existing instance of SQL Server 2008 R2. The pre-existing SQL Server 2008 R2 instance was installed by the WinCC Advanced / TIA Portal setup; selecting Perform a new installation will create a second instance that may collide with the WinCC configuration.
5. On the Feature Selection page, tick Shared Features → Management Tools - Basic and clear every other checkbox (Database Engine, Replication, Client Tools Connectivity are not required for authoring / reporting tasks).
6. Accept the defaults on the remaining pages. The setup will install only SSMS, leaving the existing TIA Portal SQL components untouched.
7. After the setup completes, the Start → Microsoft SQL Server 2008 R2 → SQL Server Management Studio shortcut is created.

Alternative: Use a Higher SSMS Version

SSMS version compatibility is forward-only. A newer SSMS (2012, 2014, 2016, or the current SSMS download) can administer SQL Server 2008 R2 instances just as well as the original SSMS 2008 R2 client. The current SSMS is delivered as a self-contained executable (no setup.exe bootstrap) and is the recommended way to obtain the management tools on a Windows 7 SP1 system because it bypasses the obsolete SQL Server 2008 R2 setup bootstraps.

1. Download the SSMS installer from Microsoft Learn — Download SQL Server Management Studio (SSMS).
2. Run the installer as Administrator.
3. Accept the default install location (C:\Program Files (x86)\Microsoft SQL Server Management Studio 18 or later).
4. Launch SSMS from the new Start menu folder.

This approach has the additional advantage of receiving regular security updates, which the SQL Server 2008 R2 SSMS no longer receives.

Verification

1. Click Start → (All Programs) → Microsoft SQL Server 2008 R2 → SQL Server Management Studio (or the newer version folder).
2. In the Connect to Server dialog, set:
   • Server type: Database Engine
   • Server name: localhost\SQLEXPRESS or .\WINCC depending on which instance was created by the TIA Portal setup.
   • Authentication: Windows Authentication
3. Click Connect. The Object Explorer should populate with Databases, Security, Server Objects, and Management nodes.
4. Run a sanity query: right-click the server, choose New Query, and execute SELECT @@VERSION;. The result must be a string beginning with Microsoft SQL Server 2008 R2 and the SP-level of the installed engine.

Connecting an S7-1500 / S7-1200 to a SQL Database

Once SSMS is available, the most common follow-up task is to log PLC data to a SQL database. Siemens has published a detailed application note for S7-1500 / S7-1200 controllers connecting to a Microsoft SQL Server (Express) using the SIMATIC S7-1500 open user communication over TCP / OPC UA. Refer to the official Siemens application: Connecting an S7-1500 / S7-1200 to a SQL database (PDF, 109779336).

The reference architecture looks like the following flow:

Key implementation parameters from the Siemens reference (function block SQL_Connect / SQL_Insert):

Troubleshooting Matrix

Best Practices and Field-Proven Caveats

• Do not run the WinCC Professional DVD setup on a WinCC Advanced engineering station to obtain SSMS. The setup is a product installer, not a feature installer, and will modify the TIA Portal configuration. Use the Microsoft SQL Server 2008 R2 media or a current SSMS download instead.
• Capture the engineering station baseline with TIA Portal → Help → About → Installed software before any new install. This makes it possible to roll back an incorrect product variant.
• Match the architecture: the TIA Portal V13 SP1 setup installs a SQL Server 2008 R2 engine. SSMS 2008 R2, 2012, 2014, 2016, or later is fully forward-compatible. Do not downgrade SQL Server to 2005 or earlier.
• Service account: when logging PLC data to SQL Server from a service running on the engineering station, configure the service to use a Windows account that is a member of the local SQLServerMSSQLUser$ComputerName$SQLEXPRESS group or has the db_datawriter and db_datareader roles on the target database.
• Firewall: open TCP port 1433 for the local instance if the PLC is communicating with a remote SQL Server on a different machine.
• Lifecycle: SQL Server 2008 R2 reached end of extended support in July 2019. For new deployments, plan a migration to SQL Server 2019 or later, which can still be administered by SSMS 2016+ from a Windows 7 SP1 host (read-only access) or by SSMS 19+ from a Windows 10 / 11 host.
• Documentation: always cross-check the configuration against the latest version of the Siemens application example — 109779336_SQL_DOC_en_V30.pdf — because function block signatures and example DB schemas have been revised between V2.x and V3.0 of that document.

FAQ