We allow up to 100 simultaneous connections per MS SQL user.
MS SQL Server limits you to 1024 columns per table. The number of tables and of rows per table is only limited to 200 MB.
Additionally, each MS SQL database transaction log is limited to 100MB in size.