Explore information related to microsoft


XenApp Error 10060 - Fix it Now ?


This article covers method to fix XenApp Error 10060 for our customers. Users trying to launch the desktop enabling the "HDX Adaptive Transport" policy set to Diagnostic and it fails with an error: 'Unable to connect to the server. Contact your system administrator with the following error: There is no Citrix XenApp server configured on the specified address. (Socket Error 10060)'.

To fix this error, Ensure UDP 1494 and 2598 ports open on the VDA I connect back to the Citrix desktop, run CtxSession /v and receive confirmation that we are now using UDP 2598. This means that HDX Enlightened Data Transport is being used with Session Reliability. You can also check Director and note the protocol will be set as UDP.

Read More



'http error 401.3 – unauthorized' in IIS - Fix it Now ?


This article covers methods to fix 'http error 401.3 – unauthorized' in IIS. This error appears when the user account under which the IIS service runs does not have the required permissions to access and serve web server content.

Assuming Anonymous Authentication is Enabled and the error message persists, edit the Anonymous Authentication setting. 

Read More



Time Based Temporary Group Membership in Active Directory on Windows


Basically, Temporary Group Membership (Time Based) is the version of Active Directory in Windows Server 2016 introduces an interesting feature that allows you to temporarily add a user to an AD security group. In order to use the Temporary Group Membership, you need to enable the Privileged Access Management Feature in your Active Directory forest. Like with AD Recycle Bin (which allows you to recover deleted objects), you cannot disable PAM after it has been enabled.

Read More



Add Windows Disk Usage Checks In Nagios


This article covers how to monitor additional drives on a Windows client. To install Nagios monitoring agent, NSClient++, on a target Microsoft Windows desktop or server for the purposes of monitoring that machine with Nagios XI. This allows organizations to monitor vital metrics and ensure that a specific Windows desktop machine or server is functioning properly.


To access CCM:

  • When hovering the Configure button in the top menu bar you can select Core Config Manager.
  • On the Configure tab you can select Core Config Manager from the left pane or from the main screen.

Read More



Setting remote desktop drain mode on a Windows Server RDS host


This article covers how to set remote desktop drain mode on a Windows Server RDS host. Basically, setting remote desktop drain mode on a Windows Server RDS host can be easily performed with PowerShell. The Drain Mode is used when a server administrator needs to maintain a server (install Windows updates, configure or update apps) without affecting the availability of the entire RDS farm. 

When you set the RDS host in drain mode state, the RDS host can no longer accept new connections but existing sessions continue working until users log out. You can monitor the status of the RDS host in Horizon Administrator.


To remove a Remote Desktop Session Host (Uninstall the RD Session Host Role Service) :

  • Open Server Manager.
  • In the left pane, expand Roles.
  • Right-click Remote Desktop Services, and then click Remove Role Services.
  • On the Select Role Services page, clear the Remote Desktop Session Host check box, and then click Next.
  • On the Confirm Removal Selections page, click Remove.

Read More



Export config database in Nagios - How to do it ?


This article covers how to export config database in Nagios. Basically, Manual exports are useful when debugging configuration problems, including failures of Nagios XI to apply new configuration changes.

Read More



Monitor Website Defacement With Nagios XI - How to do it ?


This article covers how to Monitor Website Defacement With Nagios. Basically, Nagios XI can monitor for potential Website defacement using the Website Defacement monitoring wizard. 


Benefits of Website Defacement Detection:

  • Fast detection of security breaches.
  • Fast detection of outages and website hijacking.
  • Increased website and web application availability.
  • Capacity planning information for future web server and application upgrades.

Read More



IIS Manager: Could not connect to the specified computer - Fix it Now ?


This article covers methods to resolve the IIS Manager error "Could not connect to the specified computer". 


To install and configure Microsoft Windows Internet Information Services:

  • Select: Manage / Add Roles and Features.
  • Select "Next" until you get to Server Roles. Scroll down and open Web Server (IIS) / Management Tools.
  • Select "Management Service".
  • Select "Next" and "Install".
  • Once installation completes, open services. If you already had services open, use refresh to add it to your list. Scroll down to Web Management Service. You will notice it is installed, but not started. It is also set to manual, so it will not start on reboot either. You need to change both of these so the service will run now and will run anytime the server is rebooted. Open the properties.
  • Change the Startup type to "Automatic". Do not start the service yet as you will not be able to configure the service while it is running.
  • Launch IIS, open Management Service.
  • Configure the Web Management Service, then apply your changes and start the service.


How to configure Microsoft IIS ?

  • Enable remote management.
  • Use windows credentials only.
  • Deny access to all except your approved IP addresses.  Use IP address ranges only when you control the entire range.
  • Use your server’s certificate if you have one configured. (Optional).
  • Change the port from the default to something else if the server is accessible from the Internet. (Optional).
  • Now you will be able to remotely manage IIS from any IP address you granted access.

Read More



Windows Cannot Find Microsoft Software License Terms - Fix it Now ?


This article covers methods to fix Windows error, Cannot Find Microsoft Software License Terms. Basically, this error happens when trying to perform a clean install of Windows Server 2016 on a new Hyper-V virtual machine. A common cause for Windows cannot find the Microsoft license software terms can be your BIOS. Sometimes certain BIOS settings can interfere with your system and prevent Windows from installing.


To fix this Windows issue, users are suggesting entering BIOS and restore the default settings.

This is fairly simple to do, but if you don't know how to do it properly, we advise you to check your motherboard manual for detailed instructions. 

After restoring the default settings, try to install Windows again.


Another method to fix Windows cannot find the Microsoft license software terms message, is to,

Disconnect the installation media during the installation:

Follow the installation steps until you reach the Install Now screen.

Disconnect your installation media and click the Install Now button.

Continue the installation as you would do normally.

Once the setup is ready to start copying files, it will ask you to reconnect your installation media, so be sure to do so.

After you connect the installation media, follow the instructions on the screen to complete the installation.

Read More



Enable ABE on Windows Server - How to do it ?


This article covers how to Enable ABE on Windows Server. By default, when a user opens some shared network folder, SMB displays a full list of files and folders on it. Of course, it happens only if the user has permission to access the share. Access Based Enumeration (ABE) allows hiding the specific files and folders for a user who don’t have access permission.

Access Based Enumeration is available on the Windows platform since Windows Server 2003 SP1, and helps to prevent users from seeing files and folders.

ABE is enabled for each folder individually. To configure ABE, open Server Manager console, and select role File and Storage Services.


Main ABE features:

1. ABE controls only the list of the contents in a shared folder. It does not hide the list of shared folders from the users. Therefore, when a user connects to the server, he will see all shared folders. If you need to create a hidden share, you can simply add the character $ to its name, for example, ShareName$;

2. ABE doesn't work when the user logged locally or when connecting via RDP;

3. Members of the local Administrators group always see the full list of the folder contents.

Read More



Windows Update Stuck At "Downloading 0%" On Server 2016 – Fix it Now ?


This article covers different methods of fixing Windows 10 Update not working, stuck at downloading 0%. 


To fix this Windows stuck at downloading 0% error:

  • Delete the deployment package.
  • Delete the software update group if exists.
  • Download once again the update and create a new software update group.
  • Create a new deployment package and distribute the content.
  • Refresh the SCCM policy on your SCCM clients.
  • Wait a few minutes and confirm if the Windows Update is installed.

Read More



Hardening Windows Using Microsoft Security Baseline


This article covers Hardening Windows Using Microsoft Security Baseline.

Every organization faces security threats. However, the types of security threats that are of most concern to one organization can be completely different from another organization. For example, an e-commerce company may focus on protecting its Internet-facing web apps, while a hospital may focus on protecting confidential patient information.

The one thing that all organizations have in common is a need to keep their apps and devices secure. These devices must be compliant with the security standards (or security baselines) defined by the organization.

A security baseline is a group of Microsoft-recommended configuration settings that explains their security impact. These settings are based on feedback from Microsoft security engineering teams, product groups, partners, and customers.


How can you use security baselines?

You can use security baselines to:

1. Ensure that user and device configuration settings are compliant with the baseline.

2. Set configuration settings. For example, you can use Group Policy, Microsoft Endpoint Configuration Manager, or Microsoft Intune to configure a device with the setting values specified in the baseline.

Read More



Can't move the folder because there is a folder in the same location that can't be redirected


This article covers Steps to resolve Windows error, Can't move the folder because there is a folder in the same location that can't be redirected.


To resolve this error, try the following:

1. Open Registry Editor by pressing Windows logo+R then type "regedit". Press Enter.
2. Now head to this address:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

3. Locate a personal folder at the right panel that is displaying the error and double-click on it.
4. Replace the current value data with the corresponding Default Value in the below list:

Desktop - %USERPROFILE%\Desktop 
Favorites - %USERPROFILE%\Favorites 
Music - %USERPROFILE%\Music 
Pictures - %USERPROFILE%\Pictures 
Videos - %USERPROFILE%\Videos 
Documents - %USERPROFILE%\Documents 
Downloads - %USERPROFILE%\Downloads

Note the Corresponding registry key for the Downloads folder.
5. Click Ok to save the changes, close Registry Editor and restart the computer.


Read More



Outlook error "We Couldn't Create The Outlook Data File" - Fix it Now ?


This article covers different methods to fix the Outlook error 'We Couldn't Create The Outlook Data File'.

Main Causes of 'We couldn't create Outlook Data File' error:

This error is fairly well known among Outlook users, so people have found possible causes that led to this error happening.
1. Gmail account: The error seems to only occur when you’re trying to add a Gmail account to Outlook. The exact cause of this is unknown, however, it might have something to do with Gmail’s security options.
2. Outlook bug: A common cause of this issue is a bug within Outlook itself. The bug prevents you from adding an email account via the Add account option.
3. Simplified Account Creation Wizard: This is a relatively new Outlook feature. Generally, whenever a new feature is added to an application, it's bound to cause errors and bugs.

How to Remove Outlook Write Protection from a Hard Disk ?

One of the easiest ways of removing write protection from a disk is by using the Diskpart utility:
1. Hold the Windows and R keys down on your keyboard at the same time.
2. Type in diskpart and press OK.
3. Type in the following command and press Enter after each one:
i. list disk
ii. select disk (number)
iii. For example, if your Drive 1 is protected, you're going to type in select disk 1.
    attributes disk clear read-only
4. Once the Diskpart utility finished clearing the Read-only protection, you can type in exit and hit Enter to close the command prompt.

Read More



The source file names are larger than is supported by the file system


This article covers methods to resolve Windows error "The source file names are larger than is supported by the file system". Most Windows users encounter this issue when trying to copy or delete a file on the computer and they may receive an error message saying Source Path Too Long with the explanation of the source file name(s) are larger than is supported by the file system.


This Windows error error happens mainly because one or more files that are kept in a series of subfolders that have long names, but Windows only allows 258 characters at most in the folder path subfolder.
This will prevent you from moving the files or folders that are saved in this folder.

To fix this windows error, try the following:

Delete the File/Folder by Bypassing the Recycle Bin
You know that when you delete files from your computer, these files will be first moved to the Recycle Bin and they will stay there until you delete them permanently.
i. Click on the file or folder that is bothered by the Source Path Too Long error.
ii. Press the SHIFT and Delete buttons at the same time to permanently delete the file or folder.

Read More



Windows error "The volume does not contain a recognized file system" - Fix it Now ?


This article covers methods to fix 'The volume does not contain a recognized file system' the Windows error for our customers.

What Caused The Volume Does Not Contain the Recognized File System Error ?

Here are some of the reasons that can cause the error occurs on devices:
1. System re-installation
2. Presence of virus or malware
3. Unsafe system shut down.
4. Failure of file system conversion
5. Deletion of essential system files by mistake
6. Presence of bad sectors
7. Users misapplication
8. Virus/Trojan infection
9. Insufficient power supply

To fix this Windows error:

1. Proceed to Start and click on My Computer or This PC.
2. Select that drive that is not accessible and then choose Properties by right-clicking it.
3. From the Properties window, select the Tool tab and click on the Check button from the Error checking.
4. Select the Scan Drive option.
Once the scanning process is complete, please go back to This PC or My Computer to check whether the drive is fixed or not.

Read More



Disable NetBIOS and LLMNR Protocols in Windows Using GPO - How to do it


This article covers how to disable NetBIOS and LLMNR Protocols for our customers. The broadcast protocols NetBIOS over TCP/IP and LLMNR are used in most modern networks only for compatibility with legacy Windows versions. Both protocols are susceptible to spoofing and MITM attacks. 

In the Metasploit there are ready-made modules that allow you to easily exploit vulnerabilities in the broadcasting NetBIOS and LLMNR protocols to intercept user credentials in the local network (including NTLMv2 hashes). 

To improve your network security, you need to disable these protocols on the domain network. 


In the domain environment, LLMNR broadcasts can be disabled on computers and servers using Group Policy. 

To do it:

1. Open the gpmc.msc, create a new GPO or edit an existing one that is applied to all workstations and servers;

2. Go to Computer Configuration -> Administrative Templates -> Network -> DNS Client;

3. Enable Turn off smart multi-homed name resolution policy by changing its value to Enabled;

4. Wait while the GPO settings on clients are updated, or manually update them using the command: gpupdate /force.


To manually disable NetBIOS on Windows as follows:

1. Open network connection properties

2. Select TCP/IPv4 and open its properties

3. Click Advanced, then go to WINS tab and select Disable NetBIOS over TCP

4. Save the changes.

Read More



Microsoft SQL Server Error 916 - Fix it now


This article covers method to resolve Microsoft SQL Server Error 916 for our customers.

The main problem is due to bugs present in SQL Server Management Studio that prevents the user to connect to the database and refuses to display the database list.

How to solve Microsoft SQL server error 916:
If you receive the following error while using Microsoft SQL Server Management Studio 2008:
The server principal "username" is not able to access the database "dbname" under the current security context. (Microsoft SQL Server, Error: 916).

Causes of SQL Server Error 916:
1. The user is not permitted to view the data of selected column within the database.
2. The database is currently not available.
3. There are multiple columns such as Size, Space available, Data Space Used, Default file group, Index Space Used, Mail host, Primary file path and user has added at least one of them to the list of Object Explorer Details.
4. If the Auto Close option for the database is enabled, then Collation column cannot be retrieved by SQL Server Management Studio (SSMS).
5. For a database, Collation column contains NULL.

In order to view the granted permissions for the guest-user, the following command is helpful if run by a member of a Sysadmin fixed server.
The query is as follows:

USE msdb;
 SELECT prins.name AS grantee_name, perms.*
 FROM sys.database_permissions AS perms
 JOIN sys.database_principals AS prins
 ON perms.grantee_principal_id = prins.principal_id
 WHERE prins.name = ‘guest’ AND perms.permission_name = ‘CONNECT’;
 GO

On running the above command, a table is presented to the user containing all the attributes of guest user.
However, an empty result shows that guest user is disabled in the database and again the SQL Server error 916 will be displayed.
To overcome the error you may perform the following available solutions.

To fix this SQL server error 916:
1. In Object Explorer, click databases.
2. Display "Object Explorer Details" (F7) or "View –> Object Explorer Details".
3. Right-click the column headers and deselect "collation".
4. Refresh the databases.

Read More



SQL Server Error 5009 – Different scenarios and fixes


This article covers how to fix SQL Server Error 5009 error which occurs while adding or removing a database file or extending the database file size.
 
To fix Microsoft SQL Server Error 5009 While Adding Database File:
1. Set the Operating system permission on the mentioned .ldf file to full permission for your login account and SQL Server service account.
2. Change the location to the path where you have enough permission to create or add database files.

Read More



Cannot Copy and Paste via RDP - How to fix this Windows issue


This article covers how to Allow/Prevent Copy and Paste via RDP Clipboard on Windows. Copy and paste is an essential function that should ideally work every day without fail. You can resolve this Windows issue by restarting the rdpclip.exe program in the remote computer.

Also, you can log off the remote user and then log back on on Windows.

Once the rdpclip.exe is relaunched, you should be able to copy paste using clipboard from the local computer to the remote computer. 


In order to fix the copy and paste issue in Windows, you need to end the rdpclicp.exe process and then restart it:

To do this;

1. Press Ctrl + Shift + ESC to start Task Manager.

2. Go to the "Details" tab.

3. Right-click the "rdpclip.exe" process.

4. Select "End task".

5. Go to Windows/system32 folder.

6. Look for "rdpclip.exe" and run it.

Read More



An error occurred while reconnecting - Fix this Windows error now


This article covers methods to resolve fix 'An error occurred while reconnecting' Windows error. 


Causes for 'The Local Device Name is already in Use' Error on Windows:

1. Drive mapping has gone wrong – The process of network drive mapping can sometimes produce problems like this one when it comes to drive letters.

2. Some drive letters are unassigned – Some drives may have incorrect or even missing drive letters which causes this error to appear.

3. File and Printer Sharing is disabled – If this option is disabled in any firewall you might be using, networking becomes difficult and full of errors.

4. No space on the server – Users have reported that they had to free up at least a couple of gigabytes on the root drive of the network’s server to get rid of the problem.


To fix 'The Local Device Name is already in Use' Error on Windows:

Remap the Drive Using Command Prompt

Remapping the network drive is the official solution recommended by Microsoft for users facing this problem. However, it has worked for many users and it has become one of the most used methods for this problem. 

Check out the steps to implement this;

1. Search for “Command Prompt” either right in the Start menu or by tapping the search button right next to it. Right-click on the first result which will appear at the top and select the “Run as administrator” option.

2. Users who are using an older version of Windows can use the Windows Logo Key + R key combination in order to bring up the Run dialog box. Type in “cmd” in the box and use the Ctrl + Shift + Enter key combination in order to run Command Prompt as an administrator.

3. Copy and paste the command shown below and make sure you click the Enter key on your keyboard.

net use * /delete

4. After you see that the operation is completed successfully, run the following command:

net use Z: \\server\share /user:username password

5. Make sure you replace the username and password placeholders with the correct username and password. Check to see if the problem is resolved!

Read More



Encrypt email messages in Outlook - Follow this guide now


This article covers the different methods to encrypt email messages in Outlook: using certificates (S/Mime), Office 365 Message Encryption (OME), and using encryption add-ins.


To Encrypt a single message:

1. In message that you are composing, click File > Properties. 

2. Click Security Settings, and then select the Encrypt message contents and attachments check box. 

3. Compose your message, and then click Send.


In Outlook, All attachments are encrypted.

Recipients who access the encrypted email via the Office Message Encryption portal can view attachments in the browser.

Note that if the recipient of the file is using an Outlook.com account, they can open encrypted Office attachments on the Office apps for Windows.


To view an encrypted email in Outlook:

1. Select Read the message.

2. You'll be redirected to a page where you can sign in and receive a single-use code.

3. Check your email for the single-use code. Enter the code in the browser window, then select Continue to read your message.


To encrypt a message in Office 365:

1. Sign in with Global Admin credentials.

2. Click on Admin.

3. Click on Settings.

4. Click on Services & add-ins.

5. Click on Microsoft Azure Information Protection.

Read More



Best Server Monitoring Software Products - Advantages and Disadvantages


This article covers the Best Server Monitoring Software. Basically, Server management software takes the burden of managing servers and other critical applications.

Reporting and monitoring is critical in business, especially when it comes to IT infrastructure such as network connectivity and server monitoring.

Being able to look back at historical trends and faults is especially useful when troubleshooting an issue on a critical server or service, so if you don’t already have a solution in place, then it might be time to seriously consider it.


Server Monitoring Software is able to check everything about your system, such as:

1. CPU usage

2. RAM utilization

3. Hard Disk Space

4. System Temperatures

5. Server Alerts (Hardware status warnings)

6. RAID Array health checks

7. Virtual Machine Alerts

8. You can also monitor user logins, suspicious activity on your server, and the status of your services and daemons


Best server monitoring software and tools includes:

1. SolarWinds Server & Application Monitor - Tracks the statuses of key server components and also watches the performance of applications running on each server. The tool runs on Windows Server but can also monitor Linux servers across a network.

2. Atera - A remote monitoring and management system that includes server monitoring features. Ideal for managed service providers.

3. Site24x7 Server Monitoring - A cloud-based monitoring system that can track the statuses of Windows and Linux servers as part of a company’s infrastructure.

4. ManageEngine Applications Manager - A server and applications monitoring system that includes extra capabilities such as VM monitoring. Runs on Windows Server and Linux.

5. Paessler PRTG - A package of monitors that includes a range of server status trackers. Installs on Windows Server.

6. Nagios XI - A comprehensive infrastructure monitoring system that includes live server monitoring services. Installs on Linux.

7. Opsview - A system monitoring tool that includes sever monitoring and is billed as an alternative to Nagios XI. Runs on Linux.

8. Zenoss - A system monitoring tool that includes a server monitoring module and is also available in a free version. Installs on Linux.

9. OP5 - Monitor Server monitoring as part of a system-wide monitor tool that accepts Nagios plug-ins. Install on Linux.

10. AppOptics - A cloud-based server and applications monitoring system that will track the performance of Windows and Linux servers.

11. Monitis - A cloud-based monitoring system that specializes in tracking the performance of Web servers and Web applications.

12. ManageEngine Free Windows Admin Tools - A collection of 15 free tools that cover different aspects of server monitoring including disk space, software inventory, and user lists.


What is server maintenance?

Server maintenance is process of keeping a server software updated and running so that a computer network can operate smoothly and avoid downtime or loss of data. Regular maintenance will keep the server running as expected and will help avoid a total or partial network failure.

Read More



Checkpoint Process in SQL Server - An Insight into it


This article covers the Checkpoint process in SQL server and the four types of checkpoints available.
Checkpoints are the useful repositories of information and serve best for the recovery of SQL server databases.

Different Types of Checkpoint in #SQL:
1. Automatic Checkpoint
An automatic checkpoint is the most common type that is triggered by a background process. Server Configuration Option “Recovery Interval” is used by the SQL Server Database Engine to determine how often automatic checkpoints are issued on a given database.
2. Indirect Checkpoint
A new type of #checkpoint introduced in SQL Server 2012 is an Indirect checkpoint. Indirect checkpoint also runs in the background, but it meets user-specified target recovery time for a given database.
3. Manual Checkpoint
Manual checkpoint runs like any other Transact-SQL command. It runs to completion by default. This type of checkpoint occurs in the current database only. It is also possible to set the time frame in which you want your checkpoint completed.
4. Internal Checkpoint
The fourth type is Internal checkpoint that cannot be controlled by user.

Read More



SQL Server Memory Allocation


This article covers SQL server memory allocation best practices to follow while allocating memory.
By default, SQL Server can change its memory requirements dynamically based on available system resources.
SQL Server is designed to use all the memory on the server by default.
The reason for this is that #SQL Server cache the data in the database in #RAM so that it can access the data faster than it could if it needed to read the data from the disk every time a user needed it.
Changing SQL Server's Max Server memory is an online option – you don't need to restart SQL Server.
Though when you do make the change, you can and likely will cause data or procs to leave their caches so things could be a slight bit slower for a short while after you run it.
SQL Server will always give you better performance because the query is executed on the server.
Access on the back-end won't help because your client application will need to pull all the data from the tables, and then perform the join locally.
SQL Server has better indexing options.
'Max server memory' ensures that SQL Server buffer pool will not use more memory than specified in 'max server memory'.
So, SQL Server can use less memory than the value of 'max server memory' and other services can use the remaining memory.

You can monitor memory use at the database level as follows:
1. Launch SQL Server Management Studio and connect to a server.
2. In Object Explorer, right-click the database you want reports on.
3. In the context menu select, Reports -> Standard Reports -> Memory Usage By Memory Optimized Objects.

Read More



AWS error code 0x204


This article will guide you on methods to fix AWS #error code 0x204 which happens in the process of trying to login to a remote machine on VPC.

Amazon Virtual Private #Cloud (Amazon #VPC) is a service that lets you launch AWS resources in a logically isolated virtual network that you define. You can use both IPv4 and IPv6 for most resources in your virtual private cloud, helping to ensure secure and easy access to resources and applications.


To enable RDP access on AWS instance:

i. Open the Amazon EC2 console , set it to the stack's region, and choose Security Groups from the navigation pane. 

ii. Choose AWS-OpsWorks-RDP-Server, choose the Inbound tab, and choose Edit. 

iii. Choose Add Rule and specify the following settings: Type – RDP.


To connect from the #Amazon EC2 console:

1. Open the Amazon #EC2 console.

2. In the left navigation pane, choose Instances and select the instance to which to connect.

3. Choose Connect.

4. On the Connect To Your Instance page, choose EC2 Instance Connect (browser-based SSH connection), Connect.

Read More



Perfmon counters for Disk Usage


This article will guide you on use performance counters (#Perfmon) to identify SQL server disk bottlenecks. 

The performance impact is negligible in updating. Microsoft's intent is that you always write to the performance counters. It's the monitoring of (or capturing of) those performance counters that will cause a degradation of performance. So, only when you use something like perfmon to capture the data.

Reliability #Monitor shows you your system stability history at a glance and lets you see details on a day-by-day basis about events that impact reliability. Reliability Monitor provides a quick view of how stability the system has been.

1. The Performance Monitor is primarily for viewing real time #statistics. 

2. By default only one counter is selected; the %Processor Time counter. However you can add additional counters by clicking on the green plus sign. 

3. This will allow you to monitor any counters you wish in real time.

4. Difference Between Performance Monitor and #Resource Monitor is that a performance monitor is a program that assesses and reports information about various computer resources and devices. 

5. While Resource Monitor is a tool by which you can monitor the usage of your CPU.

Read More



Perfmon Counters for memory usage


This article will guide you on how to use Perfmon Counters for memory usage. You will also learn some commonly used performance counters which can be used to identify #SQL server memory pressure.

To detect a memory leak using #Performance #Monitor, monitor these counters: The Memory/Available Bytes counter lets you view the total number of bytes of available memory. This value normally fluctuates, but if you have an application with the memory leak, it will decrease over time.

A system performance report is a part of Performance Monitor that details the status of local hardware resources, system response times, and processes on the local computer. You can use this information to identify possible causes of performance issues.

SQL performance tuning consists of making queries of a relation database run as fast as possible. 

To Check Detailed #Memory #Usage with Performance Monitor:

1. To open up Performance Monitor type: perfmon into the Run window (Windows Key + R). 

2. In the window that comes up, click the Performance Monitor under Monitoring Tools in the left pane. 

Read More



Reporting services configuration manager


This article will guide you on how to setup reporting services configuration manager. Report Manager is Web based interface that can be used to perform different tasks such as. Administer the Report Server,View the Reports and Manager the Report, and so on. You need to have the URL to access the Report Server by using Report Manager interface.

SQL Server Reporting Services (#SSRS) is a reporting #software that allows you to produce formatted reports with tables in the form of data, #graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users.

Report server items are always stored in libraries or in a folder within a library. 

When you access the SharePoint site, you see the Browse page and the Library Tools tab.

In #Reporting Services, URLs are used to access the Report Server Web service and the web portal. A test link of the URL appears on page when you define the URL so that you can immediately confirm that the settings you specified result in a valid connection.

To connect to Reporting Services Configuration Manager:

1. Click Start, then click #Programs, then click #Microsoft #SQL Server, then click Configuration Tools, and then click Report Server Configuration Manager. 

2. The Report Server Installation Instance Selection dialog box appears so that you can select the report server instance you want to configure.

Read More



Install SQL Server 2019 on Linux


This article will guide you the process to install #MSSQL Server 2019 on #CentOS 7 and Ubuntu 16.04.

SQL Server 2019 #Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.

SQL Server 2019 allows us to integrate data from structured and unstructured data sources. 

We can now process diverse big data and relational data sources using Transact-SQL from SQL Server using PolyBase. 

We can see below PolyBase support external databases.

SQL Server Express can be used in production (beware of the limitations, like the 10GB cap), but according to this link Express is available for Linux. SQL Server Express is available to use in Production.

Starting with SQL Server 2017, SQL Server runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. It's the same SQL Server database engine, with many similar features and services regardless of your operating system.

To run a SQL script in #Linux terminal:

1. Open Terminal and type mysql -u to Open the MySQL command line.

2. Type the path of your #mysql bin directory and press Enter.

3. Paste your #SQL file inside the bin folder of mysql server.

4. Create a #database in MySQL.

5. Use that particular database where you want to import the SQL file.

Read More



Configure and Use Microsoft SQL Server Management Studio


This article will guide you on how to setup SQL server management studio. SQL Server Management Studio is a free #Windows #application to configure, manage, and administer Microsoft SQL Server (#MSSQL). 

SSMS is available only as a 32-bit application for Windows.

To get SQL Server Management Studio:

1. Go To Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft #SSMS 18. 

2. Below 'Connect to Server' screen will appear. 

3. Server Name defaults to the name selected while installing MS SQL server. 

4. Server type: This is an option to select one out of four available MS SQL services option.

To Enable remote connections to your SQL Server:

i. Open #SQL Server Management Studio.

ii. Right-click your server's name and select Properties.

iii. Tick the checkbox Allow remote connections to this server.

iv. Select OK.

Read More



Disable Password Expiration with PowerShell


This article will guide you on the method to disable password expiration in the #Windows server with PowerShell.

#PowerShell is the shell #framework developed by Microsoft for administration tasks such as configuration management and automation of repetitive jobs. 

The term 'PowerShell' refers to both – the shell used to execute commands and the scripting language that goes along with the framework.

Why did #Microsoft make me change my password?

This is a security feature of all Microsoft accounts which cannot be turned off. 

If the option for 72 days password expiration is enabled in your account then it will automatically ask you to reset password.

To turn off the password feature on Windows 10:

1. Click the Start menu and type "netplwiz." The top result should be a program of the same name — click it to open.

2. In the User Accounts screen that launches, untick the box that says "Users must enter a name and password to use this computer."

3. Hit "Apply."

4. When prompted, re-enter your password to confirm the changes.

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



Install NET framework 4.8 on windows server 2016


This article will guide you on how to #install .NET framework 4.8 on windows server 2016. 

Can't install .NET Framework 3.5 #Windows 10 0x800f0954?

NET Framework 3.5 or Any Optional #Feature. If the error 0x800f0954 occurs installing optional Windows features, it may be because the system is unable to access the Windows Update server. This is especially true in case of domain-joined computers which is configured to downloads updates from a WSUS server.

By using the Windows server 2016, we can install . NET Framework 3.5 which can be easily installed through Server Manager. 

i) Open the 'Server Manager' and navigate to the 'Manage' and then select 'Add Roles and Features'. 

ii) Click next to 'Features' section and select the option '.

To install Microsoft . #NET Framework 3.5. 1 on Windows Server 2012 R2:

1. Open Server Manager and select Features.

2. Select Add roles and features to launch the Add Roles and Features wizard.

3. In the Add Roles and Features wizard, click.

4. In the Confirm Installation Selections dialog box, click Install.

When you try to install the Microsoft . NET Framework 4.7 on a #computer that runs Windows 7 Service Pack 1 (SP1), Windows Server 2008 R2 SP1, or Windows Server 2012, the setup is blocked and cannot continue. 

This issue occurs when the computer does not have the update for D3DComplier (D3DCompiler_47. dll) installed.

Read More



Microsoft SQL server error 18470 How to fix it


This article will guide you on the different factors that causes SQL server error: 18470 and also how to fix this #error.

In SQL Server Configuration Manager, in the left pane, click SQL Server Services. In the results pane, right-click SQL Server (#MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.

User gets the #Microsoft SQL Server Error: 18470. This may happen if the SA (System Administrator) user account is disabled in #SQL Server. It can be verified by trying to log in to SQL Server Management Studio (#SSMS) using the SA account. In the Login Properties screen, select Status on the left side.

To Microsoft SQL Server Error 18456:

1. Log In with Remote Desktop.

2. Run Microsoft SQL Server Management.

3. Checking the Server Authentication Mode.

4. Restart the SQL Service.

5. Checking SQL User Permissions.

6. Mapping the User to the #Database.

Read More



Recover deleted items in Microsoft outlook


This article will guide you on methods to recover deleted #emails in #Outlook. This is possible by retrieving contents from the Recoverable Items folder. 

By default, the deleted #items won't be included while searching in Outlook. Actually Outlook provides you with a feature of automatically searching all folders include emails in the Deleted Items folder in each #data file.

To Recover Permanently Deleted #Hotmail Messages:

1. Go to Outlook.com and log in to your Live, Hotmail, or other Microsoft email account. 2. Select the Deleted Items folder in the left pane. 

3. Select Recover items deleted from this folder at the top of the message list. The Recoverable Items folder will open.

Read More



Windows Activation Error Code 0xc004f074


This article will guide you on methods to fix #Windows activation error code #0xc004f074 and its causes.

When attempting to activate the Windows operating system, users sometimes receive the 0xC004f074 error code. This is a Windows Activation error that occurs when Windows is unable to reach your company's activation service or system administrator.

Changing your Windows #Product Key does not affect your personal files, installed applications and settings. Enter the new product key and click Next and follow the on screen instructions to #activate over the Internet.

To fix error 0xc004f074 in Windows 10:

1. Use the slmgr. vbs command.

2. Use the Slui 3 command. While on your start screen you need to press and hold the button Windows and the button R.

3. Run SFC scan.

4. Run the Update and Activation #Troubleshooters.

5. Contact #Microsoft Support.

Read More



Windows update error 0x80240023


This article will guide you on steps to fix #Windows #update #error #0x80240023 which usually triggers while updating the Windows #system.
When you encounter an error #message, reboot your #machine and try to run the updates again. If you haven't run Windows #Update for some time, then you might have to repeat this process several times before all updates have been installed.
To fix errors on Windows 10:
1. Make sure that your #device has enough space.
2. Run Windows Update a few times.
3. Check third-party #drivers and download any updates.
4. Unplug extra #hardware.
5. Check Device #Manager for errors.
6. Remove third-party security #software.
7. Repair hard-drive errors.
8. Do a clean restart into Windows.

Read More



Orphaned users in SQL Server


This article will help you to identify #Orphaned #Windows #Logins and Groups in #SQL Server.
To Resolve an Orphaned User:
To map an orphaned user to a login which already exists in master, execute the ALTER USER #statement in the user database, specifying the login name.
ALTER USER <user_name> WITH Login = <login_name>; When you recreate a missing login, the user can access the database using the password provided.
To fix orphaned users for all databases in SQL Server:
1. Login with same name as user exists – generate ALTER LOGIN to map the user to the login.
2. No login with same name exists – generate DROP USER to delete the orphan user.
3. Orphan user is [dbo] – change the database owner to SA (or whatever SA was renamed to).

Read More



Could not load file or assembly Microsoft ReportViewer WebForms


This article will guide you on ways to resolve Could not load #file or #assembly 'Microsoft.ReportViewer.WebForms' #error occurs when #ReportViewer files are missing from the #bin folder.
You need to reference both Microsoft.ReportViewer.WebForms and Microsoft.ReportViewer.Common and set the CopyLocal property to true. This will result in the dll's being copied to our bin #directory (both are necessary).

Read More



Windows update error 0xFFFFFFFF


This article will guide you on different methods to fix #Windows #error #0xFFFFFFFF. Windows 10 update comes with #BSOD, crashes and various sound and #printer problems. The solution here is to uninstall the patch and pause updates until it's been fixed.

To fix Windows Error Code 0xFFFFFFFF:

1. Fix System Errors. To remove all error from your system that issuing freezing, slower performance problem etc.

2. Remove #Malwares. It can remove #malwares, #virus, #Trojan from #PC which causes all kind of critical issue.

3. Improve Startup. 

4. Clean PC.

You can also fix WIndows Error #0x800705b4:

i. Run Windows #Updates Troubleshooter. 

ii. Run #SFC scan. 

iii. Delete Software Distribution Folder.

iv. Disable updates for other #Microsoft #products. 

v. Uninstall the Problematic Updates. 

vi. Download and Install Windows Updates Manually.

Read More



ElasticSearch LDAP Authentication on the Active Directory


This article will guide you on how to authenticate #ElasticSearch users using the Active Directory from #Microsoft #Windows and the #LDAP protocol.

#Active #Directory (#AD) supports both Kerberos and LDAP – Microsoft AD is by far the most common directory services system in use today.

To Set up Active Directory Authentication using LDAP:

1. Enter the LDAP "Server" and "Port" attributes on the Server Overview tab of the LDAP Users page. 

2. Enter the proper base for the Active Directory in the "Base DN" attribute. 

3. Set the Search Scope. 

4. Enter the Username Attribute. 

5. Enter the Search Filter. 

6. Verify that the #settings are correct by clicking the Verify button.

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



Backup Outlook PST files


This article will guide you on how to perform #backup outlook PST files containing messages and all other Outlook data that is saved on the system which should be backup regularly.

#pst files created by using #Outlook 2010 are saved on your computer in the #Documents\Outlook Files folder. If you are using #Windows XP, these files are created in the My Documents\Outlook Files folder.

Read More



Testing RPC ports with PowerShell


This article will guide you on how to go about pinging available RPC ports with PowerShell and #Sysinternals tools and we can test #RPC #ports with #PowerShell.

In #Windows, do this by typing "cmd" in the search box in the Start Menu and clicking the command prompt icon. In the command prompt window, type "telnet" followed by a space, then an IP address or domain name followed by another space, and then the port number.

Read More



Steps to deploy DACPAC with SSMS


This article will guide you on the steps to deploy DACPAC which involves registering a DAC instance by storing the DAC definition in the #msdb system database. 

A DAC is a self-contained unit of #SQL Server #database deployment that enables data-tier developers and database administrators to package SQL #Server objects into a portable artifact called a #DAC package, also known as a #DACPAC.

Read More



The file PST is not an outlook data file pst


This article will guide you on the different methods to resolve "The file PST is not an #outlook data file (.pst)" error which indicates some problem with the Import/Export process or the file.

To resolve the issue try repairing the #PST file using the Scanpst.exe tool once again and then try opening the PST file in a new Outlook #Profile  (and not in the same Outlook Profile)

Read More



Types of SQL server backups


This article will guide you on the different types of SQL Server backups and how to use them to run #SQL Server #backups to safeguard our #databases from user #errors, media failure, #hardware failure, and so on.

A full database backup backs up the whole database. This includes part of the #transaction #log so that the full database can be recovered after a full database backup is restored.

Read More



Quick fix to The Messaging Interface Has Returned An Unknown Error


This article will guide you on the different methods to fix Outlook error "the messaging interface has returned an unknown error".

Read More



Search message tracking logs on Exchange 2016


This article will guide you on the different ways to search the message tracking logs by using the Get-MessageTrackingLog cmdlet in Exchange 2016.

Read More



Microsoft Outlook conflicting or unsupported encryption capabilities


This article will help to fix "Outlook conflicting or unsupported encryption capabilities" by simply turning off e-mail address matching for certificates and it depends on the version of Outlook you are running.

Read More



Outlook Error 0x8004210b How to fix it


This article will guide you on how to solve "Outlook Error 0x8004210b" which occurs in the process of installation, Windows shutdown, or while installing the Windows operating system.

Read More



A program is trying to send an email message on your behalf Methods to fix


This article will guide you on how to solve "A program is trying to send an email message on your behalf" warning which occurs when an application wants to send an email or access Outlook data in an abrupt way.

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



Ways of using SQL with Microsoft Access


This article will guide you on how to Use SQL with Microsoft Access.

Read More



Solve microsoft exchange server 2013 event id 4027 error


Best approach in fixing Microsoft exchange server 2013 event id 4027 error.

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