Web.Config Entry

Question

HI I am trying to deploy a web site from my friend in SharePoint 2010. How ever I am not sure under which node / child in web . config file I have to insert the below code? Could any one please help me with it?

<!--ABC Entries Start-->
    <add key="SiteUrl" value="http://sok:6000" />
    <add key="ABCConnectionString" value="User Id=sa; Password=123; Integrated Security =true; Data Source=(local); Initial Catalog = ABC; " />
    <add key="EmailID" value="1" />
    <add key="EmailName" value="195.12.10.61" />

Also I am not sure instead of sa SQL account, can I use Windows authentication? If yes wat all chnages I need to make in the above connection string ?

Answer 1

These look like custom application settings. You should add them to the appSettings element, or create it inside the configuration element if it is not.

You have to give permissions for an account in SQL server to use. Sharepoint can be configured to run under specific service accounts ( it is recommended) so give permission for the account to SQL and set the connection string.

Answer 2

SharePoint is no different than ASP.NET as far as web.config entries are concerned. SharePoint's web.config content are different from a typical ASP.NET application though. So if your application depends on those settings, they would go into appSettings section of the web.config, just like ASP.NET applications.

For storing custom application settings, I prefer to store them in SharePoint's content database though and I prefer to fascilitate custom application settings using Application Settings Manager that comes with Microsoft's Patterns and Practices for SharePoint. It's a reusable application framework for SharePoint. Check below:

http://msdn.microsoft.com/en-us/library/ff798488.aspx