Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. KB 906715 - You may receive a "Server Error in '/' Application" error message when you start Business Portal

KB 906715 - You may receive a "Server Error in '/' Application" error message when you start Business Portal

View products that this article applies to.

Symptoms

When you start Business Portal, you may receive the following error message:
Server Error in '/' Application. --------------------------------------------------------------------------------


SELECT permission denied on object 'MbfSubscription', database 'DYNAMICS', owner '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: SELECT permission denied on object 'MbfSubscription', database 'DYNAMICS', owner 'dbo'.

↑ Back to the top

Cause

This problem occurs if the BFGROUP database role does not have appropriate permissions for Business Portal objects.

↑ Back to the top

Resolution

To resolve this problem, run the following script. This script assigns the appropriate permissions to the BFGROUP database role.

Notes
  • If you are running Business Portal together with Microsoft Dynamics GP, back up the DYNAMICS database and all company databases. Next, run the script against the DYNAMICS database and all company databases.
  • If you are running Business Portal together with Microsoft Dynamics SL, back up the system database and all application databases. Next, run the script against the system database and all application databases.
  • Run the script in Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
/*Count : 1 */

declare @cStatement varchar(255)

declare G_cursor CURSOR for select 'grant select,update,insert,delete on [' + convert(varchar(64),name) + '] to BFGROUP' from sysobjects 
where (type = 'U' or type = 'V') and uid = 1

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement 
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC (@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement 
end
DEALLOCATE G_cursor

declare G_cursor CURSOR for select 'grant execute on [' + convert(varchar(64),name) + '] to BFGROUP' from sysobjects 
where type = 'P'  

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement 
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC (@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement 
end
DEALLOCATE G_cursor

↑ Back to the top

Keywords: kbnosurvey, kbmbsgp10,, kbfreshness2007, kbsolomonbp, kbgreatplainsbp, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 906715
Revision : 2
Created on : 2/9/2018
Published on : 2/9/2018
Exists online : False
Views : 282