Knowledgebase: ASP .NET / ASP
|
What connection string should I be using for my DNN (DotNetNuke) Installation?
Posted by Arvand Sabetian (Import) on 11 November 2009 04:14 AM
|
|
|
Inside your web.config, please make sure your connection string looks similar to this: <add name="SiteSqlServer" connectionString="Data Source={local}; Initial Catalog=DB_NAME; User ID=DB_USERNAME; Password=DB_PASSWORD;" providerName="System.Data.SqlClient" /> or <add name="SiteSqlServer" connectionString="Data Source=localhost; Initial Catalog=DB_NAME; User ID=DB_USERNAME; Password=DB_PASSWORD;" providerName="System.Data.SqlClient" /> Of course DB_NAME, DB_USERNAME and DB_PASSWORD would have to match the username and database you've created through the control panel. | |
 (96 vote(s)) Helpful Not helpful |
Comments (2)
Nduka Akpe
21 March 2012 09:08 AM
WHat about the object qualifier? Whats that?
Michael Carr
26 March 2012 06:00 PM
The Object Qualifier is a setting within the DataProvider section of the web.config for DotNetNuke that sets an optional qualifier which is prefixed to any and all SQL Server objects that are created in the DotNetNuke and module install. This is supported by including "" at the beginning of the creation of all scripts that are executed while extensions are installed.