Home » SQL & PL/SQL » Client Tools » Oracle Services for Microsoft Transaction Server
Oracle Services for Microsoft Transaction Server [message #549587] Mon, 02 April 2012 01:21 Go to next message
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.
Re: Oracle Services for Microsoft Transaction Server [message #549590 is a reply to message #549587] Mon, 02 April 2012 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle Services for Microsoft Transaction Server [message #549592 is a reply to message #549590] Mon, 02 April 2012 02:59 Go to previous messageGo to next message
cookiemonster
Messages: 12992
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.
Re: Oracle Services for Microsoft Transaction Server [message #549606 is a reply to message #549592] Mon, 02 April 2012 04:24 Go to previous message
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).
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:
  


Current Time: Sat Jan 20 20:03:35 CST 2018

Total time taken to generate the page: 0.24814 seconds