--M4mu9Z6lzgzou9+T6F6
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

What type of authentication does your SQL Server use?  Windows or SQL
Server?  If it's configured to use SQL Server auth, then it has no idea
who the user 'domain\<username>' is, since that's an AD user, not a SQL
user.

On Fri, 2010-10-22 at 16:21 -0500, Ruby Mania wrote:

> My Connection String:
> def open(database)
>         # Open ADO connection to the SQL Server database
>         connection_string  "ProviderLOLEDB.1;"
>         connection_string << "Persist Security Infoł±se;"
>         connection_string << "User ID@username};"
>         connection_string << "password@password};"
>         connection_string << "Initial Catalogdatabase};"
>         connection_string << "Data Source@host};"
>         connection_string << "Network Library„ķmssocn"
>   @connection  IN32OLE.new('ADODB.Connection')
>   @connection.Open(connection_string)
> end
> 
> The string gives error when I using the domain credentials. EG:
> 
> Username: domain\<username>
> Password: whatever
> 
> Error:
> OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
> Login failed for user 'domain\<username>'.
> 
> Please help !
> Thanks ton !
> 

--M4mu9Z6lzgzou9+T6F6--