provider: SQL SERVER Interfaces, error: 26 - Error searching the specified server or instance

Navigation
1

I'm a bit new to this and I have a problem. I have created a system with the basic operations, add, modify, delete and search. This system is made in C # with the Visual Studio 2013 program, the database is created in SQL SERVER 2008. It is all finished and I have made its installer.

The problem is that when I install the system on another PC, it marks me an error and I do not know what it is.

The error says the following:

  

Error related to the network or specific instance while   established a connection with the SQL SERVER server. The   server or this one was not accessible. Check that the name of the   instance is correct and that SQL SERVER is configured to support   remote connections (provider: SQL SERVER Interfaces, error: 26 - Error   when searching for the specified server or instance).

Help is urgent.

Noce if I have to upload the database to a server and if so how to connect it to the project.

    
asked by Ryuzaki Lpz 27.04.2017 в 23:52
source

1 answer

1

to see Ryuzaki, before you continue hunting Kira, analyze the following:

  • SQL Server is on an X computer where the program has also been installed.
  • The program has been passed to your friend / acquaintance / contact and has been installed on a Y computer.
  • The configuration that is in the AppConfig that points to the instance that is on the X machine.
  • Considering that neither X nor Y shares the same network, it is impossible to have a connection to the SQL Server, therefore the error you have.

    • Solution or possible solutions

  • Install the SQL Server on the Y machine or on any computer on your network, keep in mind that the APP config connection must be by means of the IP or by name of the computer + the instance.
  • Connect both computers in a network.
    • answered by 28.04.2017 / 03:14
    source
    Send by POST I can not access a specific value of an item in java