Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

Filter by
Sorted by
Tagged with
0
votes
1answer
239 views

Affected rows after update with OpenQuery

Is there a way to get the affected row count, when updating through an connection server? I'm using MSSQL connected to MySQL with ODBC. UPDATE OPENQUERY (MyConnection, 'UPDATE recordid, status FROM ...
2
votes
0answers
134 views

why is update from a join containing zero records taking a minute and 20 seconds?

SQL Server 2008R2. I have a simple join that returns zero rows in less than a second. When I try to run an update on that join, it should also take less than a second but it is taking one minute and ...
0
votes
0answers
220 views

Make the linked server ask for password

Till today i am using the linked server with the user of sql having same username and password in both the servers. For now on i can not keep the 2 servers password same for some reason and i still ...
0
votes
1answer
152 views

Can a contained database SQL User be mapped to a remote user in a linked server?

Using SQL Server 2017 Standard CU8 on Windows Server 2016. I've create a contained database user (user defined only within a database with Containment type: partial) with type SQL user with password (...
1
vote
1answer
174 views

ORA 01861 error

I am reading a date from a linked serve and it returns the field in the datetime2 format. Here is my simplified query: select * from openquery(LinkedServer, 'select QCTL.INVC_HEADER.POST_DATE ...
2
votes
2answers
809 views

When setting up security for linked servers, what does the Impersonate checkbox do?

Question: what does this checkbox do?
0
votes
1answer
1k views

Oracle Linked Server in Azure SQL Database Managed Instance

I am migrating my On Premise SQL Server to Azure SQL Database Managed Instance. But I have linked server to Oracle database in my SQL Server. Can we create linked server to an On Premise Oracle ...
2
votes
1answer
412 views

How do I encrypt data to be decrypted on a linked server? SQL

I have been searching for 2 days for the solution to this, but every solution does not apply to my situation. I have 2 SQL servers: DataServer and InterfaceServer set up as linked servers. DataServer ...
3
votes
1answer
4k views

Check if table exists on a linked server

I've had a search, but can't find a post relating to this instance specifically. We have a linked production database that I'm trying to reference from our 'sandbox' server. I want to check if a ...
2
votes
0answers
424 views

Secondary Replica Read-Only Routing via Linked Server working from one server, but not the other

I have been given the task of setting up a read-only linked server on ServerA to Availability Group listener ListnerX. ListnerX points to ServerY or ServerZ (ServerY is usually the primary). Read-only ...
0
votes
0answers
211 views

Linked server Informix driver mismatch error on driver and applciation

I tried to read all the questions here that has been asked before, but could not find any clue on my problem. I'm trying to setup a linked server to connect on INFORMIX server, I installed the driver,...
0
votes
0answers
1k views

SQL 2014 Linked Server Login Timeout

I'm having an issue where an application (MS Nav 2015) invoked query (Select) on occasion is receiving a login timeout. This issue happen sporadically, and the query itself is run at 15 minute ...
2
votes
1answer
125 views

Problem with data insertion in Oracle table from SQL Server table

We have SQL server and Oracle server, and have configured a linked server from SQL Server to Oracle. I'm trying to insert 10,000 rows from SQL Server into a table in Oracle. When I insert 100,000 ...
1
vote
1answer
1k views

Replication from Azure SQL Database table to On-premise SQL Server possible?

I have a table on Azure SQL Database that I would like to have replicated/mirrored to our on-premise SQL Server So the on-prem SQL Server would have a copy of table from Azure that is always up-to-...
1
vote
2answers
405 views

Azure SQL Db Linked Server - Secured Connection Methods?

The developers want a linked server from our on-prem server to our Azure SQL Db (DBaaS) in order to complete a nightly data pull into our data warehouse. I'd much rather go the route of SSIS but don'...
1
vote
2answers
3k views

Joining table from Linked Server is very slow

I have a production SQL server and a linked server (Azure SQL Database) I join two tables to do update Table A - small table A in TempDB that has only 100 rows on SQL Server Table B - on linked ...
1
vote
0answers
62 views

Decoding timestamp number in “change in schema version between compile time and run time”

I am trying to track down a "who/why" for the error <...> reported a change in schema version between compile time ("185302088475260") and run time ("185448117384521") for table <...> I ...
0
votes
1answer
606 views

SQLCMD to connect to Linked server

I'm getting a login error with the below sqlcmd to connect to a linked server: SQLCMD -E -dlinkedserver -ig:\temp\script.sql -o g:\temp\test.txt My linked server which is an oracle connects through ...
1
vote
1answer
653 views

Cannot run a job to update table on a linked server

I am running SQL Server 2012 on a server (server 1) and have set up a job to run a stored procedure which will summarize data from a series of tables and update a table on a linked server (server 2) ...
2
votes
1answer
4k views

“SQLNCLI11” for linked server “linkedserver” returned message “The transaction manager has disabled its support for remote/network transactions.”

I have a database in a SQL Server 2014 AG group (AG1).- two nodes. On both nodes, a linked server is set up. I am selecting data from a table from AG group (AG1) database and inserting into a ...
0
votes
1answer
2k views

Linking SQL servers error

When i try to connect a linked server, i´ll get this error message : TITLE: Microsoft SQL Server Management Studio The linked server has been created but failed a connection test. Do you want to ...
4
votes
2answers
641 views

Error while copying data over linked server

I am trying to copy the contents of 1 table from one database to another over a linked server. I am using the following query to do so insert into [Schema].[Table] select * from [Server].[Database]...
0
votes
1answer
842 views

Linked Server - Double Hop - Kerberos - TCP

I am having trouble with a Linked Server. I would typically not use a linked server, but legacy issues are forcing my hand. I am attempting to set up a linked server between two new production SQL ...
0
votes
1answer
6k views

Linked server from MSSQL to Oracle Issue

Last week we began having an issue with a Linked Server to an Oracle database on one of our MSSQL Servers. If I use the linked server on the MSSQL server it works fine. However, if i try to use it ...
1
vote
2answers
1k views

SQL Server link to MySQL reports “using password: no”

I would like to access a MySQL database from within SQL Server. I created a system DSN, and it tests OK. I created a linked server in SQL Server: Provider = Microsoft OLE DB Provider for ODBC ...
1
vote
0answers
31 views

sp_start_job only running 20 times concurrently - can I adjust?

I have a procedure that has a loop that calls sp_start_job to run a query against multiple linked servers. Each run of the loop calls a job that queries a specific linked server. (An openquery that ...
1
vote
1answer
988 views

Linked SQL Server Issue

I have 3 servers all running Windows Server 2016 Datacenter: Server1 is a domain controller and has ssms installed for accessing SQL Server Instances on Server2 and Server3 Server2 & Server3 are ...
0
votes
1answer
756 views

Linked Server Insert Permission

Msg 229, Level 14, State 5, Line 1 The INSERT permission was denied on the object 'object_name', database 'database_2', schema 'dbo'. Above is the error. I have a linked server set up (set up in prod ...
1
vote
1answer
547 views

Direct vs Linked Server Connection in Query Execution Time

After investigating our ETL Process for months i fell into something strange. We have one machine (A) which we are using in order to pull data from other machines (B). When i make a SELECT Statement ...
0
votes
0answers
271 views

Same Domain Linked Server Login Failing

I have several SQL Server instances. All of them are setup in the same domain, and have been working for years. One of these instances serves as an aggregator for the data of the others, and a sync ...
1
vote
3answers
1k views

Delete and Insert performance SQL Server

I have the below stored procedure that is taking close to an hour to complete. The result set is about 200K machines. All I am doing is extracting a set of ids from a linked server, deleting those ...
1
vote
1answer
472 views

Source code of View of Linked server sp_HelpText

How to use sp_helptext for view on the linked server ?
7
votes
2answers
7k views

Using INSERT INTO…EXEC AT linked server into temp table fails with Msg 7391

I am using SQL Server 2014. I want to execute EXEC (@remotecmd) AT [server_name]; (@remotecmd is a dynamic sql not a stored procedure) into ##eapb. My code is insert into ##eapb EXEC (@remotecmd) AT [...
0
votes
2answers
65 views

Database Files through Linked Servers

Is there another way to create a script that I can see all database files with their disk space details across databases and across servers? I can do it through Registered Servers. But I want to ...
0
votes
1answer
2k views

Table-Valued Functions from Linked Server

Why does when I try to run: SELECT * FROM [servername].master.sys.dm_os_volume_stats(1, 1) AS btb (NOLOCK) I get error: Msg 195, Level 15, State 15, Line 45 'servername.master.sys....
0
votes
0answers
2k views

Date format incompatibility in linked server between SQL Server and Oracle

When I select data from Oracle to SQL Server via linked server I get exception SELECT CreationDate FROM OPENQUERY (ORCLS, 'Select CreationDate from ADMIN.CV_TMP_Subscrs_Stage4_List') Msg ...
0
votes
1answer
2k views

Can't install a OLE DB Provider for IBM DB2 ISeries on SQL Servers higher than 2008 version

I've currently had a SQL Server 2008 server, which we now need to migrate to a newer edition. We have a couple of linked servers which I have not set up personally which utilizes a provider called ...
0
votes
1answer
172 views

Linked server to Oracle doesn't use filters. Are there any performance changes in different versions of SQL Server?

My customer somehow only has SQL Server 2005 instance. It has linked server to oracle database. I've noticed that sql server doesn't send any filters to oracle side and apply them only after it ...
2
votes
2answers
6k views

Creating Linked Server - Impersonation of Windows Authentication

I am trying to set up a linked server on Server A to Server B using windows authentication. Using SSMS, I can connect to both Server A (from ServerB) and Server B (From Server A) using Windows ...
2
votes
1answer
447 views

SQL Server Linked Table in Access DB

I'm wondering if/how an SQL Server would be impacted by an Access DB that has ODBC Read-Only linked tables from that SQL Server on it. If a form event triggers a query on one of those linked tables, ...
0
votes
1answer
28 views

Linked Server Creation Error

This is a strange issue, i am unable to create linked server using provider Oracle Provider for OLE DB. But am able to connect to it using sqlplus, was able to do telnet and tnsping. when i'm trying ...
0
votes
1answer
670 views

Slow performance when using a synonym that is configured to use a linked server

Situation: I’m not sure if I should be embarrassed that we did this, or if we should be applauded. Anyways, we have a shell of a database that has synonyms pointing to another server via a linked ...
2
votes
0answers
85 views

Linked servers not ignoring case after reboot

We have a SQL Server 2014 database with collation SQL_Latin1_General_CP1_CI_AS, which is case insensitive. It is linked to another SQL server database with the same collation. The second database ...
0
votes
1answer
469 views

Can Select but not Insert from SQL Server to MySQL

I'm having a problem with inserting data from SQL Server to MySQL. I saw this syntax that helped others: EXEC master.dbo.sp_addlinkedserver @server='MYSQL', @srvproduct='MySQL', @provider='MSDASQL', @...
0
votes
2answers
3k views

SQL linked server returning error suddenly upon query

We are facing error when trying to connect to and execute queries using a linked server. The SQL Server and the Linked Server are able to ping and telnet each other. Also testing the link returns ...
7
votes
1answer
3k views

Query External LDAP Server from SQL Server

I have done extensive research on querying LDAP Server but so far has not been able to work around. Therefore, asking experts help Background: I have a client whose LDAP Server is OnPremise (though ...
2
votes
1answer
501 views

SQL Job Step timeout

If a SQL Agent job step executing a stored procedure on a linked server times out, does the agent kill the SPID on the linked server or does it continue to run on the linked server?
3
votes
1answer
2k views

Making dynamic queries for linked server in SQL Server

I want to create a dynamic query in SQL Server which will run on linked server. I am trying to do it as follows. USE [MYDB] GO DECLARE @company AS nvarchar(50); DECLARE @id nvarchar(MAX); DECLARE @...
10
votes
1answer
9k views

8000 character limit on OPENQUERY against a linked server

I have a query that I'm trying to run through OPENQUERY on SSRS/SQL Server 2014, but I keep getting an error of: The character string that starts with [...] is too long. Maximum length is 8000. Is ...
1
vote
1answer
2k views

Windows Authentication for SQL Server Linked Servers

Currently, on our project, we have a situation: there are a SQL Server 2012 instance IA in domain A and MS SQL Server 2012 instance IB in domain B. Domains A and B are trusted. IB configured as the ...

1 2
3
4 5
11