Hello, this is the case the database is located on the remote machine in the aisles of the network ... the aypishnik of that computer is pinged, so there is a connection with it. But when I go to the visual studio and add a new data source, I enter the server username and password of the user database it does not find it Already tried and in the settings to open the TSPs IP protocol and port to open the firewall does not help
1 answer
SQL Server Browser running on the computer where the database is installed? Access is not only from your computer or from any other.
try to connect to the server via telnet telnet 1433 if there is no answer on this port, then you need to look at the firewall settings.
Check the name of the instance, it is possible that it is not default.
|