Install SQL Server without reboot

Posted on by Andy

When installing SQL Server 2012 one can run into “‘Reboot required check failed” situation. This is in many production environments a total no-go. Here is a simple workaround for that:

  • open the windows registry editor 
  • find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
  • rename temporarily PendingFileRenameOperations to PendingFileRenameOperations-BAK
  • install SQL Server
  • when install finished, rename it back.

There you go… SQL Server installed without a reboot.

Kernel crash on CentOS 7 – Xeon E3-1230 with NVIDIA GT 710

Posted on by Andy

I recently purchased a Xeon E3-1230v5 with an NVIDIA GT710 graphics card as a server and had permanent kernel panics. After some research i found a bug statement https://bugs.centos.org/view.php?id=11488

The reason for the kernel panics seems to be NVIDIAs nouveau driver.

The mentioned fixed seemd to work and i have now a stable server. It's quite simple:

Edit /etc/sysconfig/grub and add "rd.driver.blacklist=nouveau nomodeset" to GRUB_CMDLINE_LINUX. Then create /etc/modprobe.d/blacklist.conf and add "blacklist nouveau" to that file.

Now, update grub with "grub2-mkconfig -o /boot/grub2/grub.cfg" and reboot.

After that, the system was rock-solid.

SSH passwordless login in OpenSSH

Posted on by Andy

You can login to a remote Linux server without entering password in 3 simple steps:

  1. create public and private keys on the source/local server:

    # ssh-keygen
  2. copy the public key from local to destination/remote host:

    # ssh-copy-id -i ~/.ssh/id_rsa.pub <remote ip>
  3. test passwordless login:

    # ssh <remote ip>

If all went well you should not be asked for a password. You can find your key on the remote system in ~/.ssh/authorized_keys

Thie above commands were executed as root user and the mechanism is done for root@local -> root@remote.