Explore information related to 17


Windows server 2016 vss error 12347 - Fix it Now ?


This article covers methods to resolve Windows server 2016 vss error 12347. Basically, 'Windows server 2016 vss error 12347' occurs when the Backup of Shadow Copy Component Fails. This usually happens when the registry Volume Shadow Copy Service (VSS) writer did not respond to a query from the VSS service.

To resolve this Windows error, simply Reboot the Server where the problem exists.

Read More



SQL Server Error 19471: Create failed for Availability Group Listener


This article covers methods to fix SQL Server Error 19471. Basically,  "SQL Server Error 19471" can happen while configuring Always On Availability Group again on the database server.


To fix SQL Server Error 19471:

  • Create a Client Access Point (CAP) for the AOAG listener in Failover Cluster Manager.
  • Bring CAP Online.
  • Repair the CAP, if it is not coming ONLINE.
  • Once CAP comes online, remove it from failover cluster manager.
  • Add listener to AOAG in SSMS.

Read More



DirectAdmin PhpMyAdmin error 500 - Fix it Now ?


This article covers methods to resolve DirectAdmin PhpMyAdmin error 500. This error happens as a result of a number of reasons that include PHP settings, modsecurity rules and so on.


To resolve this error, In the library is /usr/share/phpmyadmin/libraries/sql.lib.php,

You need to modify the file:

From && ($analyzed_sql_results['select_expr'][0] == '*')))

to && ($analyzed_sql_results['select_expr'][0] == '*'))

Read More



SQL Error 17051 – Server Evaluation Edition to Enterprise Edition


This article covers method to resolve SQL Error 17051.

This SQL error  sometimes happens when the SQL Server Evaluation period has expired.

To fix Microsoft SQL Server Management Studio error:
1. Now as per the error message you open the Event Viewer and see that the Event with ID 17051, which shows SQL Server Evaluation period has expired under Details section.
2. Now, you recall that the Instance that you had installed was under Evaluation of 180 days, because you didn’t applied any Product Key. So, now how can you make it live again? All you need is a Product key of SQL Server and some clicks.
3. Open the SQL Server Installation Center and click on Maintenance link, and then click on Edition Upgrade.
4. Now on the Upgrade window Click Next and you will reach the Product Key page, apply the Key and click Next.
5. On the Select Instance page, select the SQL Instance that you want to fix and Click next. It will take some time and finally you will see a final window and click Upgrade.
6. Finally you will see the successful window, click on Close button.

Also, you can use following command line installation option to skip this specific rule to allow the upgrade process to complete successfully:
a) Open Command Prompt (CMD)
b) Go to the folder where SQL Server Setup, setup.exe file is located (like C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012\)
c) Apply following command:

setup.exe /q /ACTION=editionupgrade /InstanceName=MSSQLSERVER /PID=<appropriatePid> /SkipRules= Engine_SqlEngineHealthCheck

The <appropriatePid> should be the 25 digit Key.
The above command line runs SQL Server setup in silent mode.
Now Restart the SQL Server Service for this Instance, and you will see it running fine.
Finally, go back to SSMS and now you can connect to the SQL Instance.

Read More



The Windows Installer Service could not be accessed error - Fix it now


This article covers methods to resolve the Windows #Installer Service could not be accessed #error which occurs while we try to install a program in Windows or when you are running Windows in safe mode.

Windows Installer popups may be caused by Windows configuration issues, by Windows Update prompting you to install updates or by malware.


To fix #Windows installer error:

1. Click Start. , type services.

2. Right-click Windows Installer, and then click Properties.

3. If the Startup type box is set to Disabled, change it to Manual.

4. Click OK to close the Properties window.

5. Right-click the Windows Installer service, and then click Start.

6. Try to install or to uninstall again.


To fix error 1719 windows installer service could not be accessed:

1. Start the Windows Installer Service.

2. Stop and then Restart Windows Installer Service.

3. Reset the settings of Windows Installer Service in the registry.


To to Disable Windows Installer:

1. Log into Windows. Click the "Start" button.

2. Double-Click "Group Policy" in the left pane.

3. Expand the tree in the left side of the pane, "Local Computer Policy\Computer Configuration\Administrative Templates\Windows Components\Window Installer".

4. Double click "Disable Windows Installer.


To enable Windows Installer in Safe Mode:

1. Press Windows + R, type cmd, and press Ctrl + Shift + Enter to run CMD as administrator. 

2. Type the command net start msiserver in Command Prompt window, and press Enter to enable Windows Installer in Safe Mode in Windows 10.

Read More



MongoDB error network is unreachable - Fix it now


This article covers methods to resolve the error 'MongoDB error network is unreachable' which can occur due to many reasons that include network issues, if the mongo server is not started, and so on.

To resolve this #MongoDB #error:
1. On Ubuntu server, to open mongo shell run:

$ mongo

2. Inside mongo shell, type following command to create new a admin user.

> use admin;
> db.createUser({user:"admin", pwd:"password", roles:[{ role: "root", db: "admin" }]});

3. By default mongodb is configured to allow connections only from localhost(IP 127.0.0.1).
We need to allow remote connections from any ip address. The following change should only be done in your development server. Open up etc/mongod.conf file and do the following change.

# network interfaces
net:
port: 27017
bindIp: 0.0.0.0   #default value is 127.0.0.1


Also in the same mongod.conf file uncomment security option and add authorization option as shown below:

security:
authorization: enabled    


4. Save and exit the mongod.conf file and restart mongodb server:

$ sudo servcie mongod restart

Read More



Windows Error Code 17


This article will guide you on different methods to tackle Windows Error Code 17 which causes Windows #program to crash, slow Windows performance and periodic system freeze.

#Windows error code 17 is a standard device driver error. This error can be attributed to either a corrupt driver or an outdated driver. To resolve, Do a search for your device #driver and see if the newest version available was released since you bought your hardware. If it was, you probably need to download the newest version.

To Fix #Spotify Could Not Be Started #Error Code 17:

1. Open the “Firewall & network protection” via Search bar;

2. Click on “Allow an app through firewall”;

3. Press “Change settings”;

4. In the list of programs, find Spotify and check the boxes for it under the Private and Public columns. 

If it's absent here, click on the “Allow another app …” button and add it manually.

Read More



SQL server error 1326 Steps to fix it


This article will guide you on methods to resolve SQL server error 1326 which occurs due to the IIS Service not having any rights to use the named pipe.

If the SQL server resides on a separate server from IIS, then the IUSR_machinename account needs to be validated on the Windows NT server that SQL resides on.

#SQL #SERVER – Fix : Error : 1326 Cannot connect to #Database Server Error: 40 – Could not open a connection to SQL Server.

Now if SQL Server can be connected perfectly from #local system, but cannot be connected from a remote system, in that case firewall on the server where SQL Server is installed can be issued.

Follow instructions below to fix the issue:

1. Go to control panel >> #Firewall Settings >> Add SQL Server’s Port to Exception List.

2. Now try to connect to SQL Server again. It will allow you to connect to the server successfully.

Read More



SQL Server and create a database on Ubuntu How to install


This article will guide you on how to #install MS SQL on #Ubuntu Server 18.04. 

To Install #Microsoft SQL Server 2017:

1. Visit Microsoft's official SQL Server 2017 download page.

2. Select the edition you want to #download. 

3. Click Download now below your selected edition. 

4. The wizard will prompt you to select an installation type. 

5. On the next page, select a directory for the installation folder.

To connect to the SQL Server using #SSMS:

i. From the Connect menu under the Object Explorer, choose the #Database Engine.

ii. Then, enter the information for the Server name (localhost), Authentication (SQL Server Authentication), and password for the sa user.

iii. Click the Connect button to connect to the SQL Server.

Read More



SQL server error 17 Steps to fix it


This article will guide you on the steps to fix 'SQL Server does not exist or access denied' error which occurs when the computer running #Microsoft #SQL Server is not reachable.

Read More



Microsoft SQL Server Error 701


This article will guide you on the steps to resolve #SQL Server #Memory pressure or insufficient #memory issue which can happen due to huge data load or other memory-intensive #operations that lead to a 701 #error in the SQL server.

Read More



SQL error Msg 4341


This guide will help you to fix SQL error Msg 4341 which can occurs during a database recovering process to a point in time. 

Read More



SQL Server Error 17 sqlstate 01000


This error can be observed when trying to connect to the SQL Server with the Login information.

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com






Focus on your business, not your servers.

Click Here to Learn More