Data receive from SQL to Siemens S7-1200

Mathias 1 Reputation point
2021-04-13T20:53:21.13+00:00

Hi
I am doing some data logging from a Siemens PLC.
I have got communications up and running, and can send data from the PLC to the Sql database.

My problem is that I can not be allowed to receive data from the Sql database. The Siemens manual says that using "Wireshark" and the TDS protocol I have to find the date that will be sent to the PLC, but I just can not find anything called TDS in "Wireshark".

Does anyone have an idea of ​​what the problem might be?

![87455-image.png]1

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,510 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 67,721 Reputation points Microsoft MVP
    2021-04-13T21:48:53.787+00:00

    I think you are better off asking in a forum devoted to Siemens PLC.

    TDS is the protocol that is used with communication with SQL Server, to and from. Trying to get data from SQL Server by looking at the wire from Wireshark is quite advanced. And time-consuming.

    I must say that the instruction above makes very little sense to me. I'm wondering if this is a subtle way to say "Don't do that!".

    No comments

  2. Cris Zhan-MSFT 6,561 Reputation points
    2021-04-15T03:32:19.24+00:00

    Hi @Mathias ,

    I also think you should post this question to the Siemens forum, or a forum that set topic/zone for Siemens PLC. The tag(sql-server-general) indicates that this is a forum focused on SQL Server technical issues.

    Please see if this similar case helps. (The forum may be suitable)
    https://stackoverflow.com/questions/62403650/connecting-an-plc-siemens-s7-1500-to-an-sql-server-database

    No comments