WinCC Unified Installing SQL Server Express and first steps inserting data

preview_player
Показать описание
Video tutorial on how to install Microsoft SQL Server and SQL Server Management Studio (SSMS), create and configure a database, establish an ODBC connection and use a Wincc Unified project (TIA PORTAL) to manage interactions with the database:
1. Download and install SQL Server from its official website.
2. Download and Install SQL Server Management Studio from its official website to easily manage and interact with your SQL Server databases.
3. Use SQL Server Management Studio for SQL Server to create a new database file.
4. Add a new table within this database and define its columns and data types. Configure the necessary user roles or permissions.
5. Download and install the Microsoft SQL Server ODBC driver from the web site or other reliable source.
6. Configure the ODBC data source by linking it to your SQL Server database through the Windows ODBC Data Source Manager.
7. Obtain a sample Wincc Unified (TIA PORTAL) project that includes SQL database operations such as Insert, Update and Delete.

Download SQL Server:

Download code:
Рекомендации по теме
Комментарии
Автор

You save me, after two days try.
Thank’s a lot.

alirezamollai
Автор

very very good video my friend. finally, i found SIMPLE Unified - DB communication. thanks

keremterekeyfe
Автор

Hey ! Thanks for the video, much helpful, but I have an issue here, I’m not able to add more tags in the java script, if I add more tags. The sql server is not executing the code, can you help me in this ?

mukeshis
Автор

hi again mister. i used ur project on my laptop and i success connections and everything. however, i used it on another pc, i couldnt connect my db. i checked everything. HMI-->SQL Connecting.. after error so i cant connect SQL connection. do you have any idea for this problem. i am trying to solve this problem since 2 days. also db expert help me but we couldnt solve it. i am using tia portal v18 unified(both of 2 pc). thank you.

keremterekeyfe