July 18, 2017 at 2:44 pm
Moving to new SQL Server, setup linked server, got dreaded 7302 initialize error i can tnsping any other ideas?
July 19, 2017 at 4:36 pm
tcronin 95651 - Tuesday, July 18, 2017 2:44 PMMoving to new SQL Server, setup linked server, got dreaded 7302 initialize error i can tnsping any other ideas?
In Management Studio, go to Server Objects, Linked Servers, Providers. Right click on the Oracle provider and select Allow Inprocess. After enabling that setting, try recreating your linked server.
Another thing to check would be to make sure you are using a current driver that is the same architecture (32 or 64 bit) as your SQL Server.
If you are using an OLEDB provider then you should also run dcomcnfg on the server to check the permissions of msdainitialize. And you may have to make some registry changes to allow you to customize the security settings. You can find a walk through on the dcom permissions as well as changing the registry if needed in the following link:
Troubleshooting “Cannot create an instance of OLE DB providerâ€
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply