How to check SQL Server version

Select @@version

Result:-

Microsoft SQL Server 2012 – 11.0.5058.0 (X64)

May 14 2014 18:34:29

Copyright (c) Microsoft Corporation

Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

 tech2more.com

How to disable OEL 7/RHEL7 firewall

How to disable OEL 7/RHEL7 firewall

Enable VNC server on RHEL 7 or OEL 7

Enable VNC server on RHEL 7 or OEL 7

Please install the following package.

# yum install tigervnc-server

Then copy the service file to systemd location.

# cp /usr/lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:2.service

The browse to the directory vi /etc/systemd/system/vncsever@:2.service

Make the following changes

[Service]

Type=forking

# Clean any existing files in /tmp/.X11-unix environment

ExecStartPre=/bin/sh -c ‘/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :’

ExecStart=/usr/sbin/runuser -l root -c “/usr/bin/vncserver %i”

PIDFile=/root/.vnc/%H%i.pid

ExecStop=/bin/sh -c ‘/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :’

Change the VNC password

vncpasswd

Password- 12345

Retype password- 12345

Then run the following commands

Readmore ..

Unable to create directory uploads/. Is its parent directory writable by

Unable to create directory uploads/. Is its parent directory writable by

Permissions file to 777 while i upload the plugins or the media .For select folder

Enable or Disable SELinux

Disable SELinux Temporarily

To disable SELinux temporarily, issue the command below as root:

# echo 0 > /selinux/enforce

Readmore ..

How To Create an SSL Certificate on Nginx for CentOS

How To Create an SSL Certificate on Nginx for CentOS

Prerequisites

# yum update

# yum install nginx

Create the SSL Certificate

Create a folder for ssl

sudo mkdir /etc/nginx/ssl

Readmore..

Installing PHP-FPM on CentOS Linux

Installing PHP-FPM on CentOS Linux

Add remi repository for PHP

Remi Dependency on CentOS 6 and Red Hat (RHEL) 6

# sudo rpm -ivh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

CentOS 6 and Red Hat (RHEL) 6

# sudo rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

Install php-fpm and dependencies

sudo yum install php-fpm

Read More ...

Oracle Database 12 Release 2 Installation Step By Step on Window Server 2008

Oracle Database 12 Release 2 Installation Step By Step on Window Server 2008

Download the setup Oracle 12C (12.2) extract the file http://download.oracle.com/otn/nt/oracle12c/122010/winx64_12201_database.zip?AuthParam=1500618276_6bc47c2af4b28270b85c489742e6f3b5 Link : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-windows-3633015.html winx64_12201_database.zip 

Readmore...

Enable VNC server on RHEL 7 or OEL 7

Enable VNC server on RHEL 7 or OEL 7

Please install the following package.

# yum install tigervnc-server

Then copy the service file to systemd location.

# cp /usr/lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:2.service

The browse to the directory vi /etc/systemd/system/vncsever@:2.service

Make the following changes

Enable or Disable Secure Log On CTRL+ALT+DELETE in Windows 7

Enable or Disable Secure Log On CTRL+ALT+DELETE in Windows 7





1. Open the Start Menu.

2. In the search line, type netplwiz and press Enter. (See screenshot below)



3. Click on the Advanced tab. (See screenshot below)

Enable VNC server on RHEL 7 or OEL 7

Enable VNC server on RHEL 7 or OEL 7



Please install the following package.



# yum install tigervnc-server



Then copy the service file to systemd location.

# cp /usr/lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:2.service

Installing Apache OpenSSL & HTTPD

Installing Apache OpenSSL & HTTPD



How to install, configure Apache HTTPD and open SSL on Linux flavors. Prerequisite Below are the possible Linux libraries that should be installed in prior. This list can vary depending upon the Linux flavor.

Mysql-installer-community-5.7.18.1 installation on Windows step by step

Mysql-installer-community-5.7.18.1 installation on Windows step by step

Install the MySQL installer community setup. Proceed with these step by step

How to get Windows Systems information using cmd

How to get Windows Systems information using cmd



To get system’s physical memory information from windows command line:   systeminfo | findstr /C:”Total Physical Memory”   To get System type from windows command line:   systeminfo | findstr /C:”System type”   To find System locale from windows command

Install Apache, PHP And MySQL On CentOS 7

Install Apache, PHP And MySQL On CentOS 7



  First ,need to install modules rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY*yum -y install epel-release Installing MySQL mysql_secure_installation root@server1 ~]# mysql_secure_installation/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found Enter current password for root (enter for none): <–ENTEROK, successfully used password, moving on…