sql server连接字符串 [英] sql server connection strings

问题描述

我正在开发Windows数据库应用程序，当我尝试使用安装了服务器和数据库的开发计算机连接到sql server 2005数据库时，一切正常，但是当我在另一台计算机上安装应用程序时在与我的服务器相同的局域网上，该应用程序未连接到数据库或Sql服务器.请问我该怎么办?

提前谢谢.
您忠实的
Martin

hi there, am developing a windows database application, when i try to connect to my sql server 2005 database using my development computer where the server and database are installed, everything works out fine, but when i install my application on another computer on the same Local Area Network as my server, the application does not connect to the database, or Sql server. How can i go about this please?

Thanks in advance.
Yours faithfully
Martin

推荐答案

您是否在计算机上使用Windows身份验证，而另一台计算机上的用户未设置为访问SQL Server?

看看这个

Are you using Windows Authentication on your machine and the user on the other machine is not set up to access the SQL server?

Take a look at this

该网站将有助于获取有关连接字符串的所有信息
http://connectionstrings.com/

this web site will be useful to get all information about connection strings
http://connectionstrings.com/

您可能在connectionstring内使用了localhost连接，这就是它从您的变形PC连接的原因，
要在任何地方使用它，请使用IP address或ComputerName，而不是从任何地方进行连接，

如果有帮助，请 投票 和 接受答案 .

You may have used localhost inside connectionstring for connecting, That''s why it is connecting from your devlopement pc,
To use it from anywhere use IP address or ComputerName rather to be connected from anywhere,

Please vote and Accept Answer if it Helped.

这篇关于sql server连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！