How can I execute aspnet_regsql on my SQL Server database?

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)

4 thoughts on “How can I execute aspnet_regsql on my SQL Server database?”

  1. 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 /*

  2. 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.

Comments are closed.