如何从封闭端口1433获取SQL数据库中的数据 [英] How to get data from SQL database with closed port 1433

问题描述

通常我使用端口1433或1434连接数据库。在这种情况下，我不允许打开端口，但我可以在该服务器上安装Windows服务或其他类型的服务。请，我不太了解Web应用程序和服务之间的服务和通信。此外，sql server的ip地址不是静态的，而是每年更改一次或两次，我也必须从服务器上的文件夹中获取一些图像。

有人可以帮助我什么是最好的解决方案？

添加。他们说没有密码来改变路由器的设置。我写了windows服务，它访问数据库并获得外部IP地址并将其写入日志（用于测试目的）。我是否需要特定端口与此服务进行通信？ Web应用程序和服务之间最简单的通信方式是什么？我需要WCF服务还是其他什么？



谢谢，

Bobo

解决方案

与您的网络管理员讨论它。



要么他们打开端口，以便您的代码可以与SQL Server通信，或者他们必须给您一些选择。

Normally I use port 1433 or 1434 for connection to database. In this situation I am not allowed to open port but I am allowed to install windows services or other type of service on that server. Please, I don’t know a lot about services and communication between web application and services. Moreover, Ip address of sql server is not static but changes one or two time per year and I have to get some images from folder on the server as well.
Could somebody help me what is the best solution?
To add. They said that thay don't have password to change setting of router. I wrote windows service which accessed to database and got external Ip address and wrote it to log (for testing purpose). Do I need specific port for communication with this service? What is the easiest way of communication between web application and the service? Do I need WCF service or something else?

Thanks,
Bobo

解决方案

Talk to your network admins about it.

Either they open the ports so your code can talk to the SQL Server or they have to give you some options.

这篇关于如何从封闭端口1433获取SQL数据库中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！