The default Microsoft aspnet_regsql application outputs SQL queries for use on a non-shared SQL Server installation and cannot be executed in a shared environment due to permission limitations. We have altered the output so that it may be executed and installed on a shared SQL Server database. Follow the link below to download the modified .sql file (you must login to your ASPnix billing account before you can download this file). Once downloaded you will need to extract the SQL script and execute the contents using SQL Studio Administrator, MyLittleAdmin or whatever tool you use to manage your SQL Server database.
Download aspnet_regsql (ASPnix Customers Only)
In the version I downloaded today (11/10/2015) there’s an error thrown because the comment end tag on line 5 is backwards. It should be */ instead of /*
And these errors upon final execution:
The module ‘aspnet_Membership_CreateUser’ depends on the missing object ‘dbo.aspnet_Users_CreateUser’. The module will still be created; however, it cannot run successfully until the object exists.
The module ‘aspnet_PersonalizationPerUser_SetPageSettings’ depends on the missing object ‘dbo.aspnet_Users_CreateUser’. The module will still be created; however, it cannot run successfully until the object exists.
The module ‘aspnet_Profile_DeleteProfiles’ depends on the missing object ‘dbo.aspnet_Users_DeleteUser’. The module will still be created; however, it cannot run successfully until the object exists.
The module ‘aspnet_Profile_SetProperties’ depends on the missing object ‘dbo.aspnet_Users_CreateUser’. The module will still be created; however, it cannot run successfully until the object exists.
ignore that last comment. It appears the script runs things out of order so it should be fine.
@David – I will review this shortly and check on the issues you’ve reported. Thanks!