This post discusses an issue I had with Atlassian’s SourceTree software and my firewall. I originally thought that SourceTree was just slow and didn’t work well on Windows, but I recently found out it was actually my anti-virus and firewall that was causing the issues.
Read the rest of this entry »How to fix: File in Use – Personal.xlsb is locked for editing August 2, 2013 – 9:27
I recently added some macros into my PERSONAL.XLSB file for Excel and started getting these annoying pop-ups saying that it’s locked for editing. This file loads in the background every time you open a copy of Excel. The point of it is to give you a place to save commonly used macros that will then be loaded and available to you in whatever workbooks you open. The problem with this is that if you open multiple copies of Excel, they all ask the operating system for write permissions in case you want to update the file.
This article explains how to fix this issue depending on whether you want to keep the file or get rid of it.
Read the rest of this entry »Fix: Cannot Generate SSPI Context December 2, 2011 – 12:12
I was recently working on an ASP.Net project and was receiving this error on attempting to
.Open() my SQL Server database connection:
System.Data.SqlClient.SqlException: Cannot generate SSPI context.
As you may have noticed, the connection uses SSPI (i.e. Windows login authentication) to connect to SQL Server. I thought this was a bit strange and tried restarting the project (it was running in debug mode). That didn’t help.
Fortunately, I remembered that my Windows password was set to expire today. It had expired while I was logged in, and so, was preventing me from being able to authenticate my login with SQL Server.
So, if you’re receiving this error, try updating your password if it may have expired.
About the Author
Hey there! My name is Richard Marskell and I'm the co-founder of LBC IT Solutions, Inc.. I've been developing websites, apps and even games for over 22 years.
I previously worked at a leading Canadian market research company for 8.5 years, managing their tech team and projects—everything from project & resource management to designing client websites.
This blog is where I share some of the things I've found (or figured out) throughout my career.
Have something to say? Drop me a comment or tweet me .
Latest Posts
- » Excel Tip: Helpful Keyboard Shortcuts
- » Windows 10 Announced - New Features Abound
- » Enable or Disable Torrent / P2P Traffic in IPFire
- » Remotely List and Disconnect Users in Windows
- » Git + Stash: Set up Self-Signed SSL Certificate in Windows
- » SourceTree: Fix for Slow Operation on Windows
- » Using Integers as Boolean Flags
- » 2014 Update
- » How to fix: File in Use - Personal.xlsb is locked for editing
- » Browser Automatically Blocks Ports
Post Calendar
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | |