...
The Connect to MSSQL activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Authentication (combo box control) (type: string): the authentication method. For SQL Authentication, the Username and Password parameters are mandatory. For Windows authentication they are optional.
- Database (text box editor type) (type: string): the database name to connect to.
- Instance (text box editor type) (type: string): the instance name to connect to. If there is an SQL server with no instance, this field should be empty. Examples:
- localhost\sqlexpress - server with instance
- localhost - server with no instance
- Password (password editor type) (type: string): the password for the provided username. In case of Windows Authentication, if the user that connects to the database is the logged in one, the field can remain empty.
- Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encripted password from outside the task, for example Flowster Portal). In case of Windows Authentication, if the user that connects to the database is the logged in one, the field can remain empty.
- Server Name (text box editor type) (type: string): the name or IP of the SQL Server to connect to. If it is a local SQL server, localhost is also accepted as a value.
- Username (text box editor type) (type: string): the the username of the SQL Server Administrator.
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Connect to MSSQL activity:
...
- In case of Windows Authentication, if the user that connects to the database is the logged in one, the field can remain empty.
The Read Only Output variable are the possible output values that the activity will provide:
...