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:
SSMS connect to Oracle Server data:
More testing information
I also use "SQLPLUS" to check tnsnames.ora the file is okay or not but the answer is as following
- sqlplus SYS/Oradoc_db1@DBNAME as SYSDBA <– is okay
- sqlplus SYS/Oradoc_db1@DBNAME <– Error
Best Answer
I found the problem and you can follow my steps to fix this issue.
1. Don't use SYS to be your USERID
2. Add new USERID