SQL Server
Set up a SQL Server connection in the workspace for the database actions to use.
SQL Server
Connects a Microsoft SQL Server database to the workspace. The SQL Server database actions in your robots use this connection.
Fields
Connection string
Enter the full SQL Server connection string. It follows this shape:
Server=host,port;Database=database;User Id=user;Password=password;
Example:
Server=192.168.0.1,1433;Database=production;User Id=admin;Password=mypassword;
| Part | What it is |
|---|---|
Server | The server's IP address or name, followed by the port |
Database | The database's name |
User Id | The database user's name |
Password | That user's password |
tip
The connection string usually comes from the database administrator, or from SQL Server Management Studio (SSMS).
Using it in the Designer
For a robot to use this connection, add the SQL Server - Connection action to the flow. In the action's settings, pick the connection saved in the workspace. Later SQL Server actions (query, insert, update and the rest) use it automatically.