TIA Portal: S7-1500 to an SQL Database - LMicrosoft_SQL v1.0 Example

Presentation:    • TIA Portal: Presentation, SQL Databas...  

The Tabular Data Stream protocol (TDS) gives you the ability to establish a direct connection with a Microsoft SQL server. Using TDS, you can log in to an SQL server database and transmit SQL instructions. In this way, it is possible to read data from the database or send them to the database for storage.

https://support.industry.siemens.com/...

NOTE: Don’t forget to check permissions of the user in SQL DB, Login from PLC can be blocked. This is the most common issue to date.

The application example may have changed in-between versions of this video, please review the manual for block versions. This was filmed with version 0.8; please reference the latest version 2.0 in the below weblink.

Uses software to create a completely virtualized twin for pre-testing, end goal is to show how TCP/IP communications can be simulated from a PC using Siemens TIA Portal v16. Communication is obtained with a Microsoft SQL server and the example shows moving three integer values. All steps are exactly the same as integrating with a physical S7-1500 and server.

Read the manual for redaction of some code for the integration into S7-1200.

S7-1200 is possible with the same function block, but not an option for PLCSIM Advanced; physical s7-1200 only.

0:00 Introduction
0:29 Launch and configure PLSIM Advanced V3.0 for TIA Portal v16
0:39 Configure a PLCSIM Virtual Eth Adapter that matches the PLC configuration in the project
1:14 PLCSIM Advanced is capable of TCP/IP-based protocols and mechanisms
1:27 PLCSIM Virtual Eth. The adapter is a mapped device in network properties
1:42 Download programming
2:24 Microsoft Server 2016 Standard for SQL Server
2:39 Configure VMnet connection to bridge with PLCSIM Network adapter
3:37 Install SSMS and SQL Configuration software
4:29 Configure SQL Server Management Studio
6:33 Restart the SQL server for changes to take effect
9:31 SQL Server Configuration Manager server version command
11:03 Restart the server for changes to take effect
11:30 Windows Logs Application Filter Current Logs, ID 26022
13:06 To make a new rule, select Port for the rule type and use 1433 for SQL
14:21 Toggle the SQL Command