Concurrent transactions from the one SQL user 
Author Message
 Concurrent transactions from the one SQL user

I  have a VB application accessing a SQL server database.

The application performs security checking using a table of users in SQL,
encryption routiens etc..
Within VB all users are currently accessing the database as "sa" user via
the ADO connection string.

Although to date this has not caused any problems, I am wondering if I am
brewing up problems for later when the database and user base expands.

I would prefer to keep it as it is, as I do not want to maintain two sets of
user information (ie SQL user and application user)

Are there any limits to the number of concurrent transactions from the one
SQL user?
or
Are there any reasons other than security to maintain SQL users, as I have
very secure site and user base?

Thanks in advance
Brian



Sat, 28 Feb 2004 19:41:11 GMT
 Concurrent transactions from the one SQL user

Brian,

You certainly don't want to use sa as the login for anyone other than the
real sa.  There isn't any restrictions that I know of on how many of the
same users can be logged in at a time but it sounds like you should look at
application roles. You can find more info in BOL.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive

I proudly support the PASS SQL Server user community and its upcoming user
event,
 PASS 2001 North America. For details, visit <http://www.sqlpass.org>
www.sqlpass.org.)


Quote:
> I  have a VB application accessing a SQL server database.

> The application performs security checking using a table of users in SQL,
> encryption routiens etc..
> Within VB all users are currently accessing the database as "sa" user via
> the ADO connection string.

> Although to date this has not caused any problems, I am wondering if I am
> brewing up problems for later when the database and user base expands.

> I would prefer to keep it as it is, as I do not want to maintain two sets
of
> user information (ie SQL user and application user)

> Are there any limits to the number of concurrent transactions from the one
> SQL user?
> or
> Are there any reasons other than security to maintain SQL users, as I have
> very secure site and user base?

> Thanks in advance
> Brian



Sat, 28 Feb 2004 20:04:20 GMT
 Concurrent transactions from the one SQL user
As you'll probably hear lots of, never use SA for anything but admin
activities.

--
Ross Nornes
DBA Services Manager
James Tower
http://www.JamesTower.Com


Quote:
> I  have a VB application accessing a SQL server database.

> The application performs security checking using a table of users in SQL,
> encryption routiens etc..
> Within VB all users are currently accessing the database as "sa" user via
> the ADO connection string.

> Although to date this has not caused any problems, I am wondering if I am
> brewing up problems for later when the database and user base expands.

> I would prefer to keep it as it is, as I do not want to maintain two sets
of
> user information (ie SQL user and application user)

> Are there any limits to the number of concurrent transactions from the one
> SQL user?
> or
> Are there any reasons other than security to maintain SQL users, as I have
> very secure site and user base?

> Thanks in advance
> Brian



Sat, 28 Feb 2004 21:08:46 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Count of concurrent users, max concurrent users, more...

2. Connection To Server :Error : More than one concurrent User

3. SQL 7.0 leaves an open transaction, blocking all users except the one

4. SQL 7.0 leaves an open transaction, blocking all users except the one

5. Concurrent User connection to SQL 7 or SQL 2K

6. SQL Server concurrent transactions

7. VB6, ADO Datacontrol, and multiple concurrent users: making a friendly user interface

8. VB6, ADO Datacontrol, and multiple concurrent users: making a friendly user interface

9. pdox 3.5 forms app was single user, now want to run concurrent users

10. Concurrent user in SQL Server 2000

11. Concurrent Users in SQL SERVER 2000

12. MS-SQL Server able to manage 500 gigabytes with 400 concurrent users


 
Powered by phpBB® Forum Software