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.
- This is a windows authenticated user
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.
- This is a windows authenticated user
Do IISReset from command prompt. You must be logged into command prompt as Administrator.
Properties:
Applies To:
- OSR Portal 4.x
Comments
0 comments
Please sign in to leave a comment.