I have installed two instance of sql in win2k3 system. I can connected to both instance from query analyser from the sql server ( local system ) but i can connected only to the first instance ( default ) from a client machine through lan. when i try to connect to second instance from client machine i get this error
Unable to connect to server URANUS\TEST_INSTANCE_2:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.
Can any body pls guide me what has to be done to resolve this issue.