[dba-SQLServer] I'm getting nowhere

To be more explicit:

"SQL Server logins have to already exist before you can add them as a Database User."

Hopefully my earlier post has clarified the concept of "Server Login" for you.

-- 
Stuart

On 19 Feb 2011 at 20:14, jwcolby wrote:

>  > Server logins have to already exit before you can add them as a
>  user.
> 
> Are you talking about Windows users?  I specifically don't want to do
> that.  Imagine a web app where the world might come in and read a
> table.  It makes no sense to require a windows user before database
> access.
> 
> In my case I will have perhaps 40-80 people coming in to 3 or 4
> different databases.  A handful of these will be able to do "database
> maintenance", things like adding to list tables.  Most will only be
> able to run reports.  Some will add time sheet records.
> 
> I have no intention of adding 40-80 people that I do not know to my
> Windows users if I can avoid it.
> 
> Or are you talking about SQL Server Logins?
> 
> This is my problem, everyone starts discussing this in the middle. 
> Start with either "Go to this web page to learn this stuff" or "A
> server login is... and you add one by..."
> 
> If I don't know what you mean by "a server login" then knowing that
> one needs to exist first is... not useful.