Azure SQL is it possible?
# help-with-umbracoc
CliffAgius
10/05/2023, 1:31 PMHi,
Is there a way to use Umbraco running in a Web App service in Azure to connect to Azure SQL? I know it shows it in the install panel but I have obviously failed to set-up Azure SQL correctly as all I ever get is "Could not connect to database"
Any help appreciated.
Cliff.
a
Ambert
10/05/2023, 1:43 PMDo you mean a SQL server (Database) on Azure ? If so, thats definitly possible
Ambert
10/05/2023, 1:45 PMWhen you navigate to your database, you can get your servername to use in your connectionstring: for example:
mywebsite-db.database.windows.netAmbert
10/05/2023, 1:47 PMPerhaps you have some security settings that prevent access ?
s
Sebastiaan
10/05/2023, 2:28 PMYeah make sure to test from your local SQL management to connect to the same thing, I bet you need to allow your IP address to connect to the server, which can be done through sql mgmt or through the azure portal.
c
CliffAgius
10/05/2023, 4:03 PMLooks like I can connect from SSMS from local and build locally and install from local that affects the Azure SQL instance. However the Web App install on Azure can't seem to reach the Azure SQL instance so I now know after a few hours of investigation is that the issue is Azure related to connection between the two and not Umbraco.
m
Mike Chambers
10/05/2023, 7:12 PMjust a thought.. do you have this setting for your db server?
https://cdn.discordapp.com/attachments/1159483072987811920/1159568838854193222/image.png?ex=65317fa2&is=651f0aa2&hm=5f3b5d9ba5f23d7ec912bd58129d041d62dc8f015b70090fb7c90df7b193a326&
Mike Chambers
10/05/2023, 7:13 PMAlso just incase.. you don't have any connection string overrides in the azure portal app_service configuration?
Mike Chambers
10/05/2023, 7:16 PMMaybe like..
Copy code
{
"name": "umbracoDbDSN",
"value": "Server=tcp:{DBSERVER}.database.windows.net,1433;Initial Catalog={DBNAME};Persist Security Info=False;User ID={USER};Password={XXX};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=900;",
"type": "SQLAzure",
"slotSetting": false
},Mike Chambers
10/05/2023, 7:19 PMand that connection string can be copied from the database overview screen... the ado.net sql string.. (minus the pwd)
https://cdn.discordapp.com/attachments/1159483072987811920/1159570618317017238/image.png?ex=6531814b&is=651f0c4b&hm=3b09e395818bb205893eaf785173eccd9a3b1b4bb7f0d7cdbe75d35ba91b7e9d&
Mike Chambers
10/05/2023, 7:20 PMHopefully not telling you how to suck eggs 🙂
7 Views