Solved Entra ID Or Azure To Manage Logged In Users/ Licensing

[GPGeorge]

I give up. Best of luck in the venture.

 

[dalski]

I give up. Best of luck in the venture.

Uh-oh, don't do that . Firstly I apologize to you & to others if I've offended. All of you are saying the same thing so thank you. The db will have info in there so I'll have to deploy via SQL Command Prompt or something like that. I'll worry about that later as I need to ascertain the architecture first as this seems to be quite difficult. To help others in the future see below links.


Helpful Links

Authentication

• Authentication Mechanisms Access & SQL Server Apps - (codekabinett)

• A Basic Guide To SQL Server Security - (Netwrix)

• Authentication Methods, Logins, & Db Users - (Greg Larsen)

• SQL Server Security Best Practices – (TrustedTech)

Web API's

• Web API Authentication - Youtube (Harshalkumar Jain)

• Implementing a Secure On-Premises API with Data API Builder, Keycloak, and SQL Server - (Alessio Tugnoli)

• Create ASP.NET Core Web API CRUD methods (& test in Postman) - Youtube (Round The Code)

• Simplest Way Secure ASP.NET Core Web API - Youtube (Round The Code)

• Using Web API's In Access - Youtube (DAAUG)

• GitHub link VBA-Web for handling API's in Ms Access

• Choose Between Minimal API/ Controller-Based API - (MSN)

• New Minimal APIs Course - Youtube (Round The Code)

Connect SQL Server To Internet

• How to Access SQL Server Database Remotely via LAN & Internet - Youtube (CS_Software)

• VB.NET How To Connect SQL Server Over Internet - Youtube (Coding With Andrew)

• Setting Up Kerberos Authentication for SQL Server: A Complete Guide from Scratch - Youtube (MS SQL DBA Tech Support)