本地网络中的SQL [英] SQL IN A LOCAL AREA NET WORK

问题描述

我正在开发将在本地网络上使用的应用程序，这是我的第一次，有人可以帮助我如何连接到服务器并设置安全级别...
谢谢

IM DEVELOPING AN APPLICATION THAT WILL BE USED ON A LOCAL AREA NETWORK, THIS IS MY FIRST TIME COULD ANYONE PLEASE HELP ME ON HOW TO CONNECT TO THE SERVER AND SET THE SECURITY LEVEL...
THANKS

推荐答案

对于连接字符串:

http://www.connectionstrings.com/sql-server-2008 [ http://msdn.microsoft.com/en-us/sqlserver/bb671432 [ ^ ]

对于个人用户，我通常为大多数帐户提供db_datareader，并在可能的情况下设置db_executor进行编写和使用存储过程.您还可以根据需要为帐户设置db_datawriter.

For connection strings:

http://www.connectionstrings.com/sql-server-2008[^]

For security:

http://msdn.microsoft.com/en-us/sqlserver/bb671432[^]

For the individual users, I usually provide db_datareader for most accounts, and set up db_executor when possible to write, and use stored procedures. You can also set up db_datawriter for an account where necessary.

这篇关于本地网络中的SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！