Internal Server Error when trying to run aspnet_regsql SQL Script on DASP shared Sql Server

[bruce]

The 1st thing you want to do is to configure your browser to display the real error, see http://kb.discountasp.net/article.aspx?id=10052

post the error if you still have problem

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[seebluenet]

Thanks for that, I've now found that it wasn't happy with print statements in the SQL. I removed said statements, checked the sql parsed ok, and then tried to re-run it in the Query Analyser in the Control Panel.


I now get the Error: "Line 37: Incorrect syntax near 'BEGIN'."


The start of the script looks like:



/************************************************** ********************/
/* InstallCommon.SQL */
/* */
/* Installs the tables, triggers and stored procedures necessary for */
/* supporting the aspnet feature of ASP.Net */
/*
** Copyright Microsoft, Inc. 2003
** All Rights Reserved.
*/
/************************************************** ********************/
GO
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS ON -- We don't want (NULL = NULL) == TRUE
GO
SET ANSI_PADDING ON
GO
DECLARE @dbname NVARCHAR(128)
DECLARE @dboptions NVARCHAR(1024)
SET @dboptions = N'/**/'
SET @dbname = N'DB_101887_MYDBNAME'


/************************************************** ***********/
/************************************************** ***********/
/************************************************** ***********/
-- Create the temporary permission tables and stored procedures
-- TO preserve the permissions of an object.
--
-- We use this method instead of using CREATE (if the object
-- doesn't exist) and ALTER (if the object exists) because the
-- latter one either requires the use of dynamic SQL (which we want to
-- avoid) or writing the body of the object (e.g. an SP or view) twice,
-- once use CREATE and again using ALTER.

IF (OBJECT_ID('tempdb.#aspnet_Permissions') IS NOT NULL)
BEGIN
DROP TABLE #aspnet_Permissions
END
GO
CREATE TABLE #aspnet_Permissions
(
Owner sysname,
Object sysname,
Grantee sysname,
Grantor sysname,
ProtectType char(10),
[Action] varchar(20),
[Column] sysname
)
INSERT INTO #aspnet_Permissions
EXEC sp_helprotect
IF (EXISTS (SELECT name
FROM sysobjects
WHERE (name = N'aspnet_Setup_RestorePermissions')
AND (type = 'P')))
DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissions
GO
CREATE PROCEDURE [dbo].aspnet_Setup_RestorePermissions
@name sysname
AS
BEGIN
DECLARE @object sysname
DECLARE @protectType char(10)
DECLARE @action varchar(20)
DECLARE @grantee sysname
DECLARE @cmd nvarchar(500)
DECLARE c1 CURSOR FORWARD_ONLY FOR
SELECT Object, ProtectType, [Action], Grantee FROM #aspnet_Permissions where Object = @name
OPEN c1
FETCH c1 INTO @object, @protectType, @action, @grantee
WHILE (@@fetch_status = 0)
BEGIN
SET @cmd = @protectType + ' ' + @action + ' on ' + @object + ' TO [' + @grantee + ']'
EXEC (@cmd)
FETCH c1 INTO @object, @protectType, @action, @grantee
END
close c1
deallocate c1
END
GO


Any ideas?

[seebluenet]

Morning all,
I've been recieving an internal Server error (500) when trying to run my sql script (generated using aspnet_regsql Ref: http://community.discountasp.net/default.aspx?f=24&m=6679), on my database on the Discount ASP Sql server control panel.

I ran the same script (without changes) on my MSDE instance, and all seem to run fine and dandy. Can any of you guru's give me a clue?

[bruce]

i can't tell what's wrong w/ the statement. it looks correct to me.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[Soluplustech]

I can't tell you why it doesn't work - I couldn't get it to work through the discount site either. I can tell you that it works when you use Enterprise Manager. If you don't have this - get the SQL2005 beta from here http://www.microsoft.com/technet/previewsqlserver2005/default.mspx . They say 4-6 weeks but it was delivered in 4 days (and the version was only 8 days old).