A SQL login is an instance-level security principal that authenticates to a SQL Server instance. An API can use its username and password in a connection string to access a database. section 4.2.4
Create the login in SQL Server’s main Security folder, not the Security folder beneath a database. Pair it with a database user to authorize access to a specific database. section 4.2.4
Configure access in two separate steps:
- Add a login for authentication into the local SQL Server instance. section 4.2.4
- Add a user inside the target database to authorize that login and control its database access. section 4.2.4
- Use matching names for the login and user when following the MyBGList setup, then link them. section 4.2.4
MyBGList API access
Create a MyBGList login through the Login—New dialog, supplying its login name, authentication type, and password. Create the corresponding MyBGList database user afterward so the API can use the credentials in its connection string. section 4.2.4
Use the SSMS figure to identify the instance-level dialog for adding the MyBGList login. section 4.2.4
