IT Technical Support for Developers

Error 10054,
Cannot connect remotely to SQL Server Express Win 11, A network-related or instance-specific error

ADDITIONAL INFORMATION
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Got the same issue on a Windows 11 computer trying to connect to an old SQL 2005 DB. It looks like some ciphers are disabled on Windows 11 and prevent the connection with the Database.

Solution

In Powershell (as admin) after running the following command, I could connect to the DB. Hope this helps.

Enable-TlsCipherSuite -Name "TLS_RSA_WITH_3DES_EDE_CBC_SHA"

Copy and paste the above command in powershell, it will work for you.

Key Search

sql server error 10054 windows 11
mssqlserver-10054-database-engine-error
windows 11 accessing sqlexpress error 10054
error 10054 an existing connection was forcibly closed by the remote host
sql server error 10054 pre-login handshake
SQL Server not connected after windows 11 update

Microsoft Has fixed all the issue related to Printer Sharing

September 14, 2021—KB5005565 (OS Builds 19041.1237, 19042.1237, and 19043.1237)
Release Date: 9/14/2021
Version: OS Builds 19041.1237, 19042.1237, and 19043.1237
Windows 10 2004. 20H2 and 21H1KB2310138

Here is how to fix Printer Error 0x0000011b in Windows 10

Step 1:In Server PC: Check for TCP/IP => Inernet Protocol Version 4

Step 2: Configure Manual IP instead of Automatically IP Assign.

Step 3: Check with your Printer server Name, (Compurter or PC Name)
It should not have a long name or special characters or Numbers alone,
set relavent name for it.
Allow server machine to use filesharing with itself via the DNS Alias

Step 4: Check / Configure Network Sharing Rights for the printer (and Update Printer Driver).

Step 5: in Client PC using run command type "\\IP number of Printer Server"

Step 6: now you are able to view all the shared folders and printers,
double click on the printer icon to Install the printer driver in client PC.

Step 7: Still you are getting the same error, do followings
a. Create a new user with Administrative rights in "Server" Where you are conneted the Printer

b. Connect the "Server" with new user with password, in client where do you want to access the printer in sharring mode.

after this try the step 6.

Microsoft will allow device manufacturers to disable the TPM requirement on their version of Windows 11 – you'll be doing the same here:

If you have a computer with unsupported hardware, you may still be able to upgrade to Windows 11

You can upgrade an incompatible computer to Windows 11 at your own risk, and here are two methods to complete the task.

Method 1 to upgrade Windows 11 on unsupported hardware

Step 1: Download Windows 10ISO 64 bit From Microsoft site.

Step 2: Download Windows 11 64 bit From Microsoft site

Step 3: Copy file “install.wim” from source folder Of windows 11 setup folder to source folder of windows 10 setup folder.

Step 4: Click Setup.Exe from windows 10 setup folder

Method 2 to upgrade Windows 11 on unsupported hardware

Click on Start and type ‘regedit’ and press enter.

Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\Setup\MoSetup
Under MoSetup,
right click on the right plane and then choos New ->DWORD (32-Bit) value

Enter following details and click Ok

Value name: AllowUpgradesWithUnsupportedTPMOrCPU

Value date: 1

Base: Hexadecimal

Once this is done, download the ISO file from the official Microsoft page,
open it in the File explorer and double-click on Setup to start the installation process.

It’s a common error that users face if a third-party printer driver is installed on the print server. Fortunately, you can fix this by following some simple steps.

Printer Error 0x00000040 can be fixed by following some simple steps.

What causes Operation could not be completed (error 0x00000040)?

Windows 10/11 doesn’t allow users to install a third-party printer driver on the print server. You need to change the Group Policy settings or tweak the Registry to resolve the issue. The other reasons for this error could be:

1.Point and Print Restrictions policy
2.Pending print jobs in Print Spooler
3.Printer Driver issues.

Run Printer Troubleshooter

1. Press Windows Key + I to open Settings.
2. Scroll down and select Troubleshoot > Other Troubleshooters.
3. Click on Run beside Printer.
4. Once the process is complete, restart your device to see if the printer error has been resolved.

Modify Group Policy Settings

Kernel-mode drivers operate in kernel mode and have unlimited access to hardware and memory. But sometimes, the kernel-mode driver’s policy can malfunction due to corrupted drivers. Disable the policy and check if the error is fixed.

Disable the Point and Print using Registry Editor

1. Press the Windows key + R to open the Run dialog box.
2. Type regedit and hit Enter.
3. Navigate to the following path :HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows NT\Printers\PointAndPrint

4. right-click on InForest and select Modify.
5. Now enter the Value data as 0 and click Ok to save the changes.
6. In the same way, change the value data of Restricted and TrustedServers to 0.
7. Close the Registry Editor and restart your computer.

Update Printer driver

Update your Printer driver and see. Keeping your drivers up-to-date is very important. Although Optional Updates do update some of the drivers, some require you to download the driver manually from the manufacturer’s website.