Connecting to SQL Server
All of the tasks in the SQL Server connector require a connection to a SQL Server database, so you will need to create a connection with the type 'MS SQL Server'. See Managing Connections for instructions on creating a new connection. You will see a screen like the one below, requesting your SQL Server details:
Enter your SQL Server details as described below, then click 'Finish' to create the connection.
Enter any additional parts of the connection string here. Alternatively, you can enter a full connection string here and leave the other fields blank (e.g.
server=CYAN\MSSQL2012;Database=TestCompany;User Id=sa;Password=p4ssw0rd). See connectionstrings.com for more information about connection strings.
Enter the name of the database to connect to.
Enter the name of the SQL server instance to connect to (e.g. PC-NAME\SQL-SERVER-INSTANCE). This is equivalent to the 'Server' parameter in the connection string.
Enter the password you use to connect to SQL Server.
Enter the username you use to connect to SQL Server.This is equivalent to the 'User Id' parameter in the connection string.