CODEWITHSUNDEEP
azure-sql-database
Diomedes Domínguez
Diomedes Domínguez

Reputation: 1101

How many users can I create on a SQL Azure Server?

I was looking at https://azure.microsoft.com/en-us/documentation/articles/sql-database-manage-logins/ searching for some documentation about limits and/or restrictions of the amount of the users I can create on SQL Azure Server, but I didn't get anyone.

Upvotes: 0

Views: 746

Answers (2)

SQLmojoe
SQLmojoe

Reputation: 2043

There's no specific limit on number of users. A SQL database can handle 2^31 objects which includes tables, views, sprocs, etc... and users so you can create LOTS of users (doesn't mean you should).

The article you referenced points out the maximum concurrent logins of 30. That means only 30 unique logins are permitted at any time. For most environments, this translates to 30 concurrent users. That means you can create 1000 user accounts in your database but only 30 can actively access the database at any given time.

Upvotes: 1

guyhay_MSFT
guyhay_MSFT

Reputation: 621

I'd be happy to help. Can you please be a little more specific about what limits you think you might hit? There are no limits on users for security in SQL DB.

Guy

Upvotes: 0

Related Questions