Browse by Tags

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

SQL Server Support Content

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 ...read more

on 27 Mar 2014
Blog Post: SQL Connection Pool Timeout Debugging

SQL Server Support Content

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 ...read more

on 22 Oct 2013
Blog Post: Getting a SharePoint List Data Source to work with Reporting Services Native Mode

SQL Server Support Content

A case came up where the user was trying to use Report Builder in a Reporting Services instance that was not integrated with SharePoint. It was in Native Mode configuration. They indicated that they were getting a 401 error. My initial ...read more

on 11 Jun 2013
Blog Post: How to limit connections to SQL Server until all databases are ONLINE!

SQL Server Support Content

Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this ...read more

on 18 Dec 2012
Blog Post: SharePoint Adventures : Claims, Named Pipes and Kerberos

SQL Server Support Content

I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related to this blog post . It’s rare that I actually see a case related to the Named Pipes protocol. When I do, it is usually a customer trying to get it ...read more

on 17 May 2013
Blog Post: Invalid or loopback address when configuring SharePoint against a SQL Server

SQL Server Support Content

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 ...read more

on 4 Oct 2013
Blog Post: When Does sp_prepare Return Metadata

SQL Server Support Content

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 ...read more

on 23 Jul 2013
Blog Post: AdomdConnectionException using PerformancePoint hitting Analysis Services

SQL Server Support Content

I was working with a customer who was encountering problems trying to use a PerformancePoint Dashboard against an Analysis Services Instance. The issue came down to the Claims to Windows Token Service (C2WTS) configuration. This is used to take ...read more

on 6 Sep 2012
Blog Post: Breaking Down 18065

SQL Server Support Content

We have had two blog posts on this blog regarding the 18056 error. Two from Bob Dorr (and part 2 ) and another from Tejas Shah . However, we still see a lot of questions about this error message. This error message can show up for different reasons ...read more

on 13 Feb 2013
Blog Post: SharePoint Adventures : When connectivity is not connectivity

SQL Server Support Content

I’m always amazed that issues usually come in batches. I was looped into a few cases that had the following symptoms. They were running SharePoint 2010 and Reporting Services 2012 SP1. When they went to use a data source with Windows ...read more

on 17 May 2013

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

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

Blog Post: SQL Connection Pool Timeout Debugging

Blog Post: Getting a SharePoint List Data Source to work with Reporting Services Native Mode

Blog Post: How to limit connections to SQL Server until all databases are ONLINE!

Blog Post: SharePoint Adventures : Claims, Named Pipes and Kerberos

Blog Post: Invalid or loopback address when configuring SharePoint against a SQL Server

Blog Post: When Does sp_prepare Return Metadata

Blog Post: AdomdConnectionException using PerformancePoint hitting Analysis Services

Blog Post: Breaking Down 18065

Blog Post: SharePoint Adventures : When connectivity is not connectivity