Skip to main content
6 of 6
added 27 characters in body
Willie Cheng
  • 271
  • 1
  • 3
  • 12

SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"?

I've tried many methods as following to show you what I did right now:
Oracle client connect to Oracle Server data:

enter image description here

SSMS connect to Oracle Server data:

enter image description here

enter image description here

enter image description here

More testing information
I also use "SQLPLUS" to check tnsnames.ora the file is okay or not but the answer is as following

  1. sqlplus SYS/Oradoc_db1@DBNAME as SYSDBA <-- is okay
  2. sqlplus SYS/Oradoc_db1@DBNAME <-- Error

enter image description here

enter image description here

Willie Cheng
  • 271
  • 1
  • 3
  • 12