I recently asked my service provider to run the aspnet_regsql.exe tool on a new database created with MS SQL 2000 on a machine that supports ASP.NET 2.0. I need this so I can take advantage of all the membership and roles using forms authentication. The blank database was created using WebAdmin/ASP Enterprise Manager. When he runs this tool he gets the errors show below. Any help on what could be causing this and how to get around the problem would be greatly appreciated.
=====
Setup failed.
Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1776 and the SqlException message is: There are no primary or candidate keys in the referenced table 'dbo.aspnet_Applications' that match the referencing column list in the foreign key 'FK__aspnet_Us__Appli__7D78A4E7'.
Could not create constraint. See previous errors.
Creating the aspnet_Users table. ...
Go to the complete details ...