I get the following error message when trying to connect to ms sql
OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
Login failed for user ‘XXXXXXXX’.
HRESULT error code:0x80020009
I google’d for those error codes but nothing useful so far. To set up
ruby for ms sql server, I followed the instructions here:
I followed the first 2 steps (copying ado.rb and modifying
database.yml) but I cannot get it to connect to the sql server.
Ofcourse, I have verified that the credentials are good since I am able
to connect to the server from other interfaces.
Also, is there a way to force ruby to use windows authentication for
connecting to sql servers?
Any tips, thoughts?
thanks in advance,