无法建立与Vb.net应用程序的连接:Sql Server错误40 [英] Connection from Vb.net application could not be established : Sql Server error 40
本文介绍了无法建立与Vb.net应用程序的连接:Sql Server错误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屋!
查看全文