This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Hello, sorry but am not familiar with the following 7 Linked Servers - Providers listed in my provided image screenshot.
When I right click on one of them it only gives me those 3 options.
These don't appear as normal Linked Servers where can right click and [Script Linked Server as] -> [CREATE To] -> [New Query Editor Window]
These appear to be some Microsoft Excel or some other system generated Providers (not manually human created)...please correct me if I'm wrong.
I need to do a migration upgrade to another new server and am wondering if these are needed to be included and if yes how to copy/script out these 7 items from old server to be added to new server?
Or if needed to re-create from scratch...how to do it?
And what security permissions are related if it needs? (Like I mentioned not like normal Linked Server with Login Name & PW)
Thanks in advance.
Reason I believe they are auto generated by some system program (not human made) because I came across this link which lists similar
https://anishshenoy57.wordpress.com/2013/02/20/allow-inprocess-in-sql-server/
And same in my case when I right click Properties on one of them it shows "Allow Inprocess"
Thanks in advance.
To create a linked server for a remote data soure, you need an OLE DB provider. The Providers node lists the currently available OLE DB providers. Some of these come with SQL Server itself. I believe this is true for all providers in your screenshot.
If you would need to create a linked server to, say, Oracle, you would first need to install an OLE DB provider for Oracle.
Thanks Erland for your help. But am confused which program(s) or how those were created by. Those Linked Servers do not appear to be conventional Linked Severs with Login name & PW with limited information and to Script out to re-create or further Properties.
Sincerely
They are not linked servers. They are OLE DB providers, which you use to set up linked server. Building blocks, so to speak. Some OLE DB providers are installed with SQL Server. Others may be installed separately. And they are always installed outside SQL Server. In theory, you could install an OLE DB provider, because you have another software that needs that provider.
Thanks Erland for help clarifying more.
Now it makes a little more sense why I can't right click and script them out.
Would you happen to know which program(s) (Excel, etc...) automatically creates those and how to do it?
And after they get created are they standard/open to the Public for any connection to use or are there some specific security portion that only the original program and/or Login-User which created can use them?
Sorry, just trying to understand this new concept being that they're listed within Linked Server but they are not and are OLE DB providers instead.
Sincerely.
And after they get created are they standard/open to the Public for any connection to use or are there some specific security portion that only the original program and/or Login-User which created can use them?
Again, they are not linked server. They are tools to create a linked server. Although, that is true, they could be used through OPENROWSET direct, but that feature is disabled by default.
Would you happen to know which program(s) (Excel, etc...) automatically creates those and how to do it?
Most of these are installed when you install SQL Server. It seems that if you install Office, you get the ACE provider. (I have that provider installed, and I don't think I've installed it explicitly.) Another providers, for instance Oracle, you will have to install explicitly.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
These are the specified providers installed on the current computer. They are indeed automatically generated and do not require you to recreate them. I also have these on my server.
For more detailed information, you can review these documents.
Best regards,
Aniya
Thanks Aniya for your helpful reply.
How do these 7 items get auto created?
Like I mentioned am planning for an upgrade migration to another separate SQL Server and wondering how to copy these if necessary or how to re-create...along with their Security context.
These don't appear like regular Linked Servers with Login name & PW.
Sincerely.