I have created a database on azure sql. I have updated firewall so that my local machine and dev server can hit the database. I have tested on both machines using the credentials using sql enterprise manager all connects fine.
When I use the same server details and credentials in my web.config it cannot connect i get error
"A connection string is configured but Umbraco cannot connect to the database"
I have tried recreating the db also deleting readding the login and user still no joy
umbraco and azure sql
0
I have created a database on azure sql. I have updated firewall so that my local machine and dev server can hit the database. I have tested on both machines using the credentials using sql enterprise manager all connects fine.
When I use the same server details and credentials in my web.config it cannot connect i get error
"A connection string is configured but Umbraco cannot connect to the database"
I have tried recreating the db also deleting readding the login and user still no joy
Any ideas?
Out of the box but TLS versions? Is one of them enforcing TLS 1.2 for example and the other not responding over it etc.
Matt
how would i check this? btw the connection string looks like
xxx masking my real data
Looks like Azure should support tls 1.2 and umbraco uses that version by default since 7.14 and I think 8 does as well.
And both still support v 1.1 so that shouldnt be the cause unless the server configuration has removed it (requires registry edits)
Matt
Continues to scratch head
ok solved. I had in db name - it should have been _ changed that and it now works.
is working on a reply...