Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Installation error &qu...
Microsoft Dynamics NAV (Archived)

Installation error "The SQL Server instance '' exists, but a connection...."

(0) ShareShare
ReportReport
Posted on by Martinho Costa 775

Hello,

We are moving to azure our develpment structure. On NAV installation, in "specify parameters" step, I'm cleaning the "SQL Server Instance" field and when I click on "Apply" I get the following error: "The SQL Server instance '' exists, but a connection could not be established. Verify that SQL Server is running, that the TCP/IP protocol is enabled and, that a login exists for your Windows account."

I've tested the comunication between NAV machine and SQL machine and its up (installed SQL Management Studio on NAV machine and can load SQL server from SQL machine). The service user is administrator on NAV machine and also confirmed that TCP/IP protocol is active at SQL Configuration Manager.

Tried in NAV 2016 and NAV 2015.

Any idea? Thanks in advance

*This post is locked for comments

  • Qaisar Nisar Profile Picture
    Qaisar Nisar 8 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    hi,

      Do this thing

     .  Window key + R  

     .  Enter SQLServerManager15.msc

     .  In SQL Server Network Configuration Node go to Protocols for MSSQLSERVER

     . On right side set Enable for TCP/IP.

    That's would work for you too.

  • facade Profile Picture
    facade 5 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    The suggested answer - "enable Named Pipes for Sql via SCM" is still the correct answer in May 2020 even with Business Central 365 Wave 2 15.6

  • Suggested answer
    Anton Modaresi Profile Picture
    Anton Modaresi 100 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    I think you get this error because you have SQL server installed locally, while you're actually trying to connect to another SQL server.

    You need to run the SQL server component install on that machine, not the one where you install your other NAV software.

    If you did not have the SQL server installed locally, you would get a different error saying "SQL Server Instance '' could not be found"

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    the main changes, i think, were using a predefined setup mode instead of the custom, as i suggested, and enabling the "named pipes" protocol.

    quote: "For Microsoft Dynamics NAV to work correctly, the Named Pipes and TCP/IP protocols must be enabled for SQL Server."

    from msdn article "Troubleshooting: SQL Server Connection Problems":

    url: msdn.microsoft.com/.../dd983822(v=nav.80).aspx

  • Verified answer
    Martinho Costa Profile Picture
    Martinho Costa 775 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    Well, I did some changes... It works but I need to be honest I don't know why.

    Enabled "Named Pipes" on SQL Configuration Network. Instead of Custom Installation I did Developer. Have removed some features like "Install Demo Database" and some excel and outlook plugins.

    It's installing.

    Thanks a lot for your time Jonathan :)

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    means that error message comes directly from nav setup.

    best you run nav setup with demo profile and change the settings after successfully run with nav service management tool.

  • Martinho Costa Profile Picture
    Martinho Costa 775 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    Somehow I'm not receiving the error message in the event viewer (Windows Logs/Application). Got quite confused now. Is it because it comes from a setup process?

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    please check the windows event log. maybe there are more details in the error message.

  • Martinho Costa Profile Picture
    Martinho Costa 775 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    That's the first nav service instance on the machine. Also tried to change the ports just in case.

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Installation error "The SQL Server instance '' exists, but a connection...."

    is there a second nav service instance? if yes, check, if the service name and the ports are different.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans