Changing MSDE Authentication Scheme After Installation

If you are using Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) you are supposed to decide if you are going to use “integrated windows authentification” only or if you are using “mixed mode authetication”. Latter is sometimes considered less secure but if you are developing ASP.NET applications it can be easier to use a non-NT user for the connection.

If you ever tried that you are surly familiar with the “login is not associated with a trusted connection” exception when trying to access the database. Today I had to install an ASP.NET application on a server with MSDE where mixed mode authentication was not available. A quick research on the net revieled a blog entry indicating how to change the authentication scheme of MSDE after the installation.

  • Stop the MSDE service
  • Search the registry for

    HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer

    (for unnamed instances) or

    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\

    (for named instances)

  • Change the key LoginMode to value 2.

Unlike a comment on the page, value 0 will not work (at least it didn’t in my case).

Opera for Free

Opera is now available for free, ads and registration have been removed.

Just gave it a quick try, and I have to say, I like it 😉 I think, Firefox is going to have to co-exist with Opera on my HDD.

Update: According to Heise.de (German), Opera has been downloaded over 1 million times within only two days, more than any previous (ad-enabled) version.

Server-Side Bookmarks: SiteBar

I currently work on several computers quite simultaniously and I am also browsing the net using these different machines. In past times this often caused that I had some bookmarks on computer A and others on computer B. According to Murphy’s Law, I always needed a link of a computer which was currently not available.

The solution to this problem is obvious: using a server based bookmark management. On my search for free solutions I found SiteBar which seems to be quite popular. It can be set up in different modes for shared bookmarks of many users and for individuals. I used the latter mode for my installation as it is to be used by me exclusively. Still, the installation features a public and private area for links so not all links can be seen by every visitor.

SiteBar integrates well with all browsers. I had no problems importing my bookmarks files from Firefox and I’ve now set up special shortcut links in my links list on all browser instances I use across the different computers to add the currently viewed site to my SiteBar. The “integrator page” lists several useful plugins for various browsers which allow (for some browsers) to sync local bookmarks and server bookmarks. This particularely solves the problem of bookmarks being only available if the server is online. The corresponding plugin for Firefox is in beta statdium at the moment and only supports syncing server to local bookmarks up to now.

At the moment, we are also evaluating to use SiteBar for the development team at our company to share important links to various resources.

Java and OLE: Commercial Libary

COM and ActiveX components are still important technologies for interoperation on Microsoft Windows. One of the powers of the .NET platform is easy integration with existing code in the mentioned form. For Java-developers, the idea of COM and ActiveX seems strange at a frist glance as it obviously kills platfrom independence, one of the key benefits and the USP of Java most often cited. Still, when focusing on the Windows desktop, integration of existing technologies, especially Micosoft Office, is often an important requirenment. A commercial library promissing easy integration of COM and ActiveX components in Java Swing applications can be found here.

FAQ: Java Console Handling

As it is one of the FAQs on every Java newsgroup or Java Mailinglists: “How to handle console?”

I came across a nice library that supports console operations on Windows, Linux and Mac OS: JLine.

Check it out, if you really need to work with the console on the mentioned platforms. The libarary works using native features, but I find the handling quite nice: the required DLL for Windows for instance is dynamically extracted from the JAR and loaded, so there is no need for a special installation.

JLine does not provide curses features at the moment, but it is a good approach if you need to read a password from standard in.

Gnus & IMAP: a superb combination

Gnus, a (X)Emacs based news- and mailclient has been my favorite newsreader for some years now. I used to use it for NNTP based usenet reading only and I really liked it for several reasons:

  • adaptive scoring, it just raised the score of articles I read and lowered the ones I didn’t read
  • flexible and configurable
  • works within X11 and also on a shell
  • available for both, Linux and Windows

Not so long time ago, when I started to play more actively with Gentoo on my home box, I realized for the first time in my Internet-life that mailinglists could be a good supplemental for my usenet feeds and for information retrieval, especially the gentoo-user list. I’ve had always gone around mailinglists because I didn’t find them as appealing and comfortable as newsgroups and I didn’t like the idea of my mailbox being filled with hundreds of postings, mixing with my ordinary mail. Since I got my own mailserver for hosting my domain, I finally figured out that I could easily get around this problem with server-side SIEVE scripts; i.e. server-side mail filtering that sorts all incoming messages of a given mailing list in a certain IMAP folder.

Now, I’ve read several times that Gnus works well with IMAP so I thought I’d give it a try. Let’s say I didn’t regret it. Gnus handles an IMAP backend quite as well as an NNTP backend, in fact, despite some minor differences in handling the expiration of posts there is no difference for me if I am reading my local NNTP mirror maintained with leafenode or if I am reading a mailinglist stored on an IMAP folder. All powerful scoring features I adore so much in Gnus just work on the IMAP feed as well, opening a new world of information retrieval as well.

I keep Gnus running most of the time within a screen backed shell on my server, allowing me access to NNTP and mailinglists from quite everywhere I can/want to log into my box. This is some sort of freedom I really like very much and makes Gnus really a good choice for me.

I already can here Pine-fans and mutt-fans arguing that pine/mutt/whatever handles the job as well as Gnus. Well, that sort of religious discussion never was interesting to me and I can just say: yes, I believe you. But after 4 years of continiously tweaking my Gnus configuration, it just got “perfect” for me. I mean, it does exactly what I want it to do, fitting my needs and tastes. Maybe hardly anyone else could work with my configuration, but that is one of the points I like about Gnus: it’s configurable to hell… 🙂

I think I am going to publish some parts of my .gnus config file as maybe some parts may be interesting. I confess, I have hardly any Lisp-knowlege, so most parts of the file are just taken from the documentation or from other websites. But maybe there are some parts someone else wants to see as well 🙂 And getting a working configuration as a starting point could be the way for some people to try out Gnus as well.

Update (2005-06-14)
As requested in the comments, my .gnus is now available for download. I obfuscated some server entries, please look out for any .invalid domain and replace it with your domain or namespace before using this file.

One Keyboard, One Mouse — Multiple PCs: synergy2

I commonly work on a desk with two or more computers, each having its own monitor, keyboard and mouse. It often got confusing which mouse and which keyboard to use when.

To be my saviour, Erik (see his blog as well) has pointed out a software called synergy2 to me, a software that emulates a KM-switch (Keyboard-Mouse-Switch) across multiple plattforms. The user simply configures the arrangement of the monitors on his desk (M1 is left of M2, M2 is above M3, …) and the mouse can be moved from computer A to computer B. Keyboard input follows the mouse in this case.

Still, every computer needs its own monitor, but I now have one single keyboard and one single mouse to handle them all. To be honest, after using this software for two weeks now, I can’t imaging working without it any more.

synergy2 claims to work with heterogenious Microsoft Windows 95/98/ME/2000/XP/2003, Mac OS X 10.2+, and any Unix X Server 11r4+ with XTEST extension.

Besides the really nice fact that one needs only one keyboard/mouse any more there are two additional goodies in using this software:

  • synergy2 (if configured to do so) synchronized the content of the clipboard among the clients. This really comes in handy if you are using one PC for research on the web and another one to work.
  • A nice feature is to synchronize the screen savers on the various computers so that all screen savers turn on at once and none turns on while you are working on another computer.

synergy2 works quite simply by defining a server (the computer with the real keyboard and mouse) and attaching clients to this server. The protocol used is unencrypted so be sure to use it only within trusted networks. You could however tunnel it over ssh to have an encrypted channel.

During my two weeks of experience in heavily using this software I only found some minor bugs/itches in using it: sometimes when coming back from screen saver on a client computer running Windows XP Prof with an XP-greeting screen and activated password after screensavers, the virtual keyboard is stuck with a simulated key, resulting in not being able to enter the correct password. As this is my notebook I could always fix the problem by pressing Ctrl+Alt+Del manually on the notebook’s native keyboard. Another way to get around this without using a native keyboard is to unlock the server screen and tell the synergy2-server to “Force Reconnect”. Unfortunately in the latter case the reconnect process takes several seconds before the slave screens can be re-entered with the mouse.

So, if you are using several PCs on the same desk at the same time, each with its own monitor, you should definitely give synergy2 a try. I’m quite sure, it will revolutionize your everyday’s work just as it did in my case.