Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

TRANSLATED:

Database unreachable;
No Read-permissions for database.
Please contact the administrator

(Although the domain login account has permissions on that database.)


edit:

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.

share|improve this question
1  
Check the MSSQL server log to see if you can identify any logon failures from the connection attempt by inLoox –  Mathias R. Jessen May 7 '12 at 9:27
    
There is some documentation in German available for SQL server and database permission configuration - have you seen this and have you set the roles for your database user accordingly? –  syneticon-dj May 7 '12 at 9:43
    
@MathiasR.Jessen Thx for the idea! I just looked into the log files, but there are only 3 entries for today and they are not related to inloox. –  slartidan May 7 '12 at 11:33
    
@syneticon-dj I used this documentation to set up our database. As far as I know my settings are set accordingly. :( –  slartidan May 7 '12 at 11:34
1  
You should post your solution as an answer and accept it. –  wfaulk May 7 '12 at 19:07
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.