且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在不安装Sql Server的情况下远程访问网络中的数据库?

更新时间:2022-11-04 13:34:41

有连接失败的几个可能原因。请看看这些:

- http://www.sswug。 org / articlesection / default.aspx?TargetID = 44331 [ ^ ]



- http://***.com/questions/18060667/cannot-connect-to-server-a-network-related-or-instance-specific-error [ ^ ]



- http: //support.microsoft.com/kb/287932 [ ^ ]
There are several possible reasons for the connection to fail. Please have a look at these:
- http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]

- http://***.com/questions/18060667/cannot-connect-to-server-a-network-related-or-instance-specific-error[^]

- http://support.microsoft.com/kb/287932[^]


根据您的问题,这意味着您需要从您的应用程序中使用来自其他网络pc的sql server。因为您应该更改 ConnectionString 并在SQL服务器上进行一些配置用于远程连接的Surface Area 。我已经实现了这个并从远程PC获取访问权限。



请点击链接:



http://searchsqlserver.techtarget.com/tip/Using-Surface-Area-Configuration- to-lock-down-SQL-Server [ ^ ]



http://www.scrumdesk.com/Articles/HowToEnableSQLServerRemoteConnections.html [ ^ ]
As per your question it means that you need to use sql server from another network pc from your application. For you should change ConnectionString and make some configuration on SQL server Surface Area for remote connection. Already I implement this and get access from remote pc.

Please follow the links:

http://searchsqlserver.techtarget.com/tip/Using-Surface-Area-Configuration-to-lock-down-SQL-Server[^]

http://www.scrumdesk.com/Articles/HowToEnableSQLServerRemoteConnections.html[^]