Fixing the password problem on small business networks

Posted in sysadmin, windows (June 28, 2007 at 1:48 am)

I’ve been involved in commercially supporting Windows networks for almost 5 years now, having dealt with a hundreds of users across dozens of different companies.  Most of the clients we support are “small businesses”, which makes sense, as it is quoted that as 97.3% of private enterprise in NZ is small/medium sized, accounting for 49.4% of private sector employment.

These companies, in the most part, don’t have the infrastructure for a large, homogeneous IT environment.

And you know what?  They couldn’t care less.

They make do with what they always have - buying PCs piecemeal, having Office 2000 on some PCs and Office 2003 on others, and - the kicker - knowing everyone else’s passwords, instead of sharing data.  Even though products like Microsoft Exchange allow you to do things like delegate access to someone else’s mailbox, they still claim they need to all have their passwords set to ‘password’, or documented in a book, in case they need to sit at someone else’s PC.

People don’t do what PCs suggest they should do. No one really wants the multi user functionality that PCs have now.  In small business, people want to be able to use the line-of-business application, a web browser, and access their own e-mail and files. They might like the idea of having some personalisation (some care for it, some don’t), but overall, having to log out as you and log in as me takes longer than the effort required just to use the application as set up on your profile.

So, as a sysadmin, I want people to use strong passwords.  I have to wean them off the idea of needing someone else’s password to get at their data.  And I want to work how they work, not how I think they want to.  They want the desktop you use when you’re filling in for someone to look like it did when they were learning over the first person’s shoulder.

The primary solution put forward by Microsoft is “roaming profiles”, where you can log into any machine, and have your applications loaded.  Say you’ve got a shortcut to Word 2003 on your desktop, and you roam that profile to a machine with Word 2000 on it.  Doesn’t work.  Good for volume licensed customers with the same software on all PCs, but not good for us.  Doubly bad when you look at how people actually work - the accounts clerk has MYOB and payroll software installed, some managers will have banking software for authorising transactions, sales people may have a line-of-business application that analysts don’t need, etc.  It’s not worth ensuring that the software is on everyone’s machine, it means unnecessary licensing costs, and in the case of things like payroll software, people want to know it’s not available to everyone.

So, roaming profiles are out.

When someone is away, their mail and phone are diverted, but their PC sits there unused, or someone has to sit at the desk - they try and find the icons you used to click, but their new profile doesn’t have the shortcuts, or the per-user registry keys required for some random application.

Let’s look at some other possible solutions:

Terminal services or Citrix MetaFrame

Put everyone on a thin client and make everyone use a central server.  Good plan, large investment required, takes a lot of time to change from an office of fat-clients to a thin-client environment, and not all SME apps are TS friendly.  Also, if you scale to needing more than one TS, then you’re back at square 1 with needing the apps to be in synch across two machines.

Virtual machinery

Abstract the access away from the machine - have a bunch of passwords all able to unlock the same machine.  Wasteful.

Change someones password temporarily if you need to use their account

Tried this.  At present, there is no way for the Administrator to change someone’s password, store the original hash, and set it back at a later date.  I think it’s worth implementing though.

Cheat biometrics

Biometric sensors, like the fingerprint scanner on my T60 laptop, can be ‘cheated’: in an office of 10 people, with 10 fingerprints able to be stored, why not store everyone’s fingerprint on everyone’s computer?  Requires buying a scanner for everyone’s PC.

Insecure machine accounts, delegated access to data

Why not have everyone have a 20 character password, but have a single password for logging into the machine in the morning?  You could have a “machine user” account on each machine, and delegate e-mail access for everyone necessary to the machine.  A bit more administrative overhead but a possible solution.

Craig’s “Silver Bullet” answer

My favourite suggestion is delegating access to your profile, or your profile/PC combination.  This is what Exchange lets you do now with e-mail - why not extend this to user accounts also?  Presumably, the component (a “GINA“) that that handles authentication for the fingerprint reader, could be made to start loading another account, separate from the one you entered the password for?

Therefore, we can have a 1:1 mapping of people to passwords, so no-one ever has to know anyone else’s, and then we can have a 1:many between computers and users, without needing messy multiple profiles.

Anyone see any problems with this approach?  If not, why haven’t you written it yet?  Look perhaps at pGina as a base. My (ex-)small businesses will pay.

ACT presents “Object reference: Not set to an instance of an object.” when connecting via Citrix

Posted in sysadmin, windows, dotnet, citrix (May 23, 2007 at 1:14 am)

The ACT! contact management application is a pig. There, I’ve said it. It’s one of those programs that keeps changing owners - that’s how much of a pig it is. Seems no-one really wants it.

They re-wrote it in .NET a couple of versions ago, and it ought to be better, but it isn’t. ACT! throws “Object reference: Not set to an instance of an object.” (a reasonably common .NET error) whenever it feels like it.

In my particular case, I could open it fine when using a Citrix desktop session, but as a published application, it would die all the time.

I tracked the problem to the seamless window. When you run seamlessly, you get Citrix’s WFSHELL.EXE running, and not EXPLORER.EXE. You can force a published application to run at a certain screen size, which runs as if you were in a desktop. Hopefully the ACT! forums will give me a better answer.

“The specified directory service attribute or value does not exist” connecting to Microsoft Exchange IMAP

Posted in sysadmin, windows, exchange, imap (May 21, 2007 at 1:13 am)

Are you getting “The specified directory service attribute or value does not exist.” when connecting to Exchange IMAP? Wait a while. This error will go away - if you’ve just mail-enabled your account, Exchange will accept the username and password now, but it will take a few minutes for the mailbox to actually catch up.

Debugging .NET - “Common Language Runtime Debugging Services Application has generated an exception that could not be handled”

Posted in Programming, windows, dotnet (May 12, 2007 at 1:13 am)

ProfileTool doesn’t work on half the machines I try it on. I get an error like:

Profiletool.exe Common Language Runtime Debugging Services
Application has generated an exception that could not be handled.
Process ID=0×14 (1300), Thread Id=0xe8(232)

Click OK to terminate the application.
Click CANCEL to debug the application.

There’s no point searching Google for the process ID and thread number; they’re unique to your instance.

What can you do here? You get an error suggesting that ‘debugging failed’ if you hit Cancel - this is correct, because you don’t have a debugger installed!

First step, if you’re running your .NET application off the network, stop, move it to your local disk, and try again. The default security policy doesn’t let you do this - you can edit it in the Administrative Tools if you need to.

Now, if you still get the error, drop to a command line, and run the following:

ProfileTool 2>error.log

This redirects the standard error output to error.log, which you can then read. Linux/UNIX outputs this to the terminal by default; Windows hides it.

Thanks to Frank Racis, by way of Mohamed Yehia.

The actual error, in this case, was “No mapping between user accounts and security IDs was done“, which really means “don’t catch System.SystemException when you are throwing System.Exception”. And when you’re testing new builds, don’t sit behind an ISA server which aggressively caches the old build.

Access 2003 fires up Windows Installer every time you run it

Posted in sysadmin, windows, access, msiexec (May 1, 2007 at 1:14 am)

Found an interesting problem this morning - Access 2003 fires up Windows Installer (msiexec.exe) every time you start it, and for users without administrator rights, it just doesn’t go.

After looking at dozens of newsgroup posts and trying a few solutions, I finally had enough debugging information to find the solution that worked: registry keys are missing from HKLM\Software\Microsoft\Jet\4.0\Engines. Copy them from another machine (changing paths where required) and it works again!  Would of course love to know what caused a bunch of registry keys to just disappear…

For those interested, I found that msiexec was writing to a log file using Filemon, and the log file contained the error “Cannot Open Jet XL ISAM registry key” - descriptive enough to find the solution.

Access 2003 fires up Windows Installer every time you run it

Posted in sysadmin, windows, access, msiexec (April 30, 2007 at 1:14 am)

Found an interesting problem this morning - Access 2003 fires up Windows Installer (msiexec.exe) every time you start it, and for users without administrator rights, it just doesn’t go.

After looking at dozens of newsgroup posts and trying a few solutions, I finally had enough debugging information to find the solution that worked: registry keys are missing from HKLM\Software\Microsoft\Jet\4.0\Engines. Copy them from another machine (changing paths where required) and it works again!  Would of course love to know what caused a bunch of registry keys to just disappear…

For those interested, I found that msiexec was writing to a log file using Filemon, and the log file contained the error “Cannot Open Jet XL ISAM registry key” - descriptive enough to find the solution.

Targeting .NET 1.1 harder than it seems

Posted in Programming, windows, dotnet (April 27, 2007 at 1:13 am)

I’d like my application to be able to run on .NET 1.1, so I’ve avoided using all the new niceties of .NET 2.0.

Or so I thought.

First, I experimented with MSBee, which lets you build for the .NET 1.1 environment using the VS 2005 tools. After seeing how many errors my code generated in 1.1, while it compiled cleanly in 2.0, I thought “maybe reimplementing this in VS 2003 might be easier”.
And while I’ve specifically avoided some of the .NET 2.0 things that would have been really handy, like the SecurityIdentifier class, which makes handling SID-account mapping easy, there’s things I didn’t know would be a problem. You can’t set a registry key to be a certain type in 1.1. And you can’t use half the features that the designer implements for you automatically. And even if you could, you’d have to hack at it, because they separate code and design with partial classes in 2.0.

So, to summarize, looks like .NET was pretty crap prior to 2005. And that means you need to have XP SP2, because it’s not supported on SP1.

(/rant)

ProfileTool beta released

ProfileTool screenshotI don’t often write code, but I do find it’s a good complement to cricket watching. So, in honour of New Zealand playing Sri Lanka in the World Cup semi-final, I’m proud to announce the release of the first public beta of the IT Partners ProfileTool.

ProfileTool lets you take a Windows 2000 or XP user’s profile and assign it to a different user, without having to copy any files or perform any manual procedures.

This is a common task for people who are taking a network of PCs that have not been on a domain, and joining them to one; or if you replace a domain controller without keeping security information, which is sometimes done on sites upgrading from a badly installed SBS 2000 installation to a nicely installed SBS 2003 installation.

It also has useful features for deleting a profile off the disk/from the registry, and changing profiles from roaming to local, replicating the features of the User Profiles capplet.

The source is available under the Mozilla Public License, with the implication of “Do what you like with this code, but if you improve it, I’d like your source to come back to me please”.

Gray boxes when viewing Java applets

Posted in sysadmin, windows, java ( at 1:13 am)

Do you find you get gray boxes when you’re looking at a web page with a Java applet (such as the Companies Office or JavaTester)?

You know you have the Sun JVM installed correctly, there are no traces of the Microsoft JVM, the plugin exists, but you can’t see it in either Firefox or IE?

I had this problem for some time, and have finally found the cause - I have a custom transform for deploying Java, which turned off automatic updates, set the default JVM, etc, and also accepted the EULA.  As of about 1.5.0 Update 6,  setting EULA to 0 means that the JVM looks for EULA.DLL, doesn’t find it, and silently dies.

Don’t set the EULA property to 0 anymore. Ignore it.

You also used to be able to turn off the Automatic Updates in the properties table, but you can’t any more.  You have to edit the MSI to run a registry script as the last action, and even then there are reports that Java will create the links on first-run.  I don’t want my workstations getting a pop-up message saying Java will update when I carefully select the version to deploy, thanks Sun!