October 11, 2022 at 2:42 pm
Hi
i have a Azure VM that cannot connect to my onprem sql2016 server via SQL connection string i have tested the following from my Azure VM to my onprem SQL
RDP - Works
SQL MGMT Studio - Works
Ping - Works
October 11, 2022 at 2:52 pm
you don't state what is the application running on the VM that is trying to connect to the server - but assuming it uses standard connection strings and that you have validated them, the issue is then likely to be firewall between the VM and the on prem server, depending on the error the app gets. (which you should have supplied), or the user the app is running under does not have access to that sql server (this would be seen on the SQL Logs), or the SQL Instance has a login server script that prevents that VM from connecting.
October 11, 2022 at 3:15 pm
sorry its a web server that needs to connect. the server had the permissions required to connect to the SQL
Server Error in '/Apps' Application.
Could not connect to database. Please ensure that database is running, security is set appropriately, and that the configured connection string is accurate.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: Could not connect to database. Please ensure that database is running, security is set appropriately, and that the configured connection string is accurate.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
October 15, 2022 at 10:11 am
This was removed by the editor as SPAM
October 18, 2022 at 3:13 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply