Re: Publishing error

rajbipul — Mon, 06 Apr 2009 11:55:35 GMT

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.

Re: Publishing error

qwe123kids — Mon, 06 Apr 2009 08:56:42 GMT

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

Publishing error

rajbipul — Mon, 06 Apr 2009 08:05:22 GMT

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

Codeplex Club Starter Kit

Re: Publishing error

Re: Publishing error

Publishing error

Server Error in '/' Application.

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