By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

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

P: 2
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
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
Please find a related discussion here .
Mar 18 '08 #2

P: 2
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

Post your reply

Sign in to post your reply or Sign up for a free account.