We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

Filter by
Sorted by
Tagged with
0
votes
0answers
680 views

SQL Server Linked Server Using ODBC DSN

I have a DSN that uses Integrated Security. I'm trying to setup a linked server that uses that DSN but I'm getting the error below. I have successfully tested my connection using another tool so I ...
1
vote
1answer
1k views

Strange Issue with SQL Server to Oracle Linked Server Select Query

I have a SQL Server (2014 SP2) with a linked server to an Oracle 11 database. I have a very simple select statement to an Oracle view which I know should return around 140k rows. But here's the ...
1
vote
0answers
514 views

Occasional Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error

I know that this issue has been discussed elsewhere and I already read it. Our problem is that this occurs only once a day (roughly), the rest of time everything works fine. SERVER RS Windows Server ...
0
votes
1answer
409 views

Latency appear to be an issue with linked server

A client have a data warehouse server with a linked server set-up. The data warehouse server is SQL Server 2014, while the linked server is a SQL Server, but version unknown. Those two servers was ...
2
votes
1answer
713 views

MySQL client out of memory - Linked Table MsSQL to MySQL

I'm currently having an issue on 2 out of 3 SQL servers when copying large amounts of data to a MySQL table. The MySQL table currently houses ~6 million records, and the query that is running is ...
0
votes
1answer
20 views

Calling Sproc From Another Server - runs as SA

I have a sproc on ServerA that calls another sproc on ServerB The servers are connected through linked server. When the sproc gets called on ServerA it is called by the user login. However, then on ...
0
votes
1answer
438 views

Crystal Reports - Linked Server Connection

We have SQL server 2012 and we connect another server which is on different domain using a Linked Server name-> 192.xx.xx.xx. I can query and view the 192.xx.xx.xx data using SQL Server. Now ...
7
votes
1answer
5k views

SQL Server --> Informix DB Linked Server

After about 3 days of trying, I am unable to create a linked server from SQL Server 2016 to Informix 11.5. I haven't tried this with other versions (2008R2, etc) since I wanted to set up the ...
2
votes
3answers
2k views

SQL Server - Linked Server error - Could not connect to server XYZ because

Server being used: SQL Server 2012 SP3 I just received a strange error (strange because it worked earlier) could not connect to server LNK_SRV because sa is not defined as a remote login Not sure ...
0
votes
1answer
64 views

Linked Server only for Select Statements?

In linked server concept can we run only select queries like below ? SELECT * FROM OPENQUERY([SERVER_NAME], 'SELECT * FROM DATABASE_NAME..TABLENAME') I have a job which runs through Linked server. ...
1
vote
1answer
945 views

ETL Issue failing with Timeout error

We have a ETL job which is running each day at 02:00 AM. Until last week the Job ran successfully with no issues. The ETL runs the extract by connecting through the Linked server to the PROD server. ...
1
vote
0answers
235 views

Unable to establish linked server connection to SSAS 2008 R2 server

I'm interested in gathering some DMV data from our SSAS cubes and store it on our management box. When I create the linked server for this effort I run into an error establishing the connection. ...
2
votes
1answer
35 views

Which is better: Selecting across linked servers vs migrating the database

I have a customer that needs to query a linked server to produce a report. They will be joining a linked server table with a local table. Is it better to just let them do the select across the ...
1
vote
0answers
349 views

Handling exceptions with INSERT-EXEC with linked server stored proc and table results

I am trying to capture failures for a remote (via linked server) stored procedure called within a local stored procedure. If the remote procedure fails (error connecting to server, etc) I want the ...
9
votes
1answer
905 views

What big limitations should I expect from Linked SQL Servers?

Our product is based on Microsoft SQL Server. Currently, we are using three databases, and have always deployed them on one SQL Server instance. The three database are OLTP, OLAP, and audit. The OLAP ...
2
votes
3answers
3k views

Copy whole database from SQL Server to SQL Server using linked server

I am using SQL Server 2014 Management Studio installed in my system. And using linked server I have connected to a linked server. Now here I need to copy whole database from linked server to my ...
0
votes
0answers
1k views

Msg 7399 - Query table in linked server received Authentication failed

I created a linked server, then I tried to query the table from the server. I received the following message: OLE DB provider "SQLNCLI11" for linked server "DBServer" returned message "Invalid ...
4
votes
3answers
1k views

Why is INSERT INTO … SELECT not copying all rows?

I have two servers, SERVER-01 and SERVER-00 (not their real names). SERVER-00 is a SQL Server 2005 Standard instance, SERVER-01 is a SQL Server 2014 Standard instance. I have this query that runs in a ...
-1
votes
1answer
418 views

Passing wildcard to Oracle from SQL Server Openquery

I want to pass a wildcard to Oracle from MS SQL Server like this... SELECT * FROM OPENQUERY(MY_LINKED_ORACLE_SERVER, 'SELECT * FROM MY_ORACLE_TABLE') I'm trying to get everything from table ...
2
votes
1answer
906 views

SQL Server 2016 - Catastrophic linked server error

I have an issue with connecting to a linked server from SQL Server 2016 to an Ingres 10.1 database via an Ingres 64bit driver ODBC connection setup - ODBC connection succeeds and the linked server ...
2
votes
1answer
527 views

How can I get partition elimination with a variable?

I have four identical tables on four servers that I need to query from a fifth. The fifth server is linked to the other four and has a view created to unify them. -- Servers 1-4 CREATE TABLE ...
5
votes
1answer
2k views

Slow Linked Server INSERTs on SQL Server 2014

My local and remote servers were all using SQL Server 2008 R2 but the local ones were recently upgraded to SQL Server 2014 and the performance of Remote Queries has been crippled (literally from ...
3
votes
1answer
975 views

Return text from PostgreSQL (9.6) to SQL Server from linked server query

I am trying to get text (15002 characters long) from PostgreSQL using a linked server from SQL Server 2012, using the official PostgreSQL ODBC driver in Windows. I try to pull data from Postgres ...
0
votes
0answers
828 views

Unable to update table using Oracle linked server : table corrupted?

I want to synchronize a SQLServer table (version 2008) with data coming from Oracle (11g). The query is quite simple, uses openquery and looks like: update t set field2 = tt.field2 from ...
0
votes
1answer
100 views

Installing MS SQL Server on Centos

Has anyone been able to install SQL Server on Centos 6? I am running Centos 6.8, and I can only find information on Centos 7. I know that SQL Server on Linux is still in its early stages. I’m curious ...
0
votes
0answers
459 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. not consistent

We have seen this problem before and fixed it by looking at the KERBOS configuration program. But now I have something odd. Both I and another DBA have the same SysAdmin perms to both boxes. But when ...
3
votes
2answers
5k views

What is Oracle equivalent for Linked Server and can you join with SQL Server?

In SQL Server I can create a view that is a join between two tables that are in completely different servers using Linked Server. If I change one of the servers from SQL Server to be Oracle, can I ...
1
vote
1answer
1k views

Insert openquery results into an existing table

I have a stored procedure that queries a linked DB2 server in this fashion: SET @sql='SELECT * FROM openquery(DB2,''SELECT column1, column2 FROM table'')' exec sp_executesql @sql I am trying to ...
2
votes
2answers
2k views

Never Ending OLEDB Wait for Linked Server

We created a linked server to connect SQL Server to our ERP (running UniVerse not SQL Server). It has worked fine in the past, but now any queries to the linked server just get stuck (for days) with ...
0
votes
0answers
62 views

Data Dump Lag With Open Query (MySQL Linked to SQL Server 2016)

I have a SQL Server 2016 instance and a MySQL instance, where both are on seperate VMs running on the SAME physical server. The MySQL is linked to SQL Server. My question is, what are possible ...
4
votes
1answer
494 views

Reindexing / rebuild Indexes on Linked Server tables

I am trying to run the below query to rebuild the index on a table on the Linked server, but it is not working. Can any one please let me know what I am doing wrong? ALTER INDEX ALL ON [...
2
votes
0answers
71 views

TVF Poor Performance with Linked Query

I have an inline TVF that take much longer to run than should be necessary. The issue looks to be the Linked Server reference. The Linked Server is SQL Server 2012. The server with the TVF is SQL ...
2
votes
0answers
180 views

SQL Server 2008R2 Linked Server to SQL Server 2000 showing incorrect server

I have 2 servers and 4 instances Server 1 (SQL Server 2008R2) has instance a,b,c Server 2 (SQL Server 2000) has instance d I created a linked server from server 1 instance c to server 2 instance d. ...
0
votes
1answer
48 views

If the login credentials are in the ODBC connection, which security connection setting to use?

We have a linked PostgreSQL server and the remote login and password are parsed using the ODBC settings on the Windows server. Under the Security tab in Linked Server Properties within SQL, which ...
1
vote
1answer
341 views

Using linked server from Windows 10 PC [closed]

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error: Login ...
3
votes
1answer
294 views

OLAP linked server fails connection test

I am trying to create a new linked server to an Analysis Services database and I would like to use this linked server to import data into a SQL Server table. example: SELECT * into raw.example ...
0
votes
1answer
38 views

Syntax for using Oracle Linked Server with USE keyword

I am working on a task where some tables from Oracle Peoplesoft have to pulled into SQL 2014. The concerned person gave me the following code and I see that in the end he mentions the comment Use /* ...
3
votes
0answers
900 views

SQL Server: ODBC Linked Server to Oracle does not return all rows

Let's say we have one SQL Server instance on one side: SQL Server 2008 R2 SP3 Oracle 11.2 client installed with OLEDB Drivers for ODBC .. and an Oracle database instance on another side: Oracle ...
0
votes
2answers
187 views

Querying 'random' Oracle data via openquery in SQL Server returning the same data for multiple runs

I'm asked to help a developer figure out why the "random" data we should be getting from Oracle is exactly the same results each time you run it, rather than being actually random. SQL 2012, Oracle ...
1
vote
2answers
98 views

OLTP - Stretch database vs linked server

From my understanding, when you enable the StretchDB feature for a table, basically creates a Linked Server locally, which has a remote server as a target to move data to. If this is correct, does ...
1
vote
0answers
329 views

Connect to a SQL Server Mirror from Oracle Database

I know we can create a database link to connect to a Microsoft SQL Server from Oracle database. But the problem which I faced with is the SQL database which I want to connect to has a mirror fail-over ...
2
votes
1answer
511 views

Get-MSSQLLinkPasswords Powershell script doesn't seem to work under SQL Server 2016

I've been using the Get-MSSQLLinkPasswords Powershell script for a long time and it has been a huge help. The script decrypts the passwords for all linked servers on a particular Windows server and ...
0
votes
1answer
90 views

Extracting data from people soft db to SQL Server

I have a requirement to create a new database on SQL Server from an existing Peoplesoft database, which is on oracle. I already have the script with me, and I want to know if the data can be extracted ...
0
votes
1answer
36 views

Linked-server query against remote DB does NOT fail when DB is in SINGLE_USER mode

This is really strange to me. I have a primary server Foo2005 and it has a linked-server entry pointing to Bar2008R2; say the name of the linked-server is BarLINK. I write a query such as SELECT * ...
0
votes
2answers
818 views

SQL Server query across several linked servers - abysmal performance

There are three different databases on a three separate linked servers SQL0, SQL1 (hosting 2 dbs), SQL2 (hosting 1 db). SQL0 acts as a reporting server and will host all the databases in question (...
1
vote
1answer
6k views

Update linked server table based on local table

i'm trying to update a remote table using linked server, based on id of my local table. I'm trying this: update [HQSQLHOM01\SQLHOM01].dba_teste.dbo.tabela2 set [HQSQLHOM01\SQLHOM01]....
1
vote
1answer
465 views

Is there a limit on query time for an Oracle linked server?

We've created a stored procedure to pull in full copies of some Oracle tables with a Linked Server. Over the course of 11 hours, the procedure correctly populated the first 11 tables but failed with ...
3
votes
1answer
393 views

Data read from linked server returns different data-type on production server

I have a SQL Server grabbing data from a linked Oracle server inside a SP. On my development server, EF6 insists the SP is returning a double datatype for one of the columns, but in prod, it insists ...
0
votes
1answer
136 views

Query slowness after migration from sql server 2000 to 2014

I'm not a DBA. I have two servers. One of them runs on sql server 2000, the other on sql server 2014. Both have almost identical hardware (2014 has more RAM). My job is to migrate all databases and ...
0
votes
0answers
23 views

error no 55, while creating a linked server

m stuck in creating a link server.. please help if you know the solution. find the screenshot below. TIA