Adobe Campaign Classic SQL Server DB

[Luca_Lattarini]

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

[Craig_Thonis]

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]

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?

[Sukrity_Wadhwa]

Hi @Craig_Thonis, Can you please help @Luca_Lattarini further? Thanks!

[Luca_Lattarini · Accepted solution]

Hi All, the solution is setting server="127.0.0.1, CUSTOM SQL SERVER PORT"

[Sukrity_Wadhwa]

Thanks @Luca_Lattarini for posting the solution!