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
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
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
Hi all, we found the correct command to get if fixed. Thanks.