...
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.
- Impersonation Full Username (text box editor type) (type: string): the domain and username required if impersonation is used for the Windows authentication. If empty, default credentials are used. E.g. 'fmrp\demouser'
- Impersonation Password (password editor type) (type: string): the username password if impersonation is used for Windows Authentication. If left empty default credentials are used.
- Impersonation 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 workflow, 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.
- 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 workflow, 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.
- Port (text box editor type) (type: int32): the port number for the SQL Server.
- 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. In case of Windows Authentication, if the user that connects to the database is the logged in one, the field can remain empty.
...