Troubleshooting
Problem
We recently migrated our upsized database, and I want to open my database in iBase Designer.
I'm able to successfully Log in, by connecting to my .ids security file.
When I click "File-->Open Database", nothing happens. I am still connected to the .ids file, and I can click "File-->Open Database" again and again, but it never actually connects me to my database. No error is thrown.
Cause
If the userid you're using to connect to SQL Server does is not mapped as a user for the backend SQL Server database, you see this symptom.
Diagnosing The Problem
Run the iBase Database Configuration Tool.
Make a note of the Login Name used in the second pane.
As SQL Server Administrator, review your SQL Server
Resolving The Problem
Make sure that the SQL Server user has been mapped with minimally Public access privileges to the SQL Server database.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m50000000Ci9uAAC","label":"i2 iBase and i2 Analyst's WorkStation->Database->Migration"}],"ARM Case Number":"TS007267115","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
27 October 2021
UID
ibm16508573