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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We have an old 2008r2 server running SQL server express 10.50.4042.0 running an old human resources program that we only access once maybe twice/month.
I recently migrated this server (using azure migrate) to an Azure machine on a connected azure network.
I get an error, "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied", when starting the program. FYI, The program is installed and running off the same server.
The server was migrated with same name, DNS updated to new address. It appears that when the program was originally installed that the sql connection was configured via ip address as the program will work and run when the old server (name changed, same old ip) is turned on. I have gone through all the program files searching for a config file and have come up empty handed. I assume the connection string was coded into the program files at the time of installation. I cannot re-install the program as the installation is password protected and the company has since gone under.
I thought i'd try using NAT on our firewall to redirect traffic from the old IP to the new server. This actually works while using SSMS. I can connect via SSMS from my PC using both the old IP and the NEW IP and server name. I can even RDP into the new server using the old ip address. I can ping the old ip from the server itself and my pc and the new server answers. But I still get the same error using the program. it cannot connect. I tried messing around with aliases to no avail, but the fact that SSMS can connect but the program cannot has got me perplexed. All credentials were transferred to the new SQL server and mirror the old. TCP/IP enabled, port 1433, currently have both old an new ip's under IP1 and IP2.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](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(89.60000000000001, 18%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Hello MelvinJohansen,
I noticed you reported my answer that the issue was not resolved, and I want to make sure I answered your question completely and accurately. Since this is an open forum, let's see if another community member has a better solution to the issue.
Kind regards,
John DeV
Independent Advisor
Hello MelvinJohansen,
Good day! I'm John Dev a Windows user like you and I'll be happy to assist you today.
I want to apologize that this is just a consumer forum. Due to the scope of your question, I recommend posting your query on Microsoft Site Q&A which is a technical community platform where most of the members were IT professionals that would greatly help you with the issue. They have IT experts there that can assist you better especially about Windows Servers, Active Directory and Group Policy configurations, etc.
SQL Server - General
https://docs.microsoft.com/en-us/answers/topics...
Kind regards,
John DeV
Independent Advisor
