This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 30%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
I am getting errors installing FEMA's HAZUS Pro software which uses ESRI ArcGIS Pro as it's map engine. The failure is because the ArcGIS program will not connect to the SQL database. ESRI support says I have to configure SQL server to accept remote access. I have no idea how to do this. I am an independent contractor, not in an office setting, not on a server, and have no tech support.
I have purchased an Azure subscription, but cannot get a support ticket because my problem is not with Azure - I'm not using Azure or the cloud. How do I get a support ticket started?
Core component of SQL Server for storing, processing, and securing data
Hello,
Welcome to the Microsoft Azure Community.
Good evening. Thank you for contacting us and providing details about your scenario. Could you please provide the full error message? If possible, please share a screenshot.
Looking forward to hearing from you...
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
You need physical or Remote Desktop access to the server hosting the SqlServer instance. you also need an account with administrator privileges. Once you login to the server with administrator rights, you can run the SQLServer management console and perform the suggested steps.
You may also need to configure firewall access.
Thank you so much for the help! Now I'm having trouble now installing SQL Server, so I'm going to try to get Azure to help with this issue and checking my registry for left-behind instances of SQL Server.
One would think that the ESRI support would be able to tell you...
Anyway, what "configure SQL server to accept remote access" usually means is this:
In the SQL Server program group find the SQL Server Configuration Manager. When you have started it, select the node "SQL Server Network Configuration". You may see something like this:
If you see TCP/IP as Disabled, as I have highlighted it, right-click TCP/IP and select Enable from the context menu.
When you have done this, you need to restart SQL Server for the change to take effect. Select the node SQL Server Services. You will see something like this:
Right-click the highlighted node and select Restart from the context menu. Note that the name in parenthesis may be different from MSSQLSERVER.
Whether this will resolve your actual problem, I don't know, because the diagnostics from the ESRI support may not be accurate. If this does not work out, please share any error message you get.