Stuart McLachlan
stuart at lexacorp.com.pg
Sun Jan 9 15:09:53 CST 2011
That is only the case if you are using Windows Authentication. If you are using SQL Server Authentication, it is up to you how many different useers you create. You can have multiple people connect using the same "username" at the same time. Are you talking about a web application here or your own application connecting to the SQL Server over the internet? In the case of a web application, You just create one user called "webaccess" or something like that. Your web application connects to SQL Server under that username, you don't need credentials for individual people accessing the website. For your own application, it's up to you how you want to handle tracking actually users and authenticating allowed actions you can create as many "users" as you need. -- Stuart On 9 Jan 2011 at 15:53, jwcolby wrote: > I am following along in the How-To I posted earlier, and when I get to > the section for creating users it says that every user we are about > to set up has to have a windows user. This can't possible be true > since millions of people out there on the internet use SQL Server > every day and nobody is creating a login for them. Besides I am > having to duplicate this inside of SQL Server? Setting up a windows > user / password and then setting up a SQL server user / password. > > How does this really work. > > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >