Billing Control Panel Client Voip ms sql webadmin ms sql backup mysql webadmin Server Status

  • How can I execute aspnet_regsql on my SQL Server database?

    4 comments October 17th, 2012 2036

    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)

    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...
  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 /*

    Comment by David on November 10th, 2015 at 1:49 AM



  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.

    Comment by David on November 10th, 2015 at 1:51 AM



  3. ignore that last comment. It appears the script runs things out of order so it should be fine.

    Comment by David on November 10th, 2015 at 2:03 AM



  4. @David – I will review this shortly and check on the issues you’ve reported. Thanks!

    Comment by Christopher York Staff Member on November 10th, 2015 at 8:11 AM



Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>