Problem with aspnet_regsql.exe

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(SqlException exception, Boolea


n breakConnection)


at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception


, Boolean breakConnection)


at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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.RunExecuteNonQueryTds(String methodName,


Boolean async)


at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res


ult, String methodName, Boolean sendToPipe)


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


at System.Web.Management.SqlServices.ExecuteFile(String 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

 

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

 

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