WINDOWS应用程序访问远程服务器 [英] WINDOWS APPLICATION ACESS REMOTE SERVER

问题描述

尊敬的先生，

我已申请备份和还原sql server数据库.
我想知道我是否要访问远程位置服务器并想对该数据库进行备份或还原，如何实现它.

请帮助我

Dear sir,

i have made application for backup and restore sql server database.
i wana know if i want to acess remote location server and want to take backup or restore of that database how to implement that.

Please help me out

推荐答案

我想知道我是否要访问远程位置服务器
根据您的第一句话，我已经提出了用于备份和还原sql server数据库的应用程序. ，您已经拥有一个可以在本地进行备份和还原的应用程序.如果是这样的话，那么远程服务器的代码应该没有任何区别.您的主要更改是权限配置，以便您用于备份/还原的应用程序和用户名/密码在远程服务器上具有访问权限.

设置安全特权后，您可以在远程服务器上尝试您的应用程序.确保远程数据库和服务器允许远程连接.防火墙也不应阻止来自外部的访问.

i wana know if i want to acess remote location server
Based on your first statement i have made application for backup and restore sql server database. , you already have an application in place that does a backup and restore locally. If so, then there should be no difference for remote server in code as such. Your major change is permission configuration such that your application and username/password being used for backup/restore has access privileges on the remote server.

Once security privileges are in place, you can try your application with remote server. Make sure, remote connections are allowed by the remote database and server. Firewall too should not be blocking access from outside.

这篇关于WINDOWS应用程序访问远程服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！