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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 sql server connection string

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_Connection
3. Max Pool Size
4. Min Pool Size

I 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
Go to Top of Page
   

- Advertisement -