This project is read-only.

nearforums with Azure SQL?

Dec 7, 2012 at 5:00 PM

Hi,

I discovered nearforums today while searching for a replacement to my terrible install of phpBB. I'm a c# application developer so I thought I'd try it out.

I run a couple of sites on Azure, and I'd like to be able to keep everything in one place.

I'm new to SQL server (am used to MySQL/ mongo) so I am unsure how to modify the db creation script to work on Azure. This thread: http://nearforums.codeplex.com/discussions/357378 leads me to believe that it is possible!

I'm copying and pasting the SQL to the SQL query window in Azure. I get a lot of errors though... (e.g. "Could not find stored procedure 'sp_addrole'." , "Cannot find the user 'aspnet_Membership_ReportingAccess', because it does not exist or you do not have permission.", "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.", "User or role 'aspnet_Profile_FullAccess' does not exist in this database.").

Would anyone be kind enough to give me a step by step guide on how to get nearforums working with an Azure SQL database?

Dec 7, 2012 at 7:02 PM

Hi rukko,

SQL Azure will be fully supported in next version (9).

In the meantime, if you are interested, you can use these scripts: http://www.nearforums.com/downloads/nearforums8.5.1.0-sql-base-azure.zip

 

Execute them in the following order:

  1. mssql.create-membership-all.sql (ASP.NET Membership scripts modified based on MSFT KB )
  2. mssql.create-all.sql
  3. mssql.inserts.sql

Kind Regards,

Jorge