Program Licensing in a Citrix Environment

[George1111]

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

[HairyMonkeyMan]

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.

[dglienna]

SQL Express versions don't work with more than 3-5 users anyways. Its really just designed for a single user.

[George1111]

Dglienna
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 Manager
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 ?

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.

Please correct me if I have missed something


Found this:

http://www.manifold.net/doc/sql_serv...ss_edition.htm

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

[dglienna]

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.

[dee-u]

How can SQLServer Express2005 (or 2008) tell me how many people are logged on)

SP_WHO or SP_WHO2

[dee-u]

Oops. I was thinking of Access and MSDE, not SQL Express.

Access and MSDE can work in multi-user environment also.

[George1111]

Thanks Dee-U

SP_WHO or SP_WHO2

Can you give me an example instruction in VB6 using these values please ?

[dee-u]

How about this?

[George1111]

Thanks Dee-U

Sh...... !

[dee-u]

It worked?