This project is read-only.


Problem installing with an SQL Azure Server


I've just downloaded MVCwCMS 4.1.0 and started to set it up.
The first step was to provide my server details, which I did with my Azure SQL server; however, right after of getting my user and password, I hit continue and all of the sudden Visual Studio thrown the erro below... could you please help me?

System.Data.SqlClient.SqlException was unhandled by user code
Message=Could not find stored procedure 'sp_cms_global_configuration_select'.
Source=.Net SqlClient Data Provider


valgen wrote Mar 24, 2016 at 1:53 AM

Which one of the below options did you use to install the CMS?

Create database if it doesn't exist (yes or no)

When you set that option to yes you MUST hold the permissions to create a new database regardless of your SQL authentication type.

Without permissions the script will fail to create the database and you will get an exception as a consequence.

By the way if the script fails to create the database you should see an error message reporting the reason of why it failed.

parismiguel wrote Mar 24, 2016 at 7:41 PM

Hi Valgen, thank you for your prompt response! my apologies if I couldn't reply before as yesterday was my daughter's birthday.
What I did was to choose "yest" in order to create a database... what I'm not sure is where to set the permissions you mention... could you please point me out?



valgen wrote Mar 25, 2016 at 3:21 AM

Hey Paris,

Please can you write me through the following page attaching some screenshots of the entire process you followed to install the CMS:


parismiguel wrote Mar 25, 2016 at 7:09 PM

HI Valgen,

I tried again from scratch, this time pointing to a localhost and it worked beautifully... thank you!