❔ Azure daemon SQL database Authentication
I'm absolutely panicking.
Something turned on FMA for an account I used to do database things through a headless program I made, and I can't get it to work anymore.
The short explanation is that I have an Azure SQL server and also an Azure server which has a program on the VM that runs without user input on a schedule (I should probably be using devops, but I can't figure out how). This program contacts several third party APIs and accesses the Azure database. I used to do this with a simple username+password in a flat file that's used in a connectionstring to create a DbContext, mostly because lazy and no one else would be accessing the server anyway. But clearly that doesn't work anymore.
I have tried many a things with the connection string, changing the Authentication type with tenant ids and secrets, but everything bring back errors that I can't troubleshoot, and won't bother people here with, because it'd be an XY problem situation.
I've also attempted to use postman to get some kind of oauth2 key to use, but it requires a scope, and I can't even find what scope "access this specific database" would be called.
In short, it's a straw in a haystack situation where I simply don't know what to look for or what would even make sense at this point. I wouldn't even know where to go to gain this info, everything just refers to each other and uses nomenclature that's alien to me.
Any help and direction is appreciated. Please and thank you.
I'm also starting to wonder if there's an Azure specific discord server. Nevermind, that server seems to be semi-dead.
Something turned on FMA for an account I used to do database things through a headless program I made, and I can't get it to work anymore.
The short explanation is that I have an Azure SQL server and also an Azure server which has a program on the VM that runs without user input on a schedule (I should probably be using devops, but I can't figure out how). This program contacts several third party APIs and accesses the Azure database. I used to do this with a simple username+password in a flat file that's used in a connectionstring to create a DbContext, mostly because lazy and no one else would be accessing the server anyway. But clearly that doesn't work anymore.
I have tried many a things with the connection string, changing the Authentication type with tenant ids and secrets, but everything bring back errors that I can't troubleshoot, and won't bother people here with, because it'd be an XY problem situation.
I've also attempted to use postman to get some kind of oauth2 key to use, but it requires a scope, and I can't even find what scope "access this specific database" would be called.
In short, it's a straw in a haystack situation where I simply don't know what to look for or what would even make sense at this point. I wouldn't even know where to go to gain this info, everything just refers to each other and uses nomenclature that's alien to me.
Any help and direction is appreciated. Please and thank you.
