Re: Error 515 when executing aspnet_regsql

On Jul 10, 6:20 pm, Juan Carlos Ferrer <Juan Carlos
Fer...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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'.
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 when
we use this script the same error message is thrown. ¿Is there a fix for
aspnet_regsql? ¿How 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.

.

Relevant Pages

  • Re: Slammer
    ... Si ya instalaste el service pack 3 de sql server no tienes problema. ... Ese es el puerto que utiliza el worm slammer. ... Co-Author SQL Server 2000 Programming by Example ... "Juan Carlos Vazquez" wrote in message ...
    (microsoft.public.sqlserver.security)
  • [NT] Microsoft SQL Server Agent Jobs Vulnerabilities
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... As the public role can submit jobs to the SQL ... This effectively drops its high level of privileges so no low privileged ...
    (Securiteam)
  • Re: Security Update for SQL Server 2000 Service Pack 4 (KB948110) fail
    ... The patch installation uses the SQL SA user, which has sysadmin ... My SQL Server 2000 installation is the MSDE version bundled into ... see if your Windows user ID has SQL sysadmin privileges. ...
    (microsoft.public.windowsupdate)
  • Re: SQL server vulnerability through ODBC
    ... Look into Application Roles in SQL Server. ... You can grant the necessary select/insert/delete/update privileges to the ... from setting up an ODBC connection or some way in SQL administration to ...
    (microsoft.public.sqlserver.security)
  • [Full-disclosure] Team SHATTER Security Advisory: SQL Injection in Oracle Database (DBMS_DEFER_S
    ... The PL/SQL package DBMS_DEFER_SYS owned by SYS has an instance of SQL ... and execute SQL statements with the elevated privileges of SYS user. ... Any Oracle database user with EXECUTE privilege on the package ... Vendor was contacted and a patch was released. ...
    (Full-Disclosure)