where to change the Database connection settings in Orchard MVC CMS

orchardcms
waqari picture waqari · Jan 24, 2011 · Viewed 18.7k times · Source

I set up a site in Orchard CMS. While choosing data storage settings I chose

Use an existing SQL Server(or SQL Express) database

Instead of

Use built-in data storage(SQL Server compact)

It has worked fine for me but I am wondering where to change the data source that is the database server name. I didn't find the connection string settings in web.config file.

Answer

Jan_V picture Jan_V · Jan 29, 2011

To change the database, you should edit the DataConnectionString entry in the App_Data\Sites\Default\settings.txt file.

It should look something like this:

Name: Default
DataProvider: SqlServer
DataConnectionString: Data Source=servername;Initial Catalog=dbname;User Id=username;Password=password;

You do need to restart the website after the change is made. If you can't reset the webserver yourself, edit in the web.config (add a space) or in the bin directory should suffice. .NET resets the website when something happens in this file or folder.

Related questions

DotNetNuke, Umbraco or Orchard

First off please have patience for this long winded post. I wanted to get all the pertinent information (as I see it) out to you. I have a decision to make and would like your input. I have recently taken …

Read More
Choosing a CMS: EPiServer vs Orchard vs SiteCore vs Umbraco

Increasingly, I have noticed the number of Content Management Systems in use. I have some familiarity with SiteCore. I have read some literature on Umbraco. I only just got wind of Orchard the other day. I have only heard positive …

Read More
A full guide to Orchard CMS

I am currently developing a very simple website in Orchard, which however required me to extend it both with themes, and with content types/widgets. Now this is as far as I went - Content Types and Widgets, because they …

Read More