Unable to Connect to SQL Server Database from Pega 7
Hi,
How can I connect to SQL Server Database using "JDBC URL listed below" option. I'm trying it referring the article below...
jdbc:sqlserver://XXX.XX.X.XXX\SQLEXPRESS:1433;databaseName=RPA_Training
but an error occurs after Saving and Testing connection.
I can connect to the Database from a PC.
Hi,
How can I connect to SQL Server Database using "JDBC URL listed below" option. I'm trying it referring the article below...
jdbc:sqlserver://XXX.XX.X.XXX\SQLEXPRESS:1433;databaseName=RPA_Training
but an error occurs after Saving and Testing connection.
I can connect to the Database from a PC.
Thank you,
Pegasystems Inc.
IN
Give URL as " jdbc:sqlserver://XXXXXX:1433;databaseName=RPA_Training" instead of jdbc:sqlserver://XXX.XX.X.XXX\SQLEXPRESS:1433;databaseName=RPA_Training.
I believe there is no need to specify SQLEXPRESS. I tried with the above URL and i am able to connect to the database.
Power Solutions, Ltd.
JP
Hi Akshay,
Thank you for the information. After trying without \SQLEXPRESS, exactly the same error has occurred again...
Thank you,
Pegasystems Inc.
IN
Error suggest that you are not reachable. Can you check the firewall settings and make it open (if port closed) to connect to the database
Power Solutions, Ltd.
JP
- TCP 1433 is open on the PC where the database is
- Using static port 1433 and Pega 7's IP is set
Pega 7 platform on which I'm trying is provided for online exercise SYSTEM ARCHITECT ESSENTIALS I, so do I have to configure any VirtualBox settings?
Develop emviroment is:
PC A where the SQL Server instance is, PC B which is the host of the virtual machine where Pega 7 is running.
Pegasystems Inc.
US
I think this is likely a virtualbox configuration issue. Can you ping or telnet to the server that hosts the sql server instance from the virtualbox instance?
Power Solutions, Ltd.
JP
Hi NIck,
I confirmed that ping from the virtualbox instance to the PC where SQL Server is running returns 'Network is unreachable'. Could you please show me which options do I have? For example... can I open firewall path for this connection?
Power Solutions, Ltd.
JP
Pega 7 has connected to the database after creating the DB on the PC where VM is running. The problem was in the VM-DB connection.