限制SQL访问 [英] Limiting SQL access

问题描述

有没有办法限制/限制能够访问给定SQL DB的并发用户数？

Is there a way to limit/restrict the number of concurrent users able to access a given SQL DB?

我们需要强制部门只能一次允许一定数量的用户访问前端是IIS网站的数据库。

We need to force a department to only have the ability to allow a certain number of users at a time to a DB where the front end is an IIS website.

网站是SQL DB的前端应用程序，并且正在监视部门的审计，因此我们只需要允许拥有SQL CAL的用户数访问该网站

The website is the front end app for a SQL DB and the department is being monitored for auditing, so we need to only allow the number of users that have SQL CAL's to access the website

来自Microsoft论坛的提醒

Alert from Microsoft Forum

推荐答案

我恐怕没有一个DB。您可以设置整个实例的并发用户数。如果您的实例中只有一个数据库，那么您可以使用：

I am afraid not to a single DB. You can set the number of concurrent users to the entire instance. If you have only one db in your instance so you can use:

USE AdventureWorks2012 ;  
GO  
EXEC sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE ;  
GO  
EXEC sp_configure 'user connections', 325 ;  
GO  
RECONFIGURE;  
GO  
  

或使用GUI：

如果这篇文章帮助你，请标记为答案

Please mark as answer if this post helped you

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