AnsweredAssumed Answered

PI SQL Commander --> connect to AF server with an explicit password. 

Question asked by ChewCheeLim on Nov 19, 2015
Latest reply on Nov 19, 2015 by bshang

Hi There, I would like to set up PI SQL Commander to connect to AF with an explicit Password instead of 'Integrated security'.

 

If someone can help me how to set up the security setting in AF Server ? Currently I am getting this error message during my connect

 

18-Nov-2015
12:20:45.83                             
PROVIDER_INIT              
PISQLCommander         
3348       4            
3284       Data Source
IDBInitialize      
Initialize             
User ID = "myId";
Initial Catalog = "Configuration"; Data Source =
"EMPRODAF01"; Window Handle = "0"; Prompt = "4";
Extended Properties = "Unique ID=d6f041cb-47f1-4d3f-b693-f8ae1c4d86d2";
Connect Timeout = "60"; Integrated Security = ""; Command
Timeout = "-1"; Log Level = "3"; Log File =
"C:\Temp\PISQLCommanderLog.txt"; Shorten Primary Keys = "0";
Always Return Rowset = "0"; Defer Execution = "0"; Disable
Server Selection = "0"; Time as Double = "0"; Optimization
Log Limit = "100"; Keep Default Ordering = "0"; Embed
Errors = "0"; Ignore Errors = "0"; Function Errors as NULL
= "0"; Cancel On Low Resources = "0"; Show Hidden Metadata
= "0"; Allow Expensive = "0"; Use Agent = "-1";

18-Nov-2015
12:20:48.618          
ERROR_RECORD             
PISQLCommander         
3348     
4            
3284       Data
Source              
IDBInitialize      
Initialize             
E_FAIL - [OSIsoft.AFSDK]
Cannot connect to server 'EMPRODAF01'.

18-Nov-2015
12:20:48.618          
INTERFACE_ERROR       
PISQLCommander         
3348     
4            
3284       Data
Source              
IDBInitialize      
Initialize             
E_FAIL

Outcomes