MssqlSetConnection
This activity establishes a connection to a Microsoft SQL Server database using the provided server and authentication details.
Core Functions
- Accepts database server and authentication information
- Creates a connection string using the provided parameters
- Establishes a connection to the MSSQL database
- Prepares the connection for subsequent database operations
Inputs
DatabaseServerName: Specifies the name or address of the database server
Type: StringInitialCatalog: Specifies the name of the database to connect to
Type: StringUserId: Specifies the user identifier used for database authentication
Type: StringPassword: Specifies the password associated with the provided user identifier
Type: String
Outputs
- None
Short Technical Summary
A database connection activity that creates and establishes a connection to a Microsoft SQL Server instance using the provided server name, database name, and user authentication credentials.