Earlier today I ran across an error message that I had not seen previously. The message said: Login failed for user ‘[i’m not telling you our domain]\[or the service name]’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>] Um…yeah…what? I had just changed the service accounts … Read more
Ever wonder how to customize security for SQL Server Reporting Services? Attend this free webinar today by Cherie Sheriff and learn about custom security appoaches and considerations. Custom Security with Reporting Services Speaker: Cherie Sheriff Thursday, May 14th, at 1:00pm ET In this session we will discuss different custom security approaches with SSRS and what … Read more
Enough already. How has it come to be acceptable that whenever issues arise with any computerized system it is okay to use the phrase “there was a problem with the database” and everyone just accepts that and moves on with their lives but not before kicking their DBA around? For the record, as a DBA … Read more
There is a free PASS webinar on SSIS custom components, so take the time to attend this session by Anthony Dangelo. Introduction to SSIS Custom Component Development Speaker: Anthony Dangelo Tuesday, May 12th, 12:00pm ET You have tried so hard not to write code inside of SSIS, but the day has arrived when you tired … Read more
The PASS Board meeting is over and I am on the flight home sitting in seat 34A writing this as quickly as I can before my battery runs out. I have a short layover at DTW and I doubt I will be able to recharge at that point so whatever I feel the need to … Read more
A few weeks back I was asked how long a backup took for a specific database. I knew the info was in the msdb somewhere so I pieced together a bit of code and then thought to myself “hey, this might be a good thing to share with others at MSSQLTips”. Well, OK, I actually … Read more
