Hello,
I installed Confluence version 5.4.9 as a service, on a Windows Server 2012 R2.
I have a Microsoft SQL database installed on the same server and i made the setup i found here https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html.
When i went to the setup wizard of Confluence database, i choose Direct JDBC:
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://localhost:1433/<insert_database>
The port should be 1433?
I also downloaded the jTDS 1.2.2 driver and copy jtds-1.2.2.jar file in confluence "bin" installation folder path (is this the right location?).
When i enter my database name and credentials, i receive this error:
image2016-2-18 11:33:55.png
I tried some tricks i found on forums but nothing worked (TCP-IP enabled on port 1433 in the SQL server configuration manager, I reinstalled it - nothing worked)
Firewall is disabled.
Is there another way to test the connection with the database?
Can you, please, advice what should be done in this case, or if i should perform other steps in the installation?
Best regards,
Roxana
Hello,
Thank you for your reply!
I could connect to the MSSQL with SQL Management studio with the user i used for Confluence and it worked, but didn't for Confluence.
The Port 1433 was configured for the IP of my server.
I solved the problem by leaving blank the TCP Dynamic Ports in the IP configuration.
Now, i manage to connect and all works well.
Thank you,
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.