Category Archives: Uncategorized

Error Code: 0xC0002A1F, Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log for related errors.

Problem

I was attempting to add the WCF-SQL port to support an application and when applying settings and I got an error about no endpoints available.

Cause

Unknown. The environment was setup quite a while back and was never used. I suspect the lack of usage caused the issue.

Solution

Reboot the BizTalk server and the SQL server containing the SSO db.

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Error:

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'

Continue reading SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Determine DLLs hosted by Process

tasklist /m /fi "IMAGENAME eq wmiprvse.exe"

/M     [module]         Lists all tasks currently using the given
exe/dll name. If the module name is not
specified all loaded modules are displayed.

/FI    filter           Displays a set of tasks that match a
given criteria specified by the filter.

If you want DLL's hosted by any/all processes, remove the /FI filter parameter. In the example, we list dll's in use by the WMIPRVSE services.

Another example might be;

tasklist /m /fi "IMAGENAME eq cmd.exe"

You can filter on many different items, such as PID. Below we list dll's used by the SYSTEM process.

tasklist /m /fi "pid eq 4"

UDP Client Testing

There are many applications that use UDP ports in operation. When firewalls are in place, it can be difficult to determine if the problem connecting is due to the firewall, or simply the application.

The attached files can help with this.

udpserv.ps1 is a quick PowerShell script that will listen on a defined port for incoming UDP data and display the received data on the screen.

To use the udpserv.ps1 script;

  •  Change $port = 2020 to the port you want to test.
  • Open a PowerShell window.
  • Change to script download location
  • Execute script by typing ".\udpserv.ps1" and process enter. The script will block until complete.

The client script udpclient.ps1 will connect to the defined port on the defined server and will send 10 lines indicating the iteration of the UDP test.

To use the udpclient.ps1 script;

  • Change the $IP = "10.0.0.1" line to match the IP of the system running udpserv.ps1.
  • Change the [int] $Port = 2020 to match the port specified in the udpserv.ps1 script above.
  • Open a PowerShell window.
  • Change to script download location
  • Execute script by typing ".\udpclient.ps1" and process enter.

You can download the udptest.zip file which contains the client and server scripts.