SQL Server can be connected from local system but can not be connected from remote system in the network. The error code is 40 from Visual Studio and 1326 when I try to connect to SQL Server from Management Studio.
- Firewall isn't the problem
- TCP/IP connection is enabled from SQL Server
- There are 2 pc terminals that can connect to the SQL Server but the 3th one cannot and using the same connection strings so the connection string is right
It is SQL server 2000
any help will be appreciated thanks