I always forget this in between using it, so for the benefit of future Howard, here’s how to fix orphaned users resulting from restoring a SQL database to a different machine.
First, list the orphan users to make sure this is the problem:
EXEC sp_change_users_login ‘Report’
Usually I already have the login and password set up on the [...]
Read Full Post »
Posted in Development, Internet, Microsoft on Mar 8th, 2010
I spent some time last weekend migrating the Work Avoidance site away from Gradwell and onto a dedicated virtual server from MEMSET. Since this involved a move to a Windows box away from UNIX hosting, I had to configure in IIS7 some of the settings I had in the .htaccess under the UNIX host.
Read Full Post »
Another post in a series designed to help Future-Howard work out why things have broken.
If you install Java 6 Update 13 and then try and log into Cisco SDM 2.5 it will fail. The SDM console will not load.
I found I had to go back to Java 6 Update 6 (available at the Java [...]
Read Full Post »
Posted in Development, Scripting, Security on Jan 9th, 2008
This is a bit of code I wish I’d found sooner. There is a – it seems mostly undocumented – feature of the ldap provider in Server 2003 that allows you to form an ldap query just on the SID of an account:
bindSid = “LDAP://<sid =” & SID & “>”
set oVal = GetObject(bindSid)
Result = [...]
Read Full Post »
Posted in Development, Games, Networking on Dec 4th, 2007
In my last post, you discovered my obsession for generating statistics on my network usage and my use of MRTG to draw pretty little graphs. Writing that post got me thinking about my Counter-Strike server, and what data I could usefully graph from it. A bit of Googling led me to this [...]
Read Full Post »
Posted in Development, Future Howard, Software on Jul 31st, 2007
This code translator is very handy. Give it some C# and it will spit out VB.NET, give it VB.NET and it’ll give you C#. Some of the code samples for manipulating Word documents are in VB.NET and I wanted to see them in C#. I could have tried to translate them myself but this saved [...]
Read Full Post »