Tech Tip: How to use soitoolbox when SAMStore is installed on different port than 1433 (Default)

Document created by ambas01 Employee on Jun 16, 2015
Version 1Show Document
  • View in full screen mode

In soitoolbox (via command prompt) we do not have direct option to use user defined port and the only possible way is to use it via soitoolbox.cfg

1. On the machine where you have soitoolbox run following command from path SOI\Tool on command prompt

soitoolbox.exe -x

 

2. This will create soitoolbox.cfg in ..SOI\tools location

 

3. Now edit soitoolbox.cfg and add following lines as

> Under "#1. Specify Windows credentials for all machines where SOI components are deployed"

machine=yourSOImanager.yourcompany.com;administrator;paswd123

#-----------

#Where

#administrator : Is Machine login details

#paswd123 : Is Machine login passwoed

#------------

> Under "#2. Specify credentials for SOI database"

database=<databaseName>;<machineName>;<instance>;<port>;<userName>;<PlainTextPassword>

 

Eg:

database=SAMStore;MY_DB_Machine_Name;My_DB_Instance_Name;1533;sa;My_Password

#-----------

#Where

#SAMStore : is my SOI DB Name

#MY_DB_Machine_Name: Is my DB Machine name

#My_DB_Instance_Name: Is my DB Instance name, Leave it blank if SAMStore is installed on SQL Default instance

#sa: Is my SQL Admin username

#1533 : Is my SQL port

#My_Password : Is password for sa

#------------

 

4. Now you can run command as

You can use following command to connect to remote SAMStore DB

Note: I am using --getConnectorStatus as a example here

 

soitoolbox.exe -x--getConnectorStatus

1 person found this helpful

Attachments

    Outcomes