FAQ / Troubleshooting
Common Computer Errors & Solutions – Windows, SQL, Printer, Network
Windows Problems
If using HDD:
Startup may take 3-10 minutes.
Replace HDD with SSD
👉 SSD makes PC startup in 15-30 seconds.
If C Drive is full, startup becomes slow.
Keep at least 20GB free in C Drive
Delete:
Temp files
Downloads junk
Old installers
run -> cleanmgr
Open Task Manager
Click Startup Apps
Disable unnecessary apps like:
Skype
Teams
Adobe Updater
Game Launchers
Torrent apps
Unused software
Repair Windows Files
sfc /scannow
DISM /Online /Cleanup-Image /RestoreHealth
Startup may take 3-10 minutes.
Replace HDD with SSD
👉 SSD makes PC startup in 15-30 seconds.
If C Drive is full, startup becomes slow.
Keep at least 20GB free in C Drive
Delete:
Temp files
Downloads junk
Old installers
run -> cleanmgr
Open Task Manager
Click Startup Apps
Disable unnecessary apps like:
Skype
Teams
Adobe Updater
Game Launchers
Torrent apps
Unused software
Repair Windows Files
sfc /scannow
DISM /Online /Cleanup-Image /RestoreHealth
SQL Server Errors
EXEC sp_resetstatus 'YourDatabaseName';
ALTER DATABASE [YourDatabaseName] SET EMERGENCY;
DBCC CHECKDB ('YourDatabaseName');
ALTER DATABASE [YourDatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CHECKDB ('YourDatabaseName', REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [YourDatabaseName] SET MULTI_USER;
ALTER DATABASE [YourDatabaseName] SET ONLINE;
ALTER DATABASE [YourDatabaseName] SET EMERGENCY;
DBCC CHECKDB ('YourDatabaseName');
ALTER DATABASE [YourDatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CHECKDB ('YourDatabaseName', REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE [YourDatabaseName] SET MULTI_USER;
ALTER DATABASE [YourDatabaseName] SET ONLINE;
Printer / Sharing Errors
Go to services
DCOM Server Process Launcher -> Seartup type -> Automatic -> Start ->
Apply -> OK
Remote Procedure Call (RPC) -> Seartup type -> Automatic -> Start ->
Apply -> OK
Remote Procedure Call (RPC) Locator -> Seartup type -> Automatic -> Start
-> Apply -> OK
Control Pannel -> Windows Firewall -> Allow an app or feature ->
Change setting -> Remote Assistance -> Public (Tik) -> Ok
msconfig -> Normal startup -> Ok
windows powershell (Run as admistrator) ->
ipconfig/flushsdns
ipconfig/renew
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RpcSs
-> Start -> 2 -> Ok
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DcomLaunch
-> Start -> 2 -> Ok
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RpcEptMapper
-> Start -> 2 -> Ok
DCOM Server Process Launcher -> Seartup type -> Automatic -> Start ->
Apply -> OK
Remote Procedure Call (RPC) -> Seartup type -> Automatic -> Start ->
Apply -> OK
Remote Procedure Call (RPC) Locator -> Seartup type -> Automatic -> Start
-> Apply -> OK
Control Pannel -> Windows Firewall -> Allow an app or feature ->
Change setting -> Remote Assistance -> Public (Tik) -> Ok
msconfig -> Normal startup -> Ok
windows powershell (Run as admistrator) ->
ipconfig/flushsdns
ipconfig/renew
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RpcSs
-> Start -> 2 -> Ok
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DcomLaunch
-> Start -> 2 -> Ok
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RpcEptMapper
-> Start -> 2 -> Ok
Networking Issues
Run the following commands at command prompt
netsh winsock reset
netsh winsock reset catalog
netsh int ip reset
ipconfig /release
ipconfig /flushdns
ipconfig /renew
exit
netsh winsock reset
netsh winsock reset catalog
netsh int ip reset
ipconfig /release
ipconfig /flushdns
ipconfig /renew
exit
Error Code and Fix
Cannot Set Default Printer With Error : 0x00000709
1. Press Win+R key to open RUN Type regedit.
2. go to HKEY_CURRENT_USER
3. Select Software
4. Select Microsoft
5. Select Windows NT
6. Select Current version
7. Select Windows & Right Click It
8. Go to Permission add everyone full control, Apply ok Exit.
Command Prompt Run as administrator
wmic printer get default,name
wmic printer where name="printer name" call setdefaultprinter
1. Press Win+R key to open RUN Type regedit.
2. go to HKEY_CURRENT_USER
3. Select Software
4. Select Microsoft
5. Select Windows NT
6. Select Current version
7. Select Windows & Right Click It
8. Go to Permission add everyone full control, Apply ok Exit.
Command Prompt Run as administrator
wmic printer get default,name
wmic printer where name="printer name" call setdefaultprinter
net stop wuauserv
net stop cryptSvc
net stop bits
net stop msiserver
ren C:\Windows\SoftwareDistribution SoftwareDistribution.old
ren C:\Windows\System32\catroot2 catroot2.old
net start wuauserv
net start cryptSvc
net start bits
net start msiserver
net stop cryptSvc
net stop bits
net stop msiserver
ren C:\Windows\SoftwareDistribution SoftwareDistribution.old
ren C:\Windows\System32\catroot2 catroot2.old
net start wuauserv
net start cryptSvc
net start bits
net start msiserver
Windows Cannot Connect to Printer - Error 0x0000011b
regedit
HKEY_LOCAL_MECHINE -> System -> CurrentControlSet -> Control -> Print
Right Click -> Create New DWORD (32-bit) Value -> RpcAuthnLevelPrivacyEnabled
Right Click -> Modify -> Value Data -> 0 -> ok
Services -> Print Spooler
Right Click -> Restart
regedit
HKEY_LOCAL_MECHINE -> System -> CurrentControlSet -> Control -> Print
Right Click -> Create New DWORD (32-bit) Value -> RpcAuthnLevelPrivacyEnabled
Right Click -> Modify -> Value Data -> 0 -> ok
Services -> Print Spooler
Right Click -> Restart