‘Cannot Generate SSPI Context’ and Service Account Passwords

Was working with Keith Elmore on one of our internal processes and he was hitting a “Cannot generate SSPI context” when trying to connect from Management Studio.  I also saw this come up in a double hop situation (IIS to SQL) when I setup a local repro. We went through the normal check list for…

11

DBMail has Suddenly Stopped Working

  The other day we ran into a strange Database Mail issue here in SQL support. Customers were running into issues where DBMail would suddenly stop working after doing service pack upgrades to their SQL Servers.This was happening on both SQL 2005 and SQL 2008. The error was also unusual in that the word “timeout” could make…

6

How It Works: Are you handling cancels correctly in your SQLCLR code?

I was recently developing a set of SQLCLR functions and procedures for an internal project.    One of the tests I added to my suite was to cancel the query (attention) and make sure I handled it properly in my .NET implementation.    What I found was much more than I expected and it is something that…

2

InvalidReportParameterException with Data Driven Subscription

Worked on a case yesterday where the customer was getting errors when running a Data Driven subscription.  In the RS Log, we saw something similar to the following: library!WindowsService_15!950!12/10/2009-10:49:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter ‘Param1’ is not a valid value., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value…

2

High CPU with Reporting Services 2008

I’ve run into two cases which fell down the same path and figured we should have some information out there regarding it.  The issue was that the customer’s instance of Reporting Services would just spike to 100% CPU usage.  During this time the end users did not notice any interruption in service. This occurred because…

5

Report Builder and Firewalls

We have had a few customer calls come in on this scenario that I thought this needed to be documented a bit. Scenario: In this scenario, the customer has a data source defined on the Report Server.  Some were using Named Instances, others were using a Default Instance for the Data Source. There are some…

10

Timeout when deploying SQL CLR objects from Visual Studio 2005 or 2008 but not from Management Studio

We have had a few customers who want to deploy their assemblies using Vistual Studio.   They encountered various errors similar to below.  But when the use SQL Server management studio to manually CREATE ASSEMBLY, everything works fine. Error: starting database upload transaction failed. Error: The operation could not be completed   Deploying file: TEstAssembly.dll, Path:…

0

How It Works: SQLIOSim CTRL+C vs Close Window

Today I had an interesting question about the CTRL+C handler for the SQLIOSim console execution.    After some investigation I found that a design change request is in order as the CTRL+C handler has a few holes-  (I am working on that part). The CTRL+C handler does not prompt you for something like ‘Do you wish…

0