Troubleshooting
Problem
Unable to login to a Controller SQL Server database The following error appears.
Symptom
Error -2147467259: Cannot open database requested by login ... login fails.
Resolving The Problem
The Controller database owner must be synched with the SQL Server login.
Steps:1. Launch SQL Server Query Analyzer2. Choose the appropriate Controller database and enter the following command
exec sp_change_users_login 'Update_One', 'SQL Server Controller userid' , 'SQL Server Controller userid'
For example: exec sp_change_users_login 'Update_One', 'fastnet' , 'fastnet'
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Controller (Frango) 2.3 MR1;Controller (Frango) 8.1MR1;Controller (Frango) 8.2;Controller (Frango) 8.2MR1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1024819
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21346162