Troubleshooting
Problem
After setting up i2 iBase on a Windows Server 2012 system and creating a database using iBase Designer, attempting to connect to the database from a Windows 10 system results in error messages. First error: SQL Sever does not exist or access denied. Error #-2147467259 occurred in: Microsoft OLE DB Provider for SQL Server idDBEngine:mGetADOConnection idDBEngine:Connect idDBConnection:Connect CDatabases:DoOpen After resolving the first error, the next error occurs: Second error: You cannot connect to the database via this security file (Y:\Test.ids). The security file (.ids) associated with this database is: D:\iBase_DB\Test.ids
Symptom
First error:
Second error:
Environment
Windows Server 2012:
- SQL Server 2013
- iBase User/Designer
- Analyst's Notebook
- holds the shared drive to the .ids/.idb files
Two Windows 10:
- iBase User/Designer
- Analyst's Notebook
- mapped drive to the shared drive on the Windows Server 2012
iBase 8.9.11/ANB Windows Server 2012/Windows 10
Resolving The Problem
The first error is due to a Firewall setting on the server. Make sure and turn all your Firewall Profiles OFF.
For the second error:
To resolve this, the drive letter\path should match the drive being mapped on the Windows 10 Clients.
The D:\iBase_DB\ drive\path on the server is being used as the shared drive, so the Windows 10 clients should have a mapped drive denoted as D:\iBase_DB as well for the drive\path.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg22015764