I have a problem with the SQLSERVER database.
I try to connect from a point to the server and the error appears:
Network-specific or instance-specific error when connecting to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections
Note 1: The database is "running" normally in place (server).
Note 2: After the test battery, the TCP / IP configuration is OK. (PORT 1433 OK)
Note 3: I can usually access also via IIS.
Note 4: I changed the database to another server and it worked normally.
Note 5: It was working until yesterday ....
Note 6: At 2 physical points the problem occurred.
Note 7: I pinged normally from physical points to the server (ok)
base:
Data Source=192.168.1.1;
Initial Catalog=banco;
User ID=sa;
pwd=senha;
MultipleActiveResultSets=True;
Connection Reset=True;
Connection Lifetime=600