Service Operations Insight

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

Jun 16, 2015 06:30 AM

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

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.