Adobe Campaign Classic SQL Server DB | Community
Skip to main content
Luca_Lattarini
Luca_Lattarini
Level 9
January 13, 2021
Solved

Adobe Campaign Classic SQL Server DB

  • January 13, 2021
  • 1 reply
  • 1641 views

Hello everyone,

 

I am installing AC marketing instance on-premise by using Microsoft SQL Server for connection to database. The port allowed for DB connectivity on this database is 16000 and we are unable to pass this port as part of the server name or other DB details. It is by default picking up the 1433 for connection to Microsoft SQL. 

 

Please provide some advise on how to custom configure this connection port for microsoft SQL.

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Luca_Lattarini
Hi All, the solution is setting server="127.0.0.1, CUSTOM SQL SERVER PORT"

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
January 13, 2021

Hi Luca,

 

I'd suggest checking server side in the config-<instance>.xml file.  The file is stored in the /conf/ Adobe Campaign install directory and typically houses the configured DB configurations.

 

Regards,

Craig

Luca_Lattarini
Luca_LattariniAuthor
Level 9
January 14, 2021

Hi Graig, I checked the config-<instance> and I have this 

 

 

<dataStore hosts="demo*" lang="en_GB" uploadWhitelist="(?i).*\.(jpg|jpeg|png|favicon|xml|gif|bmp|txt|tab|csv|css|htm|html|zip|pdf|ppt|pptx|xls|xlsx|doc|docx|odt|p12)">
<dataSource name="default">
<dbcnx encrypted="1" login="XXX" password="XXXX"
provider="XXX" server="127.0.0.1"/>
</dataSource>
</dataStore>

Did u mean this?

 

Terms & ConditionsAccessibility statement

Loading footer...