Microsoft SQL Server
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.
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
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.
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 | |
Schema | Optional | The schema that the selected database resides in. |
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