Error when launching Web Portal - Repository isn't configured

Summary:

User gets following error message when launching Web Portal first time after installation. 

Symptoms:

Cause:

This is caused by Apppool user is not 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 then do following:

• 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.

If Portal and SQL server are installed on the same machine the do following:

• 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.

Do IISReset from command prompt. You must be logged into command prompt as Administrator. 

Properties:

Applies To:

• OSR Portal 4.x