Unable to Install - Please help

Topics: General, Installation
Jul 20, 2007 at 3:30 PM
I am unable to install dotcommunities as I get the following error messages

==== FIRST ====

      • 2DotCommunitiesViews.sql ***

Msg 208, Level 16, State 1, Procedure ViewCommunitySectionContentPages, Line 26
Invalid object name 'dbo.Community_Sections'.

I also get lot of error messages while executing TestDotCommunitiesData.sql.

Creating host information...
Msg 1088, Level 16, State 11, Line 2
Cannot find the object "dbo.Community_Hosts" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'dbo.Community_Hosts'.
Msg 1088, Level 16, State 11, Line 2
Cannot find the object "dbo.Community_Hosts" because it does not exist or you do not have permissions.
Creating community information...
Msg 1088, Level 16, State 11, Line 2
Cannot find the object "dbo.Community_Communities" because it does not exist or you do not have permissions.

Error message continues.

Is it necessary to replace the word "dbo" with my database username?

==== SECOND ====

I uploaded all the files inside Web folder to the web server. Is it correct method? Please clarify.

Is it necessary to compile anything locally before uploading to the webserver?

Please provide necessary clarifications to the above queries?

Regards,
Anand
Coordinator
Jul 27, 2007 at 11:01 AM
Try doing a search and replace for "dbo" with the schema name for your database. If you are uploading to an ISP, then this will be disabled as permissions for the dbo schema would allow you to change other databases not under your control.

You will also need to complile the application before you upload it to your server/ISP.