93 lines
3.3 KiB
Markdown
93 lines
3.3 KiB
Markdown
---
|
|
created: 2024-01-14T02:18:22.109Z
|
|
type: topic
|
|
updated: 2024-08-21T05:39:47.510Z
|
|
---
|
|
|
|
# InfinityQS
|
|
|
|
- [Update IQS](../.kanbn/tasks/update-iqs.md)
|
|
|
|
## bash
|
|
|
|
```bash
|
|
"C:\Program Files (x86)\InfinityQS International\ProFicient\Applications\iispcmi.exe"
|
|
runas /profile /user:phares@infineon "C:\Program Files (x86)\InfinityQS International\ProFicient\Applications\iispcmi.exe"
|
|
C:\Windows\PsExec.exe -user "infineon\ecfisysadmin" -p "asdf" "C:\Program Files (x86)\InfinityQS International\ProFicient\Applications\iispcmi.exe"
|
|
```
|
|
|
|
## PowerShell
|
|
|
|
```PowerShell
|
|
$username = "infineon\ecfisysadmin"
|
|
$password = "asdf"
|
|
$startWithElevatedRights = "notepad"
|
|
|
|
$credentials = New-Object System.Management.Automation.PSCredential -ArgumentList @($username,(ConvertTo-SecureString -String $password -AsPlainText -Force))
|
|
$ps = Start-Process -PassThru -FilePath powershell -Credential $credentials -ArgumentList '-noprofile -command &{Start-Process ', $startWithElevatedRights, ' -Wait -verb runas}'
|
|
|
|
$ps.WaitForExit()
|
|
|
|
# https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.management/start-process?view=powershell-7.4
|
|
Start-Process -FilePath "iispcmi.exe" -WorkingDirectory "C:\Program Files (x86)\InfinityQS International\ProFicient\Applications"
|
|
```
|
|
|
|
```Tue Apr 02 2024 08:54:55 GMT-0700 (Mountain Standard Time)
|
|
HgCV Res Average
|
|
Ian Palmer
|
|
```
|
|
|
|
## TLS Disable 1.0
|
|
|
|
```
|
|
OperationalError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL
|
|
Security error (18) (SQLDriverConnect); [08001] [Microsoft][ODBC SQL Server Driver]
|
|
[DBNETLIB]ConnectionOpen (SECCreateCredentials()). (1)')
|
|
```
|
|
|
|
- [TLS-Settings-Enabling-TLS-12](https://advantive.my.site.com/support/s/article/TLS-Settings-Enabling-TLS-12)
|
|
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client
|
|
- Enabled ***1***
|
|
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319
|
|
- If the ***SchUseStrongCrypto*** and ***SystemDefaultTlsVersions*** DWORDS do not exist, add them and Modify to set their values to ***1***
|
|
|
|
```yml 04 Tue Aug 20 2024 17:28:00 GMT-0700 (Mountain Standard Time)
|
|
Microsoft SQL Server ODBC Driver Version 10.00.14393
|
|
Data Source Name: SPCEPIWORLD-OLD
|
|
Data Source Description: SPCEPIWORLD
|
|
Server: MESSQLEC1.infineon.com\PROD1,53959
|
|
Database: SPCEPIWORLD
|
|
Language: (Default)
|
|
Translate Character Data: Yes
|
|
Log Long Running Queries: No
|
|
Log Driver Statistics: No
|
|
Use Regional Settings: No
|
|
Prepared Statements Option: Drop temporary procedures on disconnect
|
|
Use Failover Server: No
|
|
Use ANSI Quoted Identifiers: Yes
|
|
Use ANSI Null, Paddings and Warnings: Yes
|
|
Data Encryption: No
|
|
```
|
|
|
|
```yml 06 Tue Aug 20 2024 17:28:02 GMT-0700 (Mountain Standard Time)
|
|
Microsoft SQL Server ODBC Driver Version 10.00.17763
|
|
Data Source Name: SPCEPIWORLD
|
|
Data Source Description: InfinityQS SPC (Si)
|
|
Server: messqlec1.infineon.com\PROD1,53959
|
|
Database: SPCEPIWORLD
|
|
Language: (Default)
|
|
Translate Character Data: Yes
|
|
Log Long Running Queries: No
|
|
Log Driver Statistics: No
|
|
Use Regional Settings: No
|
|
Prepared Statements Option: Drop temporary procedures on disconnect
|
|
Use Failover Server: No
|
|
Use ANSI Quoted Identifiers: Yes
|
|
Use ANSI Null, Paddings and Warnings: Yes
|
|
Data Encryption: No
|
|
```
|
|
|
|
- mestsv02ec.infineon.com\TEST1,50572
|
|
- messqlec1.infineon.com\PROD1,53959
|
|
- messv03ech2.infineon.com\PROD1,53959
|