Microsoft SQL Server

Introduction
​Microsoft SQL Server is a relational database management system developed by Microsoft. The primary function of Microsoft SQL Server is storing and retrieving data as requested by other software applications.
Supported actions
For your Microsoft SQL Server account, YAP ensures the following actions:
Create row
Update row
Find row
Delete row
Count row
Run custom SQL action
Setup requirements
Before setup, please check that you have granted to YAP the permission to send notification to your Microsoft SQL Server account. For this, sign in to Microsoft SQL Server and authorize the permissions requested by YAP.
Connection 
The Microsoft SQL Server connector allows querying in an external Microsoft SQL Server database.
Field
Type
Description
Host
Required
The IP address or hostname (db.example.com) of where your database instance resides. Note, localhost and 127.0.0.1 are not valid!
Port
Required 
Enter into this field "1433"
Database
Required 
The name of the database you would like to interact with.
Username
Required 
We recommend creating a new database user with extremely limited access. Try both a plain username and a fully qualified Windows username with domain name like example.org//username.
Password
Optional
Again, this should not be your production password. Make it strong! (We like using random.org.)
Schema
Optional
The schema that the selected database resides in.
For more information, please take a look at Microsoft SQL Server documentation.
Questions?
We're always happy to help with any issues you might have! 
Send us an email to [email protected] or request the demo with our sales team.

Last modified 3yr ago

Field	Type	Description
Host	Required	The IP address or hostname (db.example.com) of where your database instance resides. Note, `localhost` and `127.0.0.1` are not valid!
Port	Required	Enter into this field "1433"
Database	Required	The name of the database you would like to interact with.
Username	Required	We recommend creating a new database user with extremely limited access. Try both a plain username and a fully qualified Windows username with domain name like `example.org//username`.
Password	Optional	Again, this should not be your production password. Make it strong! (We like using random.org.)
Schema	Optional	The schema that the selected database resides in.