Microsoft Office ImgMso Icon Downloads

Do you develop in Ms Office applications? Want Office ImgMso Icons to customize the Office ribbon? Here is the easiest to instal source of the Icons: https://www.microsoft.com/en-au/download/details.aspx?id=21103

EF Core Error: Unable to create a 'DbContext' of type ''. Mostly experienced when using Clean Architecture pattern in ASP.NET CORE projects. The resolution is very easy: Simply make sure that you explicitly indicate the Startup project. (Right-click on the Startup project, and select "Set as startup project"

Model Driven Power Apps tip: 💡 💡

"Quick create form" does not pop-up when invoked from a sub-grid on Main form, instead, Main form is shown. Soln: Include the table/entity in the App Designer; then uncheck "Show in Navigation"

Failed to load API definition (ASP.NET Core/Swagger)

While trying to view your API's with Swagger in ASP.NET Core, you might encounter this error .

Solution:

The problem can be caused by a number of reasons which include the following:

• Swagger configuration errors
• Classes with the same name but in different namespaces
• Public methods without the rest attribute (Get, Post, etc.)

Each one is solved differently and the Swagger Documentation might assist:

However, the easiest way to check original source of the error is to trace the Network messages of the Developer tools of your browser.

• Right-click on the page => Select Inspect
• Select the Network tab
• Select All (all output assessets will be displayed.
• Select the message that shows the error - it will display more tabs
• Select the Messages tab

You should see a detailed message indcating the source of the error.

Good luck!!

SQL Server Login Issues on new instance of the installation

After installing a new instance of Sql Server, especially the non-custom installation; you might experience different errors when trying to register/login with "sa" account or any other newly added Logins. Some of the errors inlclude:

1. Failed to connect to server DESKTOP-68S3Q92. (Microsoft.SqlServer.ConnectionInfo) Additional Information: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
2. Login failed for user
3. Other errors related to services and connections

There could be a number of reasons for these errors to occur, but in general, ensure you perform the following once you install a new instance of SQL Server:

1. NOTE: Password for installation-registered "sa" account is NULL (unless speciffied/changed by user)
2. By default, mixed mode authentication is disabled, thus only Windows Authentication is enabled. This means you may not be able to login with SQL Server Authentication after express-installation. To enable mixed mode authentication:
   Login with Windows Authentication
   Right-Click the SQL Server instance
   Select "Properties" =>Security
   Select "SQL Server and Windows Authentication mode (see illustration below)
   
   
3. Ensure the registered login account is enabled (Under Status page of the account registration page, select ENABLED under Login section)
4. Enable TCP/IP protocl in Sql Srver Configuration Manager.
   Open the Sql Server group of services from the Start menu; locate the "Sql Server xxxx Configuration Manager" => Right Click =>Run as Admninistrator
   Select "Sql Server Network Configuration" => Protocol for MSSQLSERVER (dbl-click)
   Locate "TCP/IP" and select "Enabled"
   RESTART THE Sql Server service (OR all 3 services: SQL Server; SQL Server Agent, SQL Server Browser) in the Control Panel Settings of your operating system
   
   

 

Please note: This is NOT from Microsot, but my own experiences as I work with SQL Server. Please comment feedback below.