Tag Archives: SQL server

Issue with Windows pass through authentication

Posted on November 23, 2021 by matt.bowler

It began with an error thrown by a linked server. The linked server is on our warehouse server and connects to our SSIS server using the “login’s current security context” option. The error was not hugely helpful, and internet searches … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Migrating SQL Server logins

Posted on May 7, 2014 by matt.bowler

Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During some recent migration work I realised that SQL Server Management Studio could do most of the work of sp_help_revlogin. I … Continue reading →

Posted in Security, SQL Server, T-SQL, Uncategorized | Tagged , | 8 Comments

Quick Tip: Migrating a SQL Server Mirroring Witness server.

Posted on March 27, 2014 by matt.bowler

If you’re like me, you might be thinking “I want some more things to think about when I migrate between SQL Servers.” … No? Okay, fair enough. There’s a whole list of things to think about when migrating from one SQL … Continue reading →

Posted in Database options, Disaster Recovery, SQL Server, T-SQL | Tagged , , | 3 Comments