Skip to main content
Version: v0.17.0

CreateMsSQLConnectionString

Alias:CreateMsSQLConnectionString

Output:Entity

Creates an MSSQL connection string

ParameterTypeRequiredPositionDefault ValueSummary
Serverstring✔1The server address (and port)
Database
Db
string✔2The database to run the query against
UserNamestring3Use integrated security if not set.The username for database access.
Passwordstring4Use integrated security if not set.The password for database access.
AttachDbFilename
ExtendedProperties
InitialFileName
stringNoneThe name of the primary database file, including the full path name of an attachable database. AttachDBFilename is only supported for primary data files with an .mdf extension.
AuthenticationstringNoneThe authentication method used for Connecting to SQL Database By Using Azure Active Directory Authentication. Valid values are: Active Directory Integrated, Active Directory Password, Sql Password.
EncryptboolFalseWhen true, SQL Server uses SSL encryption for all data sent between the client and server if the server has a certificate installed. Recognized values are true, false, yes, and no. For more information, see Connection String Syntax.
IntegratedSecurity
TrustedConnection
boolTrue if Username and Password are not setWhen false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
TrustServerCertificateboolFalseWhen set to true, SSL is used to encrypt the channel when bypassing walking the certificate chain to validate trust. If TrustServerCertificate is set to true and Encrypt is set to false, the channel is not encrypted.