Problem Connecting to MS SQL Server 2005

Hello Friends:

I would appreciate a lot your help on the following situation.

I'm trying to connect to MS SQL Server 2005 but I'm getting the
following error while trying to execute a scaffold command:

C:\ruby\RoR1.2.6\rails\work\demoPba0>ruby script\generate scaffold
receta receta

      exists app/controllers/
      exists app/helpers/
      exists app/views/receta
      exists app/views/layouts/
      exists test/functional/
  dependency model
      exists app/models/
      exists test/unit/
      exists test/fixtures/
   identical app/models/receta.rb
   identical test/unit/receta_test.rb
   identical test/fixtures/recetas.yml
Open
    OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server
      [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access
denied.
    HRESULT error code:0x80020009
      Exception occurred.

I tried to follow step by step the instructions that appears in the
HowtoConnectToMicrsoftSQLServer article
(http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer):

1) I got and unpack the last DBI from
http://rubyforge.org/projects/ruby-dbi/
and I copied this file to my path
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb

2) I modified my .yml file demoPba0/config/database.yml
# => demoPba0 is the name of my app
# => demoPba0_development is the name of the DB

development:
  adapter: sqlserver
  database: demoPba0_development
  host: DBI:ADO:Provider=SQLOLEDB;Data Source=(local);Initial
Catalog=demoPba0_development;User Id=sa;Password=password1;
  username: sa
  password: password1

but the final result still is the same

My environment is: Windows XP SP2, Ruby 1.8.26, RoR 1.2.6, MS SQL Server
Enterprise 2005
All my environment is local.

Thanks in advance

I haven’t connected to a SQL Server 2005 database in awhile, but two things jump out at me. First, you don’t need to specify the username and password twice, but I don’t know if it matters in which place you do specify it. Second, replace (local) with localhost.

Let us know whether it works.

Regards,
Craig