Changes to management of ‘TokenAndPermUserStore’ in SQL 2005 SP3

SQL Server 2005 service pack 3 released today and you can download it from here: One of the most interesting and useful bits which I am interested in (apart from the bug fixes rolled up from all the cumulative updates) is the new ability to manage to the ‘TokenAndPermUserStore’ cache with more control. Many…


SQL Server Database Mirroring error 1443 – Connection Handshake Failed

Here’s another error that I picked from the forums today, which I see a fair number of occurrences of, both in the public forums on the web and internally in MS support as well. You attempt to enable database mirroring and you receive the following: Database Mirroring login attempt failed with error: ‘Connection handshake failed….


Database Mirroring Error 1418 Troubleshooter

I’ve been posting in the MSDN and TECHNET mirroring forums in the last few days and I’ve noticed a lot of occurrences of the 1418 error which I have referred to briefly in this blog before. Therefore I thought I’d post a 1418 specific troubleshooter for reference. The problem we’re trying to solve is that…


Problems executing maintenance plans in SQL Server 2008

In the RTM build of SQL Server 2008 , if you install the tools in any edition, you are able to create maintenance plans. However depending upon your version and your extact installation components, when you execute the maintenance plan you created, you may receive the following message: Executed as user: <domain>\<user>. Microsoft (R) SQL…


How to configure SQL Server database mirroring between 2 instances on a standalone server

There are lots of troubleshooting articles about how to diagnose connectivity problems when setting up database mirroring, especially errors such as these: Msg 1418, Level 16, State 1, Line 2 The server network address “tcp://” can not be reached or does not exist. Check the network address name and that the ports for the local…


Interesting things to watch out for when using the autoclose database option

Here’s something which I’ve been looking at this week, surrounding the autoclose database option. When you restore any database to a SQL Server 2005 SP2 or later instance, you’ll more than likely get errors of this nature written to the log. 2008-11-12 17:24:16.58 spid13s     SQL Server has encountered 5 occurrence(s) of cachestore flush for the…


Want to read some tips and tricks from the SQL Developer support team?

Well if you do you should check out the blog of my colleague and Microsoft pool team partner Spike, who works in the SQL Support team here with me in Stockholm, but specialises in the area that we refer to as developer support. This is a very broad area and encompasses many technologies but to…


Database Mirroring Monitor can cause large tempdb growth in SQL Server 2005 – changed behavior in SQL Server 2008

On extremely rare occasions in SQL Server 2005, when the following conditions are true:   1.       You have a database configured for database mirroring 2.       You have replication configured on the same database 3.       You are running the database mirroring monitor 4.       The SQL Agent job created by the database mirroring monitor is enabled  …


New SQL Blogger from my team

My hugely experienced colleague Clive, from the SQL Escalation team in the UK, has just started a blog here: It should be interesting reading as he’s quite a guru on matters of clustering and high availability. He’s started off with a post about one my least favourite subjects, setup in SQL 2000 Clustered instances…