sql server数据库连接 [英] sql server database connection

问题描述

我在三个系统中安装了一个Windows应用程序。如何在其他系统中保留单个sql server数据库以及如何连接所有

i have installed a windows application in three systems. How can i keep a single sql server database in an other system and how i connect all

推荐答案

- 它们是否在同一网络上（不是由路由器分隔）？ br />
- 是否没有阻止连接的防火墙规则？

- 你有一台可以在需要的时候运行sql server的专用机器吗？

- 让我们假设全部连接意味着从所有客户端连接到同一个sql服务器。

- 假设你使用的是Microsoft SQL Server 2005或更高版本（以下链接假设2008）

如果满足这些要求：

1）服务器和数据库安装启用远程连接后： http://blogs.msdn.com/b/walzenbach/ archive / 2010/04/14 / how-to-enable-remote-connections-in-sql-server-2008.aspx [ ^ ]

2）在客户端设置正确的连接字符串： http://www.connectionstrings.com/sql-server-2008 [ ^ ]

3）你可能需要在服务器和数据库用户上设置登录，具体取决于您的身份验证方案。

- Are they on the same network (not separated by router)?
- Is there no firewall rule blocking the connection?
- Do you have a dedicated machine that can run the sql server all the time it could be needed?
- Let''s suppose "connect all" means connect from all clients to the same sql server.
- Let''s suppose you are using Microsoft SQL Server 2005 or above (the links below assume 2008)
If these requirements are satisfied:
1) After server and database installation enable remote connection: http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx[^]
2) Set proper connection strings on client side: http://www.connectionstrings.com/sql-server-2008[^]
3) You might need to set up logins on the server and database users, depending on what your authentication scenario is.

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