Authorization
Connecting Microsoft SQL Server to Platform requires you to have:
- A Microsoft SQL Server user with read/write access to the database and all associated tables/views you wish to access. We recommend setting up an account specifically for Platform access, although you can use an existing user.
- Platform IP Addresses whitelisted
Creating a New Userβ
- Login to your Microsoft SQL Server
- Create a login either:
a. On the command line by runningCREATE LOGIN <login value> WITH PASSWORD = '<new password>';
b. In the Object Explorer following these instructions - Create a user either:
a. On the command line by runningCREATE USER <user name> FOR LOGIN '<login value>';
b. In the Object Explorer following these instructions - The server URL, the username, and password are all used in the Blueprints below