SSPIerror

Cannot Generate SSPI Context – Connection Problem

Problem: When I attempted to logon to one of individual node for my AlwaysOn Availability Group, I received the connection error shown below. TITLE: Connect to Server Cannot connect to … Continue Reading →


SQL_Linux_Install_Tools_Error

E: Unable to locate package mssql-tools – error install the command line tools for SQL Server on Ubuntu

Problem: When attempting to install the command line tools for SQL Server on Ubuntu 16.04.3, I would get the error: “E: Unable to locate package mssql-tools” Resolution: Note: SQL Server … Continue Reading →


RegEdit

Problem Patching a SQL Server Cluster

Problem: I was working with a SQL Server 2014 two node cluster in our test environment.  After the cluster had been setup, I was asked to change the drive letters … Continue Reading →


CannotFindTerassoLibrary

Teradata Error: Cannot Find Terasso Library

Problem: Setting up a new computer with the 16.10 Teradata Tools And Utilities & other Teradata programs.  When I went to setup the ODBC Connection to the using the Teradata … Continue Reading →



Verify4029

Trace Flag for Troubleshooting Lost or Dropped Connections in SQL Server

Problem: About once a month, I get support ticket regarding SQL Server dropping an application’s or user’s connection.  The problem is SQL Server does not just randomly drop a connection … Continue Reading →


SQL_Linux_Install_Error

E: Unable to locate package mssql-server – Ubuntu SQL Server Installation Error

Problem: With the new install of Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64), different attempts at installing SQL Server resulted in the error: “E: Unable to locate package mssql-server”. Resolution: On … Continue Reading →


IP_Link_Show

Flash NIC Light on SUSE Linux – Teradata Server

Problem: I needed to know the ethernet device name of an unused port on a NIC (network interface card) on my Teradata server.  Using the “ethertool” utility, I was able … Continue Reading →


TeradataViewLockedUserAccounts

Unlock a Teradata User Account

1. Determine if the account is locked by failed password attempts.  When the failed attempts equals the max logon attempts set in the user’s profile, the user will be displayed … Continue Reading →


TimeDateToMillisecondsForStoredProcedure

DateTime to the Millisecond in a Filename

My goal was create a filename with the DateTime format to the millisecond to be used in a stored procedure. First was to get the DateTime format I wanted without … Continue Reading →