Re: .net sql server account database authentication question

> Id prefer to use a sql server
> account to maximize connection pooling

It's actually the opposite. Using SQL Server accounts would minimize the
ability to pool connections, as you need different connections for each
account involved.

> We've reached an agreement where I can use a
> single account as long as its a domain account, but Ive been unable to
> figure out how to do so (if its even possible).

It is certainly possible to use a domain account to run your application
with, using a connection with integrated security to your SQL Server
data store.

> Im thinking I either
> need to use integrated security but force sql server to use a single
> account

Sure, just run your application using that account and impersonate it
within your connection, using integrated security as mentioned.

> , or use a regular connection string, naming the domain account
> and password with Integrated Security=false.

This last approach is not feasable.

HTH

--
Efran Cobisi
http://www.cobisi.com

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com