Printable View
I thought I had it all together with my security system which checks for Hard Disk Serial Numbers and hashes with company name to give a security code.
Along comes citrix with its ability to run the application from one machine by several users
Has anyone any comments on how I could secure the application to a set number of users
How does SQL Server handle the number of CALS ?
How can SQLServer Express2005 (or 2008) tell me how many people are logged on) ?
Thanks
As far as securing the number of users... your citrix client needs to logon using a domain account. You can setup which users have access to which programs. This is going to be the best way imo. Your application's user will be the domain user.
SQL Express versions don't work with more than 3-5 users anyways. Its really just designed for a single user.
I was considering using SQLServerExpress as a Logon ManagerQuote:
Dglienna
SQL Express versions don't work with more than 3-5 users anyways. Its really just designed for a single user
This way each time someone connects to my App I also log into SQLExpress
My data lives in an Access Database
The question is, "Can SQLEXpress report how many users are connected ?"
"If it can, how do I interogate this info?"
My other concern is your suggestion that SQLEXpress is not useful beyond 3-5 users
I understand the following about SQLServerEXpress
1) Database Size is max 4GB
2) Ram useable is 1GB
3) Only one processor can be used (even if there are 2 or more)
4) There is absolutely no "detuning" to make it run slower than its "big brother" (apart from above limitations)
Is this true ?
Please correct me if I have missed somethingQuote:
SQL Server Express does not include any of the advanced components of SQL Server including Analysis Services, Reporting Services, Data Transformation Services, and Notification Services.
Found this:
http://www.manifold.net/doc/sql_serv...ss_edition.htm
Quote:
When delivered in SQL Server Express form, Microsoft has limited SQL Server in several ways:
§ A database cannot exceed 4 gigabytes in size.
§ SQL Server Express may be installed on a multiple CPU machine, but it will execute (run) only on a single processor or a single processor core if multi-core processors are used.
§ SQL Server Express may be installed on a server with any amount of memory, but will use only up to 1 GB of available RAM memory.
Other than these limitations SQL Server Express provides virtually the full power and breadth of SQL Server capabilities. Although MSDE was limited to no more than five users, SQL Server Express no longer has such an artificial throttle on performance. Within the limits of processor, RAM and maximum database size, SQL Server Express always runs at full speed.
Thanks for the feedback
Oops. I was thinking of Access and MSDE, not SQL Express. That works with multiusers. Sorry about the confusion.
SQL Express doesn't come with any console at all, but you can download the SQL Management Console and access both the the full and express versions.
SP_WHO or SP_WHO2Quote:
Originally Posted by George1111
Access and MSDE can work in multi-user environment also.Quote:
Originally Posted by dglienna
Thanks Dee-U
Can you give me an example instruction in VB6 using these values please ?Quote:
SP_WHO or SP_WHO2
How about this?
Thanks Dee-U
Sh...... ! :eek:
It worked?