I am not an experienced guy in SQL Server.
Please help me to solve my problem.
I can connect through Static connection to SQL Server without any problem. Eg, Enterprise Manager or Power Builder etc.
But when I connect through Query Analyzer or ODBC I getting the following error.
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver]Timeout expired
I increased the value for Login time out to 250. Same error.
When I connect using IP Address of the server it connects.
Some users are not able to connect through IP address, they can connect through Server name.
The other users are not able to connect through IP address or Server Name.