**RESOVLE RECOVERY PENDING ISSUE
alter database kp72021 set emergency
go
alter database kp72021 set single_user
go
dbcc checkdb (kp72021, repair_allow_data_loss) with all_errormsgs;
go
alter database kp72021 set multi_user
go
----------------------------------------------------------------------------------------------------------------------------------------------------------
ALTER DATABASE [KP72021] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;
----------------------------------------------------------------------------------------------------------------------------------------------------------
net user administrator /active:yes
----------------------------------------------------------------------------------------------------------------------------------------------------------
**CMD command
ipconfig

----------------------------------------------------------------------------------------------------------------------------------------------------------
setup.exe /ACTION=UNINSTALL (SQL SERVER)
----------------------------------------------------------------------------------------------------------------------------------------------------------
**INSTALL MSSSMS IF ERROR CODE 29506 WHILE INSTALLATION.
1. start command prompt with administrator
2. go to setup directory
3. run below command (SQLServerxx_SSMSEE.msi is setup file. file name may be diffrent)
   msiexec /i SQLServerxx_SSMSEE.msi /gf
----------------------------------------------------------------------------------------------------------------------------------------------------------
@ ECHO OFF
CD\
NET USE LPT1: /DELETE
NET USE LPT1: \\RayyanArai-Lap\EPSONLX310 /persistent:yes
CD\
CLS
----------------------------------------------------------------------------------------------------------------------------------------------------------
type d:\11.txt >prn
type d:\11.txt >LPT1
----------------------------------------------------------------------------------------------------------------------------------------------------------
**SQL SERVER CONFIGURATION not working (Error: cannot connect to wmi provider sql server)
Solution Link: https://learn.microsoft.com/en-us/troubleshoot/sql/tools/error-message-when-you-open-configuration-manager
Use the following procedure:

 1. The MOF file (sqlmgmproviderxpsp2up.mof) for your SQL instance is found in "%programfiles(x86)%\Microsoft SQL Server\nnn\Shared” folder. 
    Determine the location of the mofcomp file for your version using the following table as a reference:
Version				nn
Microsoft SQL Server 2019	150
Microsoft SQL Server 2017	140
Microsoft SQL Server 2016	130
Microsoft SQL Server 2014	120
Microsoft SQL Server 2012	100
Microsoft SQL Server 2008 R2	100
Microsoft SQL Server 2008	100
Microsoft SQL Server 2005	90

 2. Open an elevated command prompt, and change the directory to the folder location from Step1.

 3. Then type the following command, and then press ENTER:
    mofcomp "sqlmgmproviderxpsp2up.mof"
   (Note: For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\nnn\Shared folder.)

 4. After you run the mofcomp tool, restart the WMI service for the changes to take effect. To do this, open Services application, 
   select Windows Management Instrumentation, and then select Restart. You can also restart the WMI service by running the following PowerShell command 
   as administrator:
   PowerShell: Get-Service winmgmt | Restart-Service -Force
----------------------------------------------------------------------------------------------------------------------------------------------------------
**WINDOWS UPDATE DISABLE ISSUE (This issue encountered while using "Turn Windows Features On or Off")
1. Services.msc >> windows update >> enable and run servicee
2. Gpedit.msc >> administrative template >> windows components >> windows update ...
----------------------------------------------------------------------------------------------------------------------------------------------------------
**How to connect to a remote SQL Server
Link: https://www.sqlshack.com/how-to-connect-to-a-remote-sql-server/

1. Enabling TCP/IP protocol
  a) Open the SQL Server Configuration Manager in the Configuration Tools folder under the Microsoft SQL Server folder:
  b) From the SQL Server Network Configuration node, select the Protocols item for the appropriate SQL Server. 
     In the details pane, right click the TCP/IP item and select the Enable option
  c) In order for the changes take effect, from console pane, select the SQL Server Services and from the details pane, 
     right click the SQL Server (SQLEXPRESS) database engine instance and click the Restart option:
2. Right Click on TC/IP and put 1433 port for all.
3. Restart SQL Server (<<Instance Name>>) and SQL Server Browser services. 
4. Configuring Windows Firewall
  a) From the Control Panel choose Windows Firewall and click the Advanced settings or just type wf.msc in Search program and files from the Start menu:
  b) In the Windows Firewall with Advanced Security, click the Inbound Rules from the left pane, right click Inbound Rules 
    and select the New Rule or from the Actions pane click the New Rule:
 c) On which you will click, it’s up to you. In both case the New Inbound Rule Wizard will appear. Under the Rule Type choose Port and click the Next button:
 ------------------------------------------------------------------------------------------------------
Download Link
  1: Epson Printer Drivers: https://download.epson-biz.com/modules/dot/index.php?page=genre&pcat=1