Hi guru's,
I recently installed ARis 9.8 publisher on a MS SQL 2016 server, but had to be on a MS SQL 2016 clustername.
SQL Servername: sqlserver2016
SQL clustername: NLAppSQL
Does one of you guru's have the Reconfigure command to change this in the config.
thanks
Marcel,
The question is not clear... if you want to change the database URL to Publisher, this is the command:
ACC+ localhost>reconfigure businesspublisher_m +bp.db.url="<new URL>"
The standard URL is as follows:
a) MSSQL server:
jdbc:sqlserver://<FQDN-hostname>:<port>;databaseName=<db-name>[;instance=MSSQLSERVER]
BR
AO
Hi André, thanks for you reply. I think it was a bit unclear. I ment I had to change the sql server computername into a sql server clustername. But the command you mentioned did the trick.
Now I have to the same for the Aris 9.8 Design Server.
The database location that I entered in the setup was also a sqlserver computername and this one must be changed to a sqlserver clustername also.
Do I need to run this command:
register external service db url="jdbc:sqlserver://SqlClusterName:1433;DatabaseName=ARIS9DES;instance=MSSQLSERVER" ?
Thanks
Hi Marcel,
Sorry for delay I don't getting any update when post is updated.. I have to check this afterwards...
In that case you can use this one:
Syntax MSSQL server:
ACC+ localhost>update external service db<service-id> +url="jdbc:sqlserver:@<mssql server>:<listener-port>;DatabaseName=<Databasename>;instanceName=<instancename>" +host=<mssql-server>
BR
AO