Installing Aris server with remote SQL DB

If you have the ARIS 7.1 Dvd , there you can find the script for Sql and the documentation "installation_administration_guide" where you have more details about do it....

Regards,

Dear Carlo, where are you on the installation procedure?

Did you installed MS SQL Server on Machine A? If so then you need to copy the SQL Scripts from ARIS DVD and execute them on MS SQL Server. There is detailed instruction if you consult the Installation Documentation. Make sure you have created ARIS71 database and ARIS71User in MS SQL Server through SQL Scripts.

After you have configured MS SQL Server with required database by default database name will be ARIS71, you need to run setup form Business Server on other machine say machine B. Provide database user name and password along with MS SQL Server Machine A with port.

You will also need a webserver on Machine B to host initial ARIS page and initial database information. 

Dear Adnan, thank you for your suggestion. I used it and the actual situation is described below.

I have my Machine B with ARIS71 DataBase and ARIS71 User created (no log file error was been generated).

I have Machine A with ARIS Business Server. I have configured Lockservice.cfg like installation guide describe to do (“Find the line url=jdbc:jtds:sqlserver://host:1433/ARIS71;instance=MSSQLSERVER there and replace host” my host is Machine B).

What I have to do now, please ?

Thanks a lot, CARLO

Check if server run properly from command line, by running ‘Start->Programs->Aris Business performance Edition->Administration->Aris Server 7.1’ program, if any error occurs, should be visible here on command line window

if server from command line runs ok, then close it, check if Aris 7.1 service exists, run it, check if it runs

Prepare Aris Application server to serve Web Clients using Microsoft IIS

1. Instal IIS if necessary
2. Run html generator ‘Start->Programs->Aris Business performance Edition->Administration->Aris HTML-Generator 7.1’ it will generate initial list od databases on server
3. Create Virtual directory on IIS with physical path to ‘C:\Program Files\ARIS7.1\server\html’
4. 1. Change documents to ‘index_app.html’ only
   2. Set MIME type: ‘.cfg’ with type ‘text/html’
   3. Check if Aris web components works fine by entering in web browser address: http://machineB

Dear Adnan,

In the attach file you can see the DOS message running ARIS Server 7.1 

The first step seems going right (“before le line [ARIS Agent] Running ARIS Server 7.1”)

At this moment I run ARIS Site Administrtor 7.1 to connect the Machine A (with ARIS B.Server - IP.172.16.12.218) with Machine B (with ARIS DB - IP.172.16.12.217). These are the data: Computer name = 172.16.12.217– Port Number = 16053 – Password SITEADMIN.

But ARIS Site Administrator shows an error message “Unable to generate list of the “Aris Server” server” while the DOS windows shows a list a warning e message error that you can see in the attach.

Unfortunately I’m not a developer, and you’re very kind to help me. I really hope to solve this problem.

Many thanks, CARLO

Carlo,

It's better to uninstall Business Server and re-install again.

• Try to install it with embedded database system. 
• If it works then reinstall again with SQL Database.

Could you also explain the steps that you done for SQL Server Configuration??

Hi Adnan,

I install ARIS 7.1 business server on windows 2008 server R2 (64 bit) and SQL Server 2008 R2. create databases  and config the lockservice, but the service cann'r be run and show "could not start ARIS server site" and "ARIS lockserivce could not be start properly"

This is my lockservice.cfg

#C:\Program Files\ARIS7.1\server\config\Lockservice.cfg

#Tue Oct 22 01:40:37 IRST 2013

db.startopt=-o "C\:/Program Files/ARIS7.1/server/log/asalog.txt" -Q -gp 8192 -md full -gk all -ti 0 -n ARIS71 -c 20m  -su ASA -x tcpip(BroadcastListener\=NO;DoBroadcast\=NO;ServerPort\=16074;LocalOnly\=yes)

switchsybasedriver=true

url=jdbc\:sqlserver://ARISBPSRV:1433/ARIS71;instance=MSSQLSERVER

startdb=yes

ls.mappingclass=com.idsscheer.dl.mapimpl.nasa.AMapping

db.bin.path=C\:/Program Files/ARIS7.1/server/ASA10/win32

db.data.path=C\:/Program Files/ARIS7.1/server/data

dl.mappingclass=com.idsscheer.dl.mapimpl.nasa.dl.AMapping

arisadm_user=ARIS71

db.startup.maxwait=180000

arisadm_schema=ARIS71

pwderrcode=e;-103

dbadmin_pwd=XXXXX

arisadm_pwd=*ARIS!1dm9n#

dbmsname=Adaptive Server Anywhere

driver=ianywhere.ml.jdbcodbc.jdbc3.IDriver"

I don't know what should I do?

thanks for your help