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(installed 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.actually 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.

Mar 18 '08 #1

debasisdas

Please find a related discussion here .

Mar 18 '08 #2

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.

Mar 18 '08 #3