To connect to SQLServer 2005 database of a pc which is in domain from a pc in workgrp

[smithaanna]

Hi,
How can i connect to the sql server database(instal led microsoft visual 2005 professional edition in which sql server 2005 express edition)a pc which is XP Professional SP2 and is in a domain from a pc which has windows server 2003 SP2 which is in a workgroup.actua lly i want to connect through this datbase through sql native client but i get a test failed connection inspite of giving the IP Address and connecting through Administrator Password.

Getting the error when creating an ODBC
Connection failed:
SQL State:'08001'
SQL Server Error:10055
[Microsoft][SQL Native Client]TCP Provider:An operation on a socket could not be performed because
the system lacked sufficient buffer space or because a queue was full.
Connection failed:
SQL State:'HYT00'
SQL Server Error:0
[Microsoft][SQL Native Client]Login Timeout Expired
Connection failed:
SQL State:'08001'
SQL Server Error:10055
[Microsoft][SQL Native Client]An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005,this failure may be caused by the fact that under the default
settings SQL Server does not allow remote connections.

[debasisdas]

Please find a related discussion here .

[smithaanna]

Please find a related discussion here .

hi i have already disabled the VIA option in sql server network configuration for mssqlserver and sqlexpress at the start itself.the same for sql native client configuration for client protocols as well.