How to Use SQL Server 2008 instead of SQL Ce ?

Topics: Administration, Customizing Orchard
Oct 7, 2013 at 5:19 AM
Edited Oct 7, 2013 at 5:20 AM

I wanna use SQL Server 2008 instead of the default SQL Ce in my Orchard website.
I managed to make a script of the Database and create a new database in SQL Server 2008
Now i want my application to use SQL Server 2008 Database.

Where should i define these settings?
Please help me getting this done.
Oct 7, 2013 at 6:13 AM
Ok I have done it.

You need to change the following code in your Orchard.Web\App_Data\Sites\Default\Settings.txt

Name: Default
DataProvider: SqlServer
DataConnectionString: Data Source=YourServerName;Initial Catalog=YourDatabaseName;User Id=YourUsername;Password=YourPassword;
Marked as answer by arunverma on 10/6/2013 at 11:14 PM