OraFAQ Forum: Client Tools » Oracle Services for Microsoft Transaction Server

Home » Other » Client Tools » Oracle Services for Microsoft Transaction Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Services for Microsoft Transaction Server [message #549587]

Mon, 02 April 2012 01:21

ashishs
Messages: 40
Registered: May 2011

Member

Hello,

I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection successed but when click on next it gives above error, pls tell which login i use that will allow me to go ahead.

Report message to a moderator

Re: Oracle Services for Microsoft Transaction Server [message #549590 is a reply to message #549587]

Mon, 02 April 2012 02:31

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

give full privileges(sysdba or sysoper) to the user(sys,system...),

You still don't understand what this is and that this is VERY VERY BAD.

Regards
Michel

Report message to a moderator

Re: Oracle Services for Microsoft Transaction Server [message #549592 is a reply to message #549590]

Mon, 02 April 2012 02:59

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

Stop using sys and system and create your own user. And don't grant them sysdba or sysoper, you don't need either of those privileges for this or almost anything else.

Report message to a moderator

Re: Oracle Services for Microsoft Transaction Server [message #549606 is a reply to message #549592]

Mon, 02 April 2012 04:24

ashishs
Messages: 40
Registered: May 2011

Member

Hello i try without give SYSDBA or SYSOPER privileges but still showing same error ,Pls dont mind sir you know about SSIS
(SQL Server integration services).

Report message to a moderator

Previous Topic:	sql developer data modeler version 3.0.0.700 is not backward compatible
Next Topic:	How to substitute value from a query in sqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 01:47:08 CDT 2025