Map a drive in SQL SERVER 2014

 

Why map a drive in SQL server 2014?

1.Easy to make a backup on remote Nas server or Synology.

2.Easy to restore database.

3.keep database on NAS or Synology.

After we run Query below  you need to restart service SQL MSSQL in Service management.

Then log in  SQL Server 2014 with  sa user.Then you will see the drive that you map.

Map drive in sql server 2014

Use Master

GO

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

GO

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE WITH OVERRIDE

GO

EXEC xp_cmdshell 'net use Z: \\10.0.0.10\e /user:domain\userName "password"'

EXEC XP_CMDSHELL 'net use Z:  \\10.11.0.10\database\SQL /USER:admin  "123456789"';

EXEC XP_CMDSHELL 'Dir Z:'

        Disable map network drive in sql server

EXEC XP_CMDSHELL 'net use Z: /delete'

How to fix database error in sql 2014 with DBCC

 

first we need to use below command to check what table error.

DBCC CHECKDB (UAT) WITH NO_INFOMSGS, ALL_ERRORMSGS

Next  we will see which table got error then we need to change database to single user mode in database properties or can use command below:

ALTER DATABASE UAT

SET SINGLE_USER;

 Then time to repair table :

DBCC CHECKTABLE('AT_INOUT', REPAIR_ALLOW_DATA_LOSS)

And then after repair all table error we need to use the first command again to make sure all table was repaired.

DBCC CHECKDB (UAT) WITH NO_INFOMSGS, ALL_ERRORMSGS

Then we need to check log database is it big or not.? if it big we can shrink it by below guide:

Right click -->Task-->Shrink-->File-->then click OK.

The L2TP Connection Attempt Failed Because the Security Layer Encountered a Processing Error Fix

 Are you using a VPN (Virtual Private Network) to access certain websites? Then, you may come across an error “the L2TP connection attempt failed because the security layer encountered a processing error” when you try to make a VPN connection. L2TP is a well-known connection used for encryption and protection of VPN. Some of the reasons why you may see this error are when the Microsoft CHAP v2 protocol is disabled or when the PPP settings are not configures properly. However, the good news is, the “the L2TP connection attempt failed because the security layer encountered a processing error” issue can be resolved. Let’s see how.

Method 1: Uninstall latest security updates

Recent Update may have caused this issue while breaking your VPN. for fixing this, you can uninstall your recent update.

1 – Search APPWIZ.CPL in Windows search box and click on it.

 

2 – Now, Uninstall most recent Microsoft Windows update by right clicking on the most recent Microsoft Windows update and then clicking on Uninstall.

kb:5009543 for Windows 10

kb:5009566 for Windows 11

 

3 –Restart your computer

Method 2: Turn on the Microsoft CHAP v2 Protocol

 

Step 1: Right-click on Start menu and select Run to open the Run command window.

 

 

Step 2: In the Run command search box, type ncpa.cpl and hit Enter to open the Network Connections window.

 

 

Step 3: In the Network Connections window, right-click on your VPN connection and select Properties.

 

 

Step 4: In the VPN Properties dialogue box, go to the Security tab and select the radio button next to Allow these protocols option.

Now, make sure that the box next to Microsoft CHAP Version 2 (MS-CHAP v2) is checked.

Press OK to save changes and exit.

 

Now, try connecting to the VPN and you should not experience the “L2TP connection attempt failed” error again.

 

Method 3: Turn on the LCP Protocol Extensions

 

Step 1: Press the Win + R keys together on your keyboard to open the Run command box.

Step 2: Now, write ncpa.cpl in the Run command search field and press OK.

 

 

Step 3: In the Network Connections window that opens, locate the VPN, right-click on it and select Properties.

 

 

Step 4: This time, go to the Options tab in the VPN Properties window and click on the PPP Settings button.

 

 

Step 5: Next, in the PPP Settings dialogue box, check the box next to Enable LCP extensions.

Press OK to save the changes and exit.

 

 

You can now try connecting the VPN and it should get connected without showing the error.

Method 4: By Restarting IPSec Service

 

Step 1: Press the Win + X hotkey on your keyboard and select Run to open the Run command.

 

 

Step 2: In the Run command window, type services.msc and hit Enter.

 

 

Step 3:This will open the Service manager window. Go to the right side of the Service manager and under the Name column, look for IKE and AuthIP IPSec Keying Modules.

If it shows running, right-click on it and select Restart.

 

 

Step 4: Now, double-click on it and in the Properties window, under the General tab, go to the Startup type section.

Set the field to Automatic.

Press Apply and then OK to save changes and exit.

 

 

Step 5: Repeat Steps 3 and 4 for IPSec Policy Agent service.

 

 

Now, restart your VPN connection and it should start working fine now.

 

Method 5: By Reinstalling the Network Adapter

 

Step 1: Right-click on Start menu and select Run. This will open the Run command window.

 

 

Step 2: In the Run command box, type devmgmt.msc and hit Enter.

 

 

Step 3: In the Device Manager window that opens, navigate to Network adapters and expand the section.

Locate the network adapter for your VPN, right-click on it and select Uninstall device.

 

 

Step 4: In the prompt that appears, click on the Uninstall button to confirm the action.

 

Once uninstalled, restart your PC. The device gets reinstalled automatically and gets reset to its default settings.

 

You must also check that proper certificate is being used for both the client and the server. Make sure that PSK (Pre Shared Key) if used, is the same and is configured for both the client and the VPN server.

About Vaccine

 https://www.nytimes.com/interactive/2020/health/sinopharm-covid-19-vaccine.htm

https://www.bbc.com/news/health-55302595

https://www.reuters.com/article/us-health-coronavirus-sinopharm-peru-idUSKBN29V2FD

                                      

Sinopharm-A Vaccine Made From Coronaviruses-BBIBP-CorV works by teaching the immune system to make antibodies against the SARS-CoV-2 coronavirus. The antibodies attach to viral proteins, such as the so-called spike proteins that stud its surface.

   Astrazeneca-It is made from a weakened version of a common cold virus (known as an adenovirus) from chimpanzees. It has been modified to look more like coronavirus - although it can't cause illness.Once injected, it teaches the body's immune system how to fight the real virus, should it need to.

Vietnam overlooks Chinese Covid-19 vaccines for AstraZeneca shots

 

Vietnam is the only country in the ASEAN bloc that has yet to publicly vouch for the use of China-made vaccines.

Vietnam, which recently began its inoculation drive, has overlooked China-made vaccines, opting for the vaccine developed by British-Swedish pharmaceutical giant AstraZeneca instead.

According to South China Morning Post (SCMP), the programme will be initially conducted in 18 hospitals treating Covid-19 patients and in areas with higher infection numbers, according to Vietnam health minister Nguyen Thanh Long.

China's Sinopharm has said the vaccine made by its Wuhan subsidiary has a 72.5 per cent efficacy, while the Beijing-based Sinovac's vaccine was found to be 50.6 per cent effective, one of the lowest efficacy rates as compared to any existing coronavirus vaccine.

"Besides what's available in the public health care system, the next option for me would be the vaccine from Russia, then the US, then the one from China if there is no other choice," said Hanoi resident Hoang Cam Hang.

Hang's stance reflects Vietnam's move to steer clear of Chinese vaccines, despite Beijing's pledge to make vaccines a global public good and offer priority access to developing countries, reported SCMP.

• 
  

  
  

• 
  

  
  

Vietnam, which has reported one of the lowest total Covid-19 infections, is the only country in the Association of Southeast Asian Nations (ASEAN) bloc that has yet to publicly vouch for the use of China-made vaccines.

China's vaccine diplomacy had failed with Vietnam mainly because of anti-China sentiments among the public, said Nguyen Phuong Linh, associate director with global consultancy firm Control Risks.

"From the beginning of the Covid-19 pandemic, the virus has been widely reported in Vietnam as originally coming from China. Since then, the anti-China sentiments, which were already strong, have shown no sign of weakening," said Linh.

Furthermore, Huong Le Thu, a senior analyst, said China did not come to Vietnam with offers of personal protective equipment (PPE) as it had to other Southeast Asian neighbours, which depicted a level of politicisation in Beijing's Covid-19 diplomacy.

According to SCMP, Vietnam and China have always had an uneasy diplomatic relationship, with hostile sentiments being fuelled by an ongoing territorial dispute in the South China Sea between China, Vietnam and three other ASEAN countries, along with Beijing's activities on the Mekong River that have affected ASEAN countries.

Bilateral tensions between both sides has resurfaced as China's Foreign Minister Wang Yi visited nine ASEAN states over few months except Vietnam.

Meanwhile, Vietnam aims to inoculate 80 per cent of its population or about 72 million people to achieve herd immunity.

ref:

https://www.hindustantimes.com/world-news/vietnam-overlooks-chinese-covid-19-vaccines-for-astrazeneca-shots-101615469354355.html

window 10 experience with domain server 2012

 As my experience window 10 .

Clone window 10 for join the domain you need to know some point .

1.sysprep (c:\windows\system32\sysprep)

2.computer name (computer properties)

3.ip address 

Share printer on window 10 as the Server Printer.

you need to edit regedit.

window+run->regedit

HKEY_CURRENT_USER>Software>Microsoft>Window NT> Currentversion>Windows.

Right-Click on Windows folder and select Permissions.After add Everyone  user to full control.

Clone window 10

For clone window 10 you can use many ways as your experience like 

1. Norton Ghost
2. Partition Assistant Technical.
3. AOMEI software.

https://t.me/c/1151998416/20

Automaticall lock computer after inactivity

Automatically Lock computer after inactivity

https://www.thewindowsclub.com/lock-computer-inactivity-windows-10

You have 5 ways using which you can auto-lock your Windows 10 computer after inactivity:

1. Using built-in Dynamic Lock
2. Using Screensaver settings
3. Using Group Policy
4. Using the Registry method
5. Using a third-party tool.

Let us take a look at these methods.1] Using built-in Dynamic Lock

Dynamic Lock helps you lock Windows 10 automatically when you step away. It locks down the Windows 10 computer automatically by using your mobile. But your mobile phone has to be connected all the time to your computer via Bluetooth. In other words, when you step away from your computer with your mobile, your computer will lock itself down. Butt may not work properly if your computer doesn’t support the Windows Hello function.

2] Using Screensaver settings

Well, if you would like to do this, the procedure is pretty simple and hasn’t changed since the last few iterations of Windows OS.

To make your Windows 10 computer ask for a password after a period of inactivity, type screen saver in the taskbar search and click on the Change screen saver result which appears.

The Screen Saver Settings box will open.

Here, under Wait – minutes – On resume, display logon screen settings, select the time after which you want Windows to ask for a password, and check the On resume, display logon screen box.

Click on Apply and exit.

If you have set the time at 10, then after 10 minutes of inactivity, you will be asked to enter your password, to be able to access your PC.

If you do not want a screen saver to be displayed, select None. If you wish to display it, you can select one. This setting is just above the “Wait …” setting.Using Group Policy

Open Group Policy Editor and navigate to the following setting:

Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options.

Double-click on Interactive Logon: Machine inactivity limit setting.

Windows notices inactivity of a logon session, and if the amount of inactive time exceeds the inactivity limit, then the screen saver will run, locking the session.

Give it a value between 1 and 599940 seconds, save, and exit.

4] Using the Registry method

Open Registry Editor and navigate to the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

Create a new DWORD value, name it InactivityTimeoutSecs, select the Decimal option, and enter the number of seconds (between 1 and 599940) in the field.

Click OK and exit.

5]  Using a third-party tool

Smart PC Locker Pro is a free tool that lets you easily lock your Windows computer. It offers several configuration options.