Good evening guys, I have a problem here. I'm trying to upload an MVC + SQL Web application in Azure. Deploy works fine, Application is in the air. However, any connection to the bank fails. At the time of deploy, VS provides the option to create a SQL database. in Azure this is created a SQL database, the bases and a server, but I can not connect at all.
According to the error, I'm trying to connect to this ConnectionString:
thebookCN: Server = tcp: myserver.database.windows.net, 1433; Initial Catalog = TheBookV2_db; Persist Security Info = False; User ID = myuser @ myserver; Password = mypass; MultipleActiveResultSets = False; Encrypt = True; TrustServerCertificate = False; Connection Timeout = 30
I thought it was a firewall rule, but I did not find any option to add the web server in the rule to the sql server.
I do not know if I'm forgetting any steps, it's the first time I'm uploading an application myself.
Could anyone help? Has anyone done this yet?