[dba-SQLServer] Single User Name for SQL Server Login?

Dan Waters dwaters at usinternet.com
Sat Dec 20 09:20:14 CST 2008


Thanks Arthur,

In fact, we are having login problems with some users, and the login failure
report identified specifically who was having a problem.  I need separate
users.

And 'minimal work on the DBA's part' helps me understand. ;-)

Dan
-----Original Message-----
Subject: Re: [dba-SQLServer] Single User Name for SQL Server Login?

In my experience, the most common application of this approach is in apps
that involve web UIs. Even then, I don't recommend it because it's
impossible to trace an anomoly to a specific user. But in terms of minimal
work on the DBA's part, it does make sense.

A.

On Fri, Dec 19, 2008 at 4:41 PM, Dan Waters <dwaters at usinternet.com> wrote:

> I was talking to a SQL DBA today at one of my customers.  She suggested
> that
> I use a single username and password for all of the client PC's (about
> 200).
> I'm going to ask her about why we should do this in more detail later.
I'm
> setting up this BE with Windows Authentication.
>
> She threw me for a loop - why do this?  Is this a standard practice in
some
> situation?  My app at this customer has an entire virtual server and the
> entire SQL instance is for just this app.
>
> Thanks!
> Dan




More information about the dba-SQLServer mailing list