Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

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

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

jassie
Constraint Violating Yak Guru

332 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:

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

3873 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  
 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.03 seconds. Powered By: Snitz Forums 2000