Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-02-11 : 13:00:26
|
I am trying to determine what is the best login for an application that is connecting to a sql server 2008 r2 database.A account has been setup for sql server login that looks like the following statement:<connectionStrings> <add name="eRPTSampleConnectionString" connectionString="Data Source=TEST;Initial Catalog=DEV;User Id=TESTUSER;Password=xxxx" providerName="System.Data.SqlClient" /> </connectionStrings>I am wondering if I need to set any of the other properties like:1.Integrated Security,2. trusted_Connection3. Max Pool Size4. Min Pool SizeI am asking this question due to resources still being open when the application finishes executing.let me know what you recommend. |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-11 : 13:13:19
|
Since you are using SQL authentication, Integrated Security/Trusted connection does not apply. If you were to use Windows authentication, you would then not provide the username and password - instead you would specify Integrated Security or Trusted Connection (which are the same).There is really no need to change the Max and Min Pool size unless you have a compelling reason and you know why and what you are doing. I have never tried to change those, so I don't have any experiences that I can draw upon from in that regard.A brief explanation of each of the connection string properties is here: http://www.connectionstrings.com/articles/show/all-sql-server-connection-string-keywords |
|
|
|
|
|