Good afternoon, I created a desktop application on C # using Visual Studio, I also created a database there, I registered connectionString to the base, everything works in the studio, it is added, deleted, etc.

I tried to install the Windows 7 x64 virtual machine, I moved the application there, I go to bin / Debug / Myproject.exe, it runs, it works. But when I press the show table button, I get an error:

provider: sql network interfaces, error: 26 - error locating server/instance specified

Although in the App.config file I changed the connectionString

    1 answer 1

    1. Make sure the server name is correct.
    2. In the connection string, try both options: Server \ Instance and Server \\ Instance.
    3. Make sure the server and DNS is available (ping).
    4. Make sure the SQL Server Browser service is running on the server.
    5. If a firewall is running on the server, make sure that sqlbrowser.exe and UDP port 1434 are added to the exceptions.
    • I think that you have a problem with the 4th item. - Kryshtop