Knowledge Base

Setting up a SQL Server Connection

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com
Working with SQL Server

Setting up a SQL Server Connection

  1. From the main Navigation Menu, select Connections.
  2. On the Connections page, click on the Create Connection button.
  3. On the New Connection Page, select Microsoft SQL Server.
  4. Enter a Description for this connection.
  5. Enter the Server Address to the SQL server. This SQL server will need to have its port opened to be accessible by SmartConnect.
  6. Enter a Username and Password that has access to the objects you need to connect to.
  7. Select the Database to connect to.
  8. Scripting Alias – Need to add info
  9. Click Validate to test connection.
  10. Click Save.
Support

Email an Expert

Start a Ticket
Support

Chat with Us

Support

Submit a Ticket

Support

Call Us

Product
Connections
  • Microsoft Dynamics 365
Templates
Engage
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2021 SmartConnect|eOneSolutions
Privacy PolicyTerms of ServiceEULA

How can we help?

clear