Here’s the list of thing you have to do in order to connect to Microsoft SQL Server (tested on 2005) with integrated connection (without any usernames passwords).

1. Assuming you have installed Ruby on Rails. Go to Ruby\DBI and get the latest release of ruby-dbi package.
2. Extract the package to some temporary folder and find file in directory: \lib\dbd\ADO.rb.
3. Go to location of Rails installation (C:\Ruby by default) and traverse the directory path to: lib\ruby\site_ruby\1.8\DBD\
4. Create a directory ADO
5. Copy file ADO.rb (from the extracted package) to the newly created ADO directory.

This configuration will work for all you Rails applications.

In order to set up a proper connection to your database from your application edit config/database.yml file.

Here’s the example of what you should input if you use Windows Authentication.

adapter: sqlserver

database: Marcin

username:

password:

host: DBI:ADO:Provider=SQLOLEDB;Data Source=servername,port;Initial Catalog=databasename;Integrated Security=SSPI;Network=networkname_if_necessary;

Notice, that since we’re using Integrated Security we’re not leaving username and password blank. This greatly reduces the maintenance of this configuration file.

If you’re a Vista laptop owner you definitely want this application installed on your machine.

It’s a Vista Battery Saver !

What it does, is when you switch from A/C to batter it will disable Sidebar and Aero (all of this is of course configurable). I can squeeze out over 40 minutes more of battery time with this little application. Also, this is and open source project written in C#. Here’s the code. It’s a very interesting read.

Hope it helps.