coba ganti connection authenticationnya dari 'windows only' ke 'sql server authentication'... bisa diganti di sql server enterprise manager, klik kanan di servernya, properties, trus security. Pilih aunthenticationnya ke 'sql server and windows', jangan yang 'windows only'
Regards, Marcelino Ponty (Phone +62819 - 3223 54 84) "Ad Maiorem Dei Gloriam" ________________________________ From: "r...@_r!sa" <[email protected]> To: [email protected] Sent: Tuesday, February 24, 2009 10:31:27 PM Subject: [id-ruby] Gmn cara koneksi SQLServer ke RoR? rekan2 milist ruby ada yang tau cara ato udah pernah coba koneksi SQL Server ke RoR? saya dah coba ikutin langkah2 yang ada di: http://wiki. rubyonrails. org/rails/ pages/HowtoConne ctToMicrosoftSQL Server -udah install adapter SQL servernya -udah download Ruby-DBI, trus copy file ADO.rb ke /ruby/lib/ruby/ site_ruby/ 1.8/DBD/ADO/ ADO.rb -udah setting juga di file databse.YML- nya. adapter:sqlserver, database:db_ name, username:sa, password: , host:localhost tapi blum berhasil jg T_T waktu ngerunning localhost:3000, muncul pesan error sbb: " OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. HRESULT error code:0x80020009 Exception occurred." setau saya 'sa' kan password default di SQLServer di file sqlserver_adapter- nya juga di tulis klo default username:sa dan password: kira2 ni masalahnya kenapa ya? mohon bantuannya,, , terima kasih... [Non-text portions of this message have been removed]
