Configuring your SQL Server Account as a Data Source

In this article

Overview

You can configure a new SQL Server account in Fast Data Loader (FDL) by using the user credentials from your existing account in SQL Server.

Prerequisites

Supported Versions

SnapLogic supports SQL Server 2008 to 2016. The Fast Data Loader was tested against SQL Server 11.00.2100.

Account Settings

Parameter Name

Data Type

Description

Example 

Parameter Name

Data Type

Description

Example 

Create new connection tag

String

Required. Enter a name that will help identify your SQL Server account in FDL.

FDL_SQL Account

Hostname

String

Required. Enter the target server address.

54.98.196.248

Port Number

String

Required. Enter the database server's port to connect to.

1433

Database name

String

Required. Enter the database name to connect to.

ReportServer

Username

String

Enter a valid username that is allowed to connect to the database. This username is used as the default for retrieving connections.

WIN-USERS\fdl

Password

String

Enter a valid password to connect to the database. Password is used as the default password for retrieving connections.

S0F^q7&M

Troubleshooting

You might encounter the following errors when you validate and save your integration:

Error

Reason

Resolution

Error

Reason

Resolution

Asset conflict error.

You cannot have another account in FDL with the same name. If you enter the existing account name, the Asset conflict error message is displayed.

Ensure that account name is unique. You can click Overwrite to overwrite the existing configuration with the new one, or click Cancel and enter a unique name for your account.

Failed to validate account.

You might have entered invalid username and password.

Multiple attempts with invalid credentials may lock your account.

Ensure that you enter valid SQL Server account credentials.

Contact FDL customer support at fdl-support@snaplogic.com for further assistance.

What to do next: Select destination endpoint from the following:

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2037121200

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2037121213

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2036367733


See Also

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1942159838

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486040

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2004029460

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486058