Solving SQL Connectivity issues: A new guided walk through just got published

We recently published a new document that provides a one stop shop for solving majority of connectivity issues that you may run into when working with SQL Server. This can be accessed here: Solving Connectivity errors to SQL Server In addition to providing a quick checklist of items that you can go through, the doc…

8

How to get up and running with Oracle and Linked Servers

I have had more Linked Server cases that are setup for an Oracle database than any other non-SQL Server database in SQL. Being in Business Intelligence Support we deal with plenty of connectivity issues and this is one topic of connectivity that does not get touched on a lot. In less than a month I…

10

Getting the latest SQL Server Native Client

If you are installing a Service Pack (SP) or Cumulative Update (CU) for SQL Server, you may notice that the SQL Server Native Client doesn’t get updated.  It may also be difficult to find the item to actually get it updated. If you go look at the Feature Packs for the Service Packs, or go…

2

How to get unstuck when using SQL Aliases

I got a case recently where the customer had a SQL Alias setup but was having issues connecting to their application. Being in Business Intelligence Support we deal with plenty of connectivity issues and this is one topic of connectivity that does not get touched on a lot.   A SQL alias is an alternate…

2

JDBC: This driver is not configured for integrated authentication

I’ve had about 4 cases in the last two months that centered around the following error when trying to use Windows Integrated authentication with JDBC. java.sql.SQLException: This driver is not configured for integrated authentication The key environment point on this was that they were trying to do this on a Linux platorm and not a…

12

Don’t Rely On a Static IP Address for Your SQL Database

I’ve seen a number of customers open support incidents because they couldn’t connect to their SQL Database server which was ultimately due to the incorrect assumption that the server’s IP address is static. In fact, the IP address of your logical server is not static and is subject to change at any time. All connections…

4

Can’t Connect to SQL when provisioning a Project App in SharePoint

The customers issue was that they were trying to provision a Project site within the Project SharePoint Application. This was done via a PowerShell script that they ran on one of the SharePoint App Servers. They had two SharePoint App Servers – AppServerA and AppServerB. They had indicated that the provisioning would fail on either…

0

SQL Connection Pool Timeout Debugging

This is a follow up to two blog posts from back in 2009 which talked about leaked connections.  In Part 1 and Part 2 of that post, it was about how to determine that you actually filled your pool.  This was centered around the following error: Exception type: System.InvalidOperationException Message: Timeout expired.  The timeout period…

2

Invalid or loopback address when configuring SharePoint against a SQL Server

I was presented with a connectivity issue when trying to configure SharePoint 2013 using a CTP build of SQL 2014.  They got the following error when they were it was trying to create the Configuration Database. Exception: System.ArgumentException: myserver,50000 is an invalid or loopback address.  Specify a valid server address.    at Microsoft.SharePoint.Administration.SPServer.ValidateAddress(String address)   …

5

When Does sp_prepare Return Metadata

I was running an RML Utilities Suite test pass and encountered varying behavior from our sp_prepare suite.  Here is what I uncovered. The command sp_prepare returns (or does not return) metadata depending on the server version.  For the client version, it is only significant whether it is prior to SQL 2012 or it is a…

0