问题描述
大家好！这是我的第一个问题，所以我希望我能做好一切。因为我渴望学习，请随时提供有关如何使用社区网站的反馈。
我即将完成运行不同数据库的应用程序，2客户端计算机中的本地计算机，以及我与Hostgator一起托管的第三个MS SQL数据库。
现在，为了使用SQL Management Studio左右，我需要将我当前使用的IP列入白名单，以便我可以访问。我的问题是，如果必须为需要访问MS SQL应用程序的所有计算机执行此操作，以便它们能够在实际部署应用程序时进行连接。
我被告知我不应该这样做，但我想100％肯定。那将是非常愚蠢的IMO。
提前谢谢
PS。我有一个连接成功的连接字符串，然后我在DataSet中使用它来处理Windows窗体应用程序中的那些。
连接字符串：
Provider = SQLNCLI11;数据源=有效IP;密码= paspas;用户ID = useradmin;初始目录= Database1
Hello everyone! This is my first question ever so I hope I do everything correctly. Please feel free to provide feedback on how to use the community website since I'm eager to learn.
I am about to complete an application that runs different databases, 2 locals within the client computer, and a 3rd one MS SQL Database that I have hosted with Hostgator.
Right now, in order to work with SQL Management Studio or so, I need to whitelist the IP that I am currently using so that I get access. My question is that if this must be done for all the computers that will need to access the MS SQL application in order for them to be able to connect when the application is actually deployed.
I was told that I shouldn't need to, but I want to be 100% sure. That would be pretty stupid IMO.
Thanks in advance
PS. I have a functioning Connection String with successful connections, which then I use in DataSets in order to work with those within the Windows Forms Application.
Connection String:
Provider=SQLNCLI11;Data Source= Valid IP;Password= paspas;User ID=useradmin;Initial Catalog=Database1
推荐答案
这篇关于通过C＃应用程序访问SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！