CODEWITHSUNDEEP
azureazure-sql-database
ScottE
ScottE

Reputation: 21630

Azure Sql Database - how do you determine the app service name from the database logs?

We're having some issues with Azure Sql Databases, and their host name from sp_who reports back something like 'RD000xxxxxxx' for the hostname.

How can you determine the app service that is connecting to the database from this hostname?

Upvotes: 2

Views: 732

Answers (2)

ScottE
ScottE

Reputation: 21630

I've found it, but not through the management api or the portals.

https://[your-app-name].scm.azurewebsites.net/Env

It's under Machine Name.

Upvotes: 1

Alex Belotserkovskiy
Alex Belotserkovskiy

Reputation: 4062

RD000* is the VM hostname if not set explicitly. If you have the access to your deployments, you may be able to check it using APIs (or in case of VM RDP for example). If you suspect that it is not from your deployment, then, i strongly suspect, there is no way to detect who is it (perhaps, technical support may, but i doubt). With some possibility, it will change as well.

Upvotes: 1

Related Questions