469,313 Members | 2,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

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 2903
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
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.