Database connection error during data source configuration AEM Forms 6.5

Avatar

Avatar
Level 1
msgoldsgt
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
msgoldsgt
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
msgoldsgt
Level 1

12-02-2021

I am trying to install AEM Forms 6.5 on Windows 2016 Server running Windows SQL2016. I am using the Partial Turnkey option, and on the Partial Turnkey Installation Options I select MSSQL Server.  The installation completes without any errors.  During the AEM Forms Configuration Manager Datasource Configuration screen, I click Test Database Connection, and I get this message “Error [ALC-LCM-130-107] Database settings failed validation. Note: Windows Authentication on SQL Server will fail the connection test.  See documentation for more details.”

I have tried the JDBC drivers mssql-jdbc-6.2.2.jre8.jar, mssql-jdbc-9.2.0.jre8, mssql-jdbc-9.2.0.jre11, and mssql-jdbc-9.2.0.jre15 with the same error.  If I ignore the error and continue with the installation, I get this error “Bootstrapping Error: ALC-TTN-103-0000 Failed on step invoking component bootstrapper task Bootstrapping UserManager   ALC-TTN-103-000 Bootstrapping request failed on server.  Message from server. ALC-TTN-024-001 Unable to connect database: caused by [javax.resource.ResourceException:IJ000453: Unable to get managed connection for java:/IDP_DS].

 

I have tried creating a SQL user following the instruction on installation guide, and same error.  Also, I created a SQL user with database owner rights, and same error.  Both user can connect successfully to the database from a workstation to the server, using Microsoft Access and a SQL connection.

 

Any ideas to continue troubleshooting this issue are greatly appreciated.  Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
Employee
Kosta_Prokopiu1
Employee

Likes

165 likes

Total Posts

371 posts

Correct reply

107 solutions
Top badges earned
Affirm 100
Validate 1
Establish
Give Back 5
Give Back 3
View profile

Avatar
Affirm 100
Employee
Kosta_Prokopiu1
Employee

Likes

165 likes

Total Posts

371 posts

Correct reply

107 solutions
Top badges earned
Affirm 100
Validate 1
Establish
Give Back 5
Give Back 3
View profile
Kosta_Prokopiu1
Employee

16-02-2021

I am sure that MSSQL is rejecting the logon from JDBC. Your test with Access and a SQL connection is different to what happens during the JDBC based communication from Configuration Manager.

 

In the Preparing to install AEM Forms (Single Server) manual http://www.adobe.com/go/learn_aemforms_prepareInstallsingle_65 check out chapter "Set up the SQL Server for AEM Forms", "Integrated security"  and "Configure Integrated Security on Windows"

Answers (1)

Answers (1)

Avatar

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

Correct reply

185 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile

Avatar
Springboard
Level 10
Mayank_Gandhi
Level 10

Likes

327 likes

Total Posts

1,150 posts

Correct reply

185 solutions
Top badges earned
Springboard
Establish
Validate 1
Contributor 2
Ignite 5
View profile
Mayank_Gandhi
Level 10

18-02-2021

@msgoldsgt  I have seen this happening not only because of user access but also the default tcp port is not allowed by default in SQL Server. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, and check the port is enabled.