Fer...@discussions.microsoft.com> wrote:
> We are having problems when executing aspnet_regsql in our client's
> envitorment. We are using SQL Server 2000 with an account with full
> privileges, but the wizard thorws the following exception:
>
> Setup failed.
>
> Exception:
> An error occurred during the execution of the SQL file 'InstallCommon.sql=
'=2E
> The SQL error number is 515 and the SqlException message is: Cannot insert
> the value NULL into column 'Column', table 'tempdb.dbo.#aspnet_Permissions
>
> We also tried generating de SQL with the sqlexportonly option, but then w=
hen
> we use this script the same error message is thrown. =BFIs there a fix for
> aspnet_regsql? =BFHow can we overcome this issue?

On Jul 13, 3:04 pm, Alexey Smirnov <alexey.smir...@gmail.com> wrote:
> On Jul 10, 6:20 pm, Juan Carlos Ferrer <Juan Carlos
>
> Fer...@discussions.microsoft.com> wrote:
> > We are having problems when executing aspnet_regsql in our client's
> > envitorment. We are using SQL Server 2000 with an account with full
> > privileges, but the wizard thorws the following exception:
>
> > Setup failed.
>
> > Exception:
> > An error occurred during the execution of the SQL file 'InstallCommon.s=
ql'.
> > The SQL error number is 515 and the SqlException message is: Cannot ins=
ert
> > the value NULL into column 'Column', table 'tempdb.dbo.#aspnet_Permissi=
ons
>
> > We also tried generating de SQL with the sqlexportonly option, but then=
when
> > we use this script the same error message is thrown. =BFIs there a fix =
for
> > aspnet_regsql? =BFHow can we overcome this issue?
>
> I think you can try to declare column 'Column' to allow NULL values.
> Open SQL Enterprise Manager and change the table definition.