EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

The certificate chain was issued by an authority that is not trusted

Issue: Database Connection String: Encrypt=True;TrustServerCertificate=False If you recently upgraded your SQL Server Native Client 11.0 (Provider=SQLNCLI11) application to use Microsoft OLE DB Driver 19 for SQL Server (Provider=MSOLEDBSQL19), you might receive error messages that resemble the following messages: [Microsoft OLE DB Driver 19 for SQL Server]: Client unable to establish connection [Microsoft OLE DB Driver... » read more

0
Read
echiang
Create Self-Signed Certificate

Open PowerShell as administrator Run the following command: C:\Users\user01> New-SelfSignedCertificate -Subject “CN=OrgCert1234” -CertStoreLocation “cert:\LocalMachine\My” Now, what we have to do is obtain the private key certificate file to be able to upload it to Azure: Press the windows key Type Manage Computer Certificates and press Enter Go to Personal (on the left), then Certificates Double-click on the... » read more

0
Read
echiang
Deployment error from new Development Computer- HTTP Error 500.30 – ASP.NET Core app failed to start due to certificate authentication issue

Issue: Getting the following error message after deploying a Blazor web app from a new development computer Resolution: Update “Self Signed Certificate” to Blazor web app and web app server config. Need to create a new self signed certificate on development computer, upload to Azure web app. Then update the self signed certificate section of... » read more

0
Read
echiang
Blazor App Deployment Error on New Development Computer – Failed to find a valid digest in the ‘integrity’ attribute for resource

Issue: Getting the following error when trying to deploy a Blazor Web App on a new development computer. Failed to find a valid digest in the 'integrity' attribute for resource 'https://xxxxx.azurewebsites.net/_framework/Newtonsoft.Json.dll' with computed SHA-256 integrity 'xxxxx'. The resource has been blocked. Unknown error occurred while trying to verify integrity. Uncaught (in promise) Error: A listener... » read more

0
Read
echiang
Create a new local repository using TortoiseGit

In Windows folder explorer, right click on folder, TortoiseGit -> Git Create repository here… Note: Create an empty folder, clone it to DevOps project, and then add files to the empty folder. Create .gitignore file to ignore folders and files.

0
Read
echiang
Add existing Visual Studio project to existing DevOps Repo.

Current Setup An existing Visual Studio project without any source control links. An existing DevOps project with default Repo Step 1 – Open up existing Visual Studio project and create a local Git Repo Create a new local Git repo for your Visual Studio solution, by right-clicking the solution name in Solution Explorer, and then selecting Create... » read more

0
Read
echiang
The “ZipDeployTask” task was not given a value for the required parameter “DeploymentPassword”.

Error: Get the following error when trying to Publish a Azure Function project to Azure site… The “ZipDeployTask” task was not given a value for the required parameter “DeploymentPassword”. Fix: 1. Right click my project and select Publish.2. Select the appropriate publishing profile.3. In the Summary section bellow select the “Edit Password” button (indicated by... » read more

0
Read
echiang
Azure Functions time zone issue

Fix: Select Configuration option in your Function App Add new “application settings” Fill the fields with the following value… Name: WEBSITE_TIME_ZONEValue: Pacific Standard Time Sources: https://www.serverlessnotes.com/docs/azure-functions-time-zone-issue

0
Read
echiang
VS Code (Visual Studio Code)

https://code.visualstudio.com/ Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with built-in support for JavaScript, TypeScript and Node.js and has a rich ecosystem of extensions for other languages and runtimes (such as C++, C#, Java, Python, PHP, Go,... » read more

0
Read
echiang