Problem with aspnet_regsql.exe

[IanHoughton]

I have tried runningaspnet_regsql.exe but keep getting this error....




C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S sql2k501.disc


ountasp.net -U SQL2005_235903_ianhoughton_user -P [Password] -A all -d SQL2005_23590


3_ianhoughton


Start adding the following features:


Membership


Profile


RoleManager


Personalization


SqlWebEventProvider


......


An error occurred during the execution of the SQL file 'InstallCommon.sql'. The


SQL error number is 229 and the SqlException message is: SELECT permission denie


d on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.


SQL Server: sql2k501.discountasp.net


Database: [SQL2005_235903_ianhoughton]


SQL file loaded:


InstallCommon.sql


Commands failed:


CREATE TABLE #aspnet_Permissions


(


Owner sysname,


Object sysname,


Grantee sysname,


Grantor sysname,


ProtectType char(10),


[Action] varchar(200),


[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


.SQL Exception:


System.Data.SqlClient.SqlException: SELECT permission denied on object 'sysobjec


ts', database 'mssqlsystemresource', schema 'sys'.


at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolea


n breakConnection)


at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception


, Boolean breakConnection)


at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObj


ect stateObj)


at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cm


dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds


ParserStateObject stateObj)


at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName,


Boolean async)


at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult res


ult, String methodName, Boolean sendToPipe)


at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()


at System.Web.Management.SqlServices.ExecuteFile(Stri ng file, String server,


String database, String dbFileName, SqlConnection connection, Boolean sessionSta


te, Boolean isInstall, SessionStateType sessionStatetype)


Any ideas anyone ???


Can i get discountasp to set up the database for me ??


Thanks Ian

[Aristotle]

Your SQL user may not have DBO rights, so check your user permissions. If you can't change your own permissions, create helpdesk ticket to our support team.

Aristotle

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

[IanHoughton]

Thanks for the reply, tech support had reset my permissions and everything is working fine.