Skip to main content

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: String

  • InitialCatalog: Specifies the name of the database to connect to
    Type: String

  • UserId: Specifies the user identifier used for database authentication
    Type: String

  • Password: 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.