SQL Server Linked Server Using Oracle OPS$ Windows Authenticated Account
Posted on 2016-10-13
I would like to create a Linked Server from a SQL Server 2008 Database to an Oracle 11g Database using my OPS$ Windows Authenticated account.
However, no matter what I try it doesn't want to work. It seems to expect a password, but neither leaving the Password blank, nor setting it to slash (/) seems to work.
Is this not allowed? If it is allowed, how do I go about establishing the link?