Re: Error 515 when executing aspnet_regsql



On Jul 13, 3:04 pm, Alexey Smirnov <alexey.smir...@xxxxxxxxx> wrote:
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.

How can you declare column 'Column' to allow NULL values in SQL
Enterprise? I am having the same problem on SQl Server 2000 on a
server that I do not have iis running, would that make a difference?

.



Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)