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.