Category "linked-server"

Iterate through a list of servers in SQL Server

I have a script similar to below and get: Could not find server '@CURSERVER' in sys.servers. Verify that the correct server name was specified. If necessary, e

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server

I am trying to query data from linked server. It is giving me the following error: TNS:listener does not currently know of service requested in connect descrip

How to Connect SQL Server to MySQL using Linked Server ODBC Connection

I'm trying to create a linked server from my SQL Server to a MySQL db. No matter what I do, I get the following error: Cannot initialize the data source object

linked server : "No transaction is active." and "unable to begin a distributed transaction"

I have a CRM software on my local machine. In the SQL DB of the software, I added a linked server (our test website with our test DB: Windows Small Business Ser

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "xxxx"

In our SQL Server 2017 we have a linked server to a Microsoft Access file/database. There is a bunch of users who all log into SQL Server using Windows authenti

Can't select column name from Eloquence database that has a forward slash in it (from a linked server in SQL Server)

My SQL Server instance has a linked server to an Eloquence database. I need to select data from one of the tables in the Eloquence database, but I need to do i

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',

Login failed when querying linked server

I am trying to create a linked server in SQL Server: --Create the link to server "uranium" EXEC master.dbo.sp_addlinkedserver @server = N'uranium',