CreateMsSQLConnectionString

Alias:CreateMsSQLConnectionString

Output:Entity

Creates an MSSQL connection string

Parameter	Type	Required	Position	Default Value	Summary
Server	string	✔	1		The server address (and port)
Database Db	string	✔	2		The database to run the query against
UserName	string		3	Use integrated security if not set.	The username for database access.
Password	string		4	Use integrated security if not set.	The password for database access.
AttachDbFilename ExtendedProperties InitialFileName	string			None	The 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.
Authentication	string			None	The 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.
Encrypt	bool			False	When 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	bool			True if Username and Password are not set	When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
TrustServerCertificate	bool			False	When 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.