I just installed InLoox and configured a connection to our MS SQL Server 2005. The connection should be fine - telnet works and I can connect to the inLoox database with my query analyzer. My firewalls are configured to allow access to ports TCP 1433 and UDP 1434.
Nevertheless, InLoox is unable to connect and shows a german error message:
Datenbank nicht erreichbar;
Leseberechtigung für die Datenbank nicht vorhanden.
Bitte kontaktieren Sie den Administrator.
No Read-permissions for database.
Please contact the administrator
(Although the domain login account has permissions on that database.)
Ok, we found the solution:
You have to use the inLoox-installer to create your database. We created the database on our own and tried to install inLoox into our own database. That is not working.
So: Create your database with the default inLoox installer - not on your own.