471,853 Members | 1,525 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

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

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
2 2975
debasisdas
8,127 Expert 4TB
Please find a related discussion here .
Mar 18 '08 #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.

Similar topics

reply views Thread by Neff | last post: by
9 posts views Thread by Peter Lux | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.