Installer fails with: ExecuteSqlInFile - invalid EXECUTE statement using object "Relation", method "SetUseVarDecimal”

Reply

|

Contact

By: Razzamataz

Posted: Fri, Feb 29 2008 8:33 PM

I'm trying to install CommunityServer 2007.1 in a shared hosting environment.

My hosting provider supports Windows Server 2003 with ASP.NET 2.0, SQL Server 2005 and ASP.NET Ajax 1.0.

I uploaded the Web folder to the server's "wwwroot", checked basic settings in "web.config" and "communityserver.orig", and browsed to "http://mydomain.com/Installer/default.aspx".

The installer fires up, and everything proceeds as expected, until the "New community" screen appears.

I enter the Community URL, username/password for the admin account and the admijn email address.

Shortly after I click button Next, the following error appears:


Errors Occured

Errors  occured during the execution of this wizard

Module / Message

ExecuteSqlInFile    Error in file: \wwwroot\Installer\SqlScripts\InstallMembership.sql

Message: Invalid EXECUTE statement using object "Relation", method "SetUseVarDecimal".


To get more details about this error, I re-executed the code in script "InstallMembership.sql" in a query-window of SQL Server Management Studio. Now the error halts with:

-------------------------------------------
Starting execution of InstallMembership.SQL
-------------------------------------------
Msg 290, Level 16, State 1, Procedure sp_tableoption, Line 129
Invalid EXECUTE statement using object "Relation", method "SetUseVarDecimal".
Creating the vw_aspnet_MembershipUsers view...

(0 row(s) affected)

(1 row(s) affected)
--------------------------------------------
Completed execution of InstallMembership.SQL
--------------------------------------------

Inspecting script "InstallMembership.sql" shows this construct above line 129:

    IF (@ver >= 8)
        EXEC sp_tableoption N'aspnet_Membership', 'text in row', 3000

That certainly explains the presence of sproc "sp_tabeloption" in the error above.
I decided to comment the two lines out and try again. That eliminated the error indeed, but caused an identical error on the very much the same construct in script "InstallProfile.sql":

    IF (@ver >= 8)
    BEGIN
        EXEC sp_tableoption N'aspnet_Profile', 'text in row', 6000
    END

Again, commenting-out these 4 lines solves the error and install finishes correctly.

But here's the 64000 dollar question: what do I miss?

Looking at the code, it is only executed for SQL Server version above 8; isn't that above SQL Server 2000?

My hostingprovider runs SQL server 2005, "9.00.1399.06", Standard version.

What do I do?

Razza

• Filed under: installer errors |
• Post Points: 20 |

Reply

|

Contact

By: mBlaze

Posted: Sat, Apr 26 2008 4:35 AM In reply to

I also have this problem and I kill many time for solution this problem, and find him)). Install to Sql Server ServicePack 2 and all will be alrigth:)

• Post Points: 5 |