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 | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    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!".

    1 person found this answer helpful.
    0 comments No comments

  2. Cris Zhan-MSFT 6,661 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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.