Connect to SQL from a different Subnet

Hi all,
I have my SQL 2000 server at 192.168.1.10. All of the
desktops with in that subnet can access the SQL server. I
just installed a new desktop with ip address: 192.168.3.2
Is there anything that i need to set up in order for this
desktop to be able to detect and connect to my SQL
Server. A ping from 192.168.3.2 to 192.168.1.10 receive
100% sucessful reply. I can even connect to the folders
on the SQL server but not to the database.
When i try to connect through a sql client it give
something like this: SQL server does not exist or access
is denied
Please help
ThanksYou need to retrieve the actual OS error to troubleshoot this problem.
Reply with the OS error returned while connecting using an ODBC test DSN.
Or test using ISQL.exe from a command prompt.
Example:
ISQL -Stcp:ServerNameHere -Usqluseridhere -Ppasswordhere -Q"select
@.@.version"
or
ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
Search the kb for the OS error returned.
Example:
10060 == Connection Timeout
10061 == Connection Refused. The server is not listening on TCP. This
could be caused if we fail to bind to the port.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.