Summary:
This article troubleshoots an error that occurs when launching the Web Portal for the first time after installation when Apppool user does not have adequate permissions.
Symptoms:
When a user launches the Web Portal first time after installation, they receive the following error message:
OneStop Reporting
Welcome to OSR Portal installer
You are here because the repository isn't configured yet.
Please run OneStop Reporting Administration to setup your repository and refresh this page.
Causes:
This is caused by Apppool user not being added on the SQL server with proper permission to the OSR_Repository database.
Resolution:
If Portal is installed on a machine separate from SQL server machine, follow these steps:
- Create "DOMAIN\Machinename$" (This machine name is where Portal is installed) user on the SQL server.
- This is a Windows authenticated user.
- This user does not need to be added to the domain.
- It is recommended to turn off "Enforce password policy" as you do not want this user's password to expire.
- Map this user to OSR_Repository database with database owner permission.
- Map this user to any database that users may connect to from the Portal application with read permissions.
- This is a Windows authenticated user.
If Portal and SQL server are installed on the same machine, follow these steps:
- Create "IIS APPPOOL\OSR Portal" user on the SQL server.
- This is a windows authenticated user.
- This user does not need to be added to the domain.
- It is recommended to turn off "Enforce password policy" as you do not want this user's password to expire.
- Map this user to OSR_Repository database with database owner permission.
- Map this user to any database that users may connect to from the Portal application with read permissions.
- This is a windows authenticated user.
Do IISReset from command prompt. You must be logged into command prompt as Administrator.
Properties:
OSR Portal 4.x