SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 sql server connection string
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

325 Posts

Posted - 02/11/2013 :  13:00:26  Show Profile  Reply with Quote
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:

<add name="eRPTSampleConnectionString"
connectionString="Data Source=TEST;Initial Catalog=DEV;User Id=TESTUSER;Password=xxxx"
providerName="System.Data.SqlClient" />

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
Flowing Fount of Yak Knowledge

3865 Posts

Posted - 02/11/2013 :  13:13:19  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000