我如何访问web mssql [英] How can I access web mssql

问题描述

如何访问web mssql到windows表单应用程序



我尝试过：



没有什么可以尝试bcs我不知道这种情况

How can i access the web mssql to the windows form application

What I have tried:

Nothing try bcs i dont any idea for this situation

推荐答案

取决于。

从理论上讲，你只需更改连接字符串以匹配远程SQL Server设置，就可以像访问本地网络一样访问它。例如：

Depends.
In theory, you can just access it as if it were on your local network by just changing the connection string to match the remote SQL Server setup. For example:

private static readonly string strConnect = @"Data Source=SqlInstancename.HostWebsite.com;Initial Catalog=MyDatabaseName;Persist Security Info=True;User ID=MyLoginToSqlName;Password=MyPassword";

但是......只有在远程SQL实例配置为接受远程连接时才会起作用，而且大多数都不是出于安全原因。


因此，请检查运行远程SQL安装的任何人，并询问他们 - 他们将能够告诉您它是否配置为以这种方式工作的实例，以及您需要使用的登录详细信息。

But...that will only work if the remote SQL instance has been configured to accept remote connections, and most aren't for security reasons.

So check with whoever runs the remote SQL installation, and ask them - they will be able to tell you if the instance it's configured to work that way, and what login details you need to use.

这篇关于我如何访问web mssql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！