访问安装在远程服务器上的SQL Server 2008(具有静态IP) [英] Access SQL Server 2008 installed on remote server(has static IP)

问题描述

如何访问安装在远程Windows Server 2008(具有静态IP)上的SQL Server2008.
数据源名称是什么(只能是IP或不是IP)?

我这样做的动机是从Windows应用程序选择/插入/更新数据库到具有静态IP的远程sql服务器.

从远程SQL Server获取结果集的方法是什么.


感谢您的反馈.

谢谢.

解决方案

您可以像往常一样使用常规sql连接进行工作，结果集将相同，唯一的事情就是与sql server具有有效的连接. /blockquote>

确保SQL Server允许远程连接.
IP地址或域名(如果域名解析为IP地址)将作为您的数据源.
如果没有与服务器的可信网络连接，则必须将SQL Server配置为允许使用用户名/密码进行SQL身份验证.

完成所有这些操作后，您可以使用常规的SQL Studio进行连接并不受限制地使用SQL Server.

How can I access SQL Server 2008 installed on remote windows server 2008(has static IP).
What would be datasource name(can it be only a IP or not)?

My motive behind this, is to select/Insert/update the database from windows apps to the remote sql server which has static IP.

What are the ways to get the resultset from remote SQL server.


Appreciate your feedback.

Thanking You.

解决方案

You can work as usual you do with regular sql connection, and resultset will be same , only thing is to have valid connection to sql server.

Make sure that the SQL server allows remote connection.
IP address or Domain name(if the domain name resolves into the IP address) will be your data-source.
If you do not have trusted network connection to the server your SQL server must be configured to allow SQL authentication using username/password.

When you have all this, you can use your regular SQL studio to get connected and work with the SQL server without limitations.

这篇关于访问安装在远程服务器上的SQL Server 2008(具有静态IP)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！