无法建立与Vb.net应用程序的连接：Sql Server错误40 [英] Connection from Vb.net application could not be established : Sql Server error 40

问题描述

我在Windows Server 2003计算机上加载了Sql Server 2008，而我的客户端计算机是Windows 7.



当我使用SQL MANAGEMENT STUDIO从Windows 7连接时，它是连接。但当我通过我的应用程序连接时，它显示sql server错误40.



我的连接字符串是

I loaded Sql Server 2008 on a Windows Server 2003 machine and my client machine is Windows 7 .

When i connect from windows 7 using SQL MANAGEMENT STUDIO it is connection. but when i connect through my application is it showing sql server error 40.

my connection string is

Data Source=192.168.1.XXX,1433; Network Library=DBMSSOCN; Initial Catalog=myDB;
User ID=myUserName; Password=myPwd

但是当我通过windows xp机器连接它工作正常。



它是连接字符串的问题？请帮助



提前致谢

Biju

but when i connect through windows xp machine it is working fine.

it it the problem of connection string? Please help

Thanks in advance
Biju

推荐答案

修复它，阅读这些文章：

http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to- sql-server / [ ^ ]

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql- server-microsoft-sql-server-error / [ ^ ]

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/16/named-pipes -provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error-xxx.aspx [ ^ ]



类似已解决的问题：

错误：40 - 无法打开连接SQL Server [ ^ ]

连接到sql server错误40和53 [ ^ ]

To fix it, read these articles:
http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/[^]
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/[^]
http://blogs.msdn.com/b/sql_protocols/archive/2007/05/16/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error-xxx.aspx[^]

Similar solved questions:
error: 40 - Could not open a connection to SQL Server[^]
connection to sql server error 40 and 53[^]

这篇关于无法建立与Vb.net应用程序的连接：Sql Server错误40的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！