Publishing error

Last post 04-06-2009 7:55 AM by rajbipul. 2 replies.

Sort Posts:

  • Publishing error

    04-06-2009, 4:05 AM
    • Member
      12 point Member
    • rajbipul
    • Member since 02-15-2009, 11:22 PM
    • Posts 19

    this is the error i am getting while i am trying to publish the website over the server.

     please tell me what to do for this error and you all have done for the error.

    has any one who had published the Club website do tell me about this error what you have done to correct this error.

    Server Error in '/' Application.

    The SELECT permission was denied on the object 'WebSettings', database 'unifiedm_ClubDB', schema 'dbo'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'WebSettings', database 'unifiedm_ClubDB', schema 'dbo'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [SqlException (0x80131904): The SELECT permission was denied on the object 'WebSettings', database 'unifiedm_ClubDB', schema 'dbo'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
       System.Data.SqlClient.SqlDataReader.get_MetaData() +83
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +70
       SubSonic.SqlDataProvider.GetReader(QueryCommand qry) in C:\SubSonic 2.0.3\src\SubSonic\DataProviders\SqlDataProvider.cs:138
       SubSonic.DataService.GetReader(QueryCommand cmd) in C:\SubSonic 2.0.3\src\SubSonic\DataProviders\DataService.cs:343
       SubSonic.AbstractRecord`1.LoadByParam(String columnName, Object paramValue) in C:\SubSonic 2.0.3\src\SubSonic\ActiveRecord\AbstractRecord.cs:328
       ClubStarterKit.Data.WebSettings..ctor(String columnName, Object columnValue) in D:\bipul project\Standard_(VB)\ClubStarterKit.Data\Generated\WebSettings.vb:53
       ClubStarterKit.Web.Settings.PushToSession() +160
       ASP.global_asax.Session_Start(Object sender, EventArgs e) +63
       System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +8779824
       System.Web.SessionState.SessionStateModule.CompleteAcquireState() +237
       System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +504
       System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +66
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
    


    Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074

  • Re: Publishing error

    04-06-2009, 4:56 AM
    • All-Star
      26,831 point All-Star
    • qwe123kids
    • Member since 03-27-2008, 5:49 AM
    • Mumbai
    • Posts 4,560

    Hi,

    In sqlserver In Table or view "WebSettings" Your user example:- sa donot have rights to use select query .. Modify the rightof user and provide 'select" Rights To it..

    Hope it helps

    Thanks
    Avinash Tiwari

    Remember to click “Mark as Answer” on the post, if it helps you.

    MY Blog

    Hacking Inside .net exe
  • Re: Publishing error

    04-06-2009, 7:55 AM
    • Member
      12 point Member
    • rajbipul
    • Member since 02-15-2009, 11:22 PM
    • Posts 19

    the error is seems to form the web.config side.

     

    but as you suggested i will doing that and also it is not working correctly.

Page 1 of 1 (3 items)