CAL & MSSQL Security Question (by an ignorant)

Hi!

This is a very basic question.. don't make fun of me please!
I'm confused by all this logins, users, roles etc..

What I want to do it is to have an ASP.NET application that uses MSSQL as a
backend.
I'm using SQL Authentication and e.g. Each employee for Comapny A will have
a login e.g. Employee1, Employee2 with separate passwords for each employe
e.g. Pass1, Pass2 etc.. Makes Sense?

As far I understand, logins map to users so is it possible that Employee1
and Employee2 map to the same user called e.g. 'Employee'? Or how does it
work? Any dummy tutorial on this out there you can recommend?

And how do I know how many MSSQL CALs I need?
Two (for each employee login) or only one for the user 'Employee'?

Thanks very much for your efforts!

MartinMartin Feuersteiner (theintrepidfox@.hotmail.com) writes:
> What I want to do it is to have an ASP.NET application that uses MSSQL
> as a backend. I'm using SQL Authentication and e.g. Each employee for
> Comapny A will have a login e.g. Employee1, Employee2 with separate
> passwords for each employe e.g. Pass1, Pass2 etc.. Makes Sense?

Yes, but it's better to use Windows Authentication. Now, exactly how
you do that over ASP .Net, I don't know. But that means that the web
page would recognize who the user is logged into to Window as, and
then SQL Server would pick up those credentials.

> As far I understand, logins map to users so is it possible that Employee1
> and Employee2 map to the same user called e.g. 'Employee'?

No, all users must map to different logins. (But it can happen that
users map no login at all.)

> And how do I know how many MSSQL CALs I need?
> Two (for each employee login) or only one for the user 'Employee'?

Licensing questions always leaves me in a maze, so i decline to answer
that bit.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||> And how do I know how many MSSQL CALs I need?
> Two (for each employee login) or only one for the user 'Employee'?

Licensing is an entirely separate thing from security. CALs are required per
user (an actual person, not a user name) or per physical device. That's my
understanding but for the definitive answer contact Microsoft.

--
David Portas
SQL Server MVP
--