Hello,

MSsql Server 2008
mojoportal-2-3-5-1-mssql-net35-deploymentfiles
ASP.NET Mosso Cloud

I have reviewed as much documentation and forum posts as I could and it seems the subject has come up many times with varied causes.

Fortunately, Mosso provided a step by step on the install, coupled with your data, and 6 hours of troubleshooting, I got it up.

a.) data and app_data are set as 777, including subfolders and files.

b.) impersonate was completed

c.) I had to manually create sub folders as described in the forum, within the data folder.

... and misc. other items, like turning off custom error.

No edits outside instructions have been done.

The site appears to come up.

I am able to register a fresh account... but am looking for admin access.

Found that I should use, admin@admin.com admin does not login, in any way.

Password recovery states the user does not exist.

I logged into Mosso's DB manager tool and find the single user I registered by hand, but no record of an Admin Account.

Viewed another page of yours with a video, using sqlexpress and I noticed a db structure...

security/login/

but in mine

security/login does not exist

I do have below security

users, roles, schemas, asymetric keys, certificates, symetric keys

mlmworldguide.com

Any help is greatly appreciated.

It seems to me the MSSql Installer may not be perfected.

I cleared the log file and ran the install twice to see If I could provide additional hints...

"2010-08-27 01:45:11,028 INFO mojoPortal.Web.Global - Application Started.
2010-08-27 01:45:11,059 ERROR mojoPortal.Web.Global - Application_Start Could not register VirtualPathProvider, this error is expected when running in Medium trust or lower
System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at mojoPortal.Web.Global.RegisterVirtualPathProvider()
at mojoPortal.Web.Global.Application_Start(Object sender, EventArgs e)
The action that failed was:
InheritanceDemand
The type of the first permission that failed was:
System.Web.AspNetHostingPermission
The Zone of the assembly that failed was:
Intranet" 

Thank you,

Scott H Leonard

scott@bizlocal.com

Hello Joe, thank you for the directives.

When viewing the DB yesterday and the single registration I made, I also considered that possibility.

When editing the DB to add the user in roles, some long hash strings seemed to be needed for me to actually wire it up.

I will review it again and perhaps you can direct me.

Thank you,

-Scott

Hello Joe,

I have had several conferences today and returning to this when I have a break.

Ok... mp_Roles

There are no entries, i.e., there is no admin role created.

I selected to add a record and find:

SiteID
RoleName
DisplayName
SiteGUID
RoleGUID

I chose not to continue as the RoleGuid and SuteGuid, I will most probably need from another location.

It really seems as though the system did not fully create the Sql records needed.

-Scott

Hello Joe,

1.) Re-Uploaded the Setup Folder to insure there were no missing items.
2.) Logged into sql and removed the user, I registered through the site.
3.) Ran the page /Setup/Default.aspx

a.) Checked Sql and there is a new User!!! Admin.
b.) Went to site and logged in with credentials for Admin.

Joe, thank you for your assistance.

It is a pleasure to explore an open source app and have quick assistance when you hit a bump in the road.

Cheers!

-Scott H Leonard