SQL Server 2005 Express Compatable?

Aug 16, 2007 at 6:58 PM
Does the supplied SQL script work with SQL Server 2005 Express or does BlogEngine in general work on Express editions? I tried to run the script and get errors.

Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Aug 20, 2007 at 3:43 PM
You may try to run BlogEngine.NET/setup/MSSQL1.1.0.0.sql

I just setup BlogEngine using SQLExpress by running above SQL scripts
Oct 4, 2007 at 8:11 PM
I was looking for more infomation regarding SQL express integration as well.... So far all I have found is this, hth

http://www.dotnetblogengine.net/wiki/SQLServerBlogProvider.ashx

Looking for something with more details, will post here again if I find anything...


Oct 25, 2007 at 3:29 AM
I switched over to SQLExpress 2005 last night after downloading BlogEngine.NET and verifying it worked with the XML file. Everything went smooth (including the scripts), I just didn't set the permissions correctly for named user used to connect to the database (am still learning).