Questions tagged [linked-server]
The linked-server tag has no usage guidance.
50
questions
1
vote
1
answer
128
views
Is it possible to create a linked server between the ServiceNow ODBC driver and an AWS/RDS SQL Server instance?
I have an internal .NET 7 web application that uses an MSSQL database hosted on Amazon RDS.
I have a requirement to create a linked server to query data from a separate ServiceNow DB instance.
The ...
- 280
0
votes
1
answer
503
views
SQL Server Linked Server readonly as security measure
I've got a configuration with to separate VLANs. In one of te VLANs, a Microsoft SQL server is running and doing it's thing. I'd like to read (and only read) data from this server from the second VLAN....
0
votes
1
answer
608
views
domain connecting to localhost and links not working (ERR_CONNECTION_REFUSED)
I'm having trouble to get my website properly online, which I created/designed in Wordpress.
I have bought a domain and rented a WordPress hosting server. I have uploaded my whole WordPress folder ...
- 1
0
votes
1
answer
579
views
List Everything that uses a linked server in sql
I am currently facing an issue communicating with a SQL server which has been moved and the database which I was looking info has been removed. I have been using an alias manager to divert all traffic ...
- 53
-1
votes
1
answer
266
views
Difference between www.sub.example.com and sub.example.com [duplicate]
I want to know the difference between these two links to my site:
My site https://rahul62888282.000webhostapp.com is working as supposed.
https://www.rahul62888282.000webhostapp.com (with www) is ...
0
votes
1
answer
2k
views
Linked Server SQL 2016: Can't update transaction in remote server
I have 2 Windows servers EC2 located in different region. Both of them have public IP so they can communicate with each other.
In order to allow remote query, i created a linked server. Basically, ...
- 101
0
votes
0
answers
764
views
Self referencing linked server isn't working when using run as administrator
In an effort to mimic a production environment I've added a linked server in MSSQL that points to itself. This allows me to test SQL scripts which are run in production on my own machine.
EXEC master....
- 101
1
vote
1
answer
14k
views
ADSI Linked Server: Why can I query AD in VBA, but not as a Linked Server?
After all the reading and research I've done, this seems like the most logical place to post this question:
Why can I query Active Directory using VBA, but not a Linked Server in SQL Management ...
- 6,990
0
votes
1
answer
62
views
Crossserver SQL Procedures Failing Mid Process
Really need help understanding whats happening. We have two LANs at work with a shared subnet between them acting as a bridge (migration from A > B underway) we recently migrated the server subnet ...
- 156
1
vote
0
answers
83
views
Issue while setting up a DSN while creating a linked server
I am trying to set up a linked server to my sql from sql server. However I am encountering problems while setting up the dsn. Reffering this link for help.
My MySQL database resides on Amazon ec2 ...
- 121
0
votes
1
answer
557
views
SQL Server 2005 Linked Server using SSMS from laptop vs RDP
I connect to work network via Cisco VPN from my work laptop, which is on AD.
Edit
I am using SQL authentication to connect from Server A to B; in scenario #1 I can connect.
I can even connect from ...
- 135
0
votes
1
answer
537
views
Linked Servers in SQL Server
I have created a linked server and wish to execute a job that queries the linked server and writes the result in a local database.Ihave tested the connection to the linked server and it was fine. I ...
- 111
0
votes
1
answer
455
views
Cannot see linked server properties in SQL Server 2008 R2
I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000.
When viewing the properties of an existing linked you, you cannot see (or edit) any ...
- 5,293
3
votes
3
answers
5k
views
if I select more than 15 fields, I get catastrophic failure
Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it.
When I do select * or select field1,field2,field3....field15 I am getting this error:
Msg 7399, Level 16, State 1, ...
- 455
1
vote
2
answers
494
views
Authenticating Linked Servers - SQL Server 8 to SQL Server 10
We have an old SQL Server 2000 database that has to be kept because it is needed on our manufacturing machines. It also maintains our employee records, since they are needed on these machines for ...
- 175
0
votes
2
answers
123
views
Can not create a linked server between SQL Server 2008 on a desktop and my laptop
I'm having an issue getting the linked server to connect between a desktop and my laptop. Both have SQL server 2008 and the link is coming from the desktop to my laptop. Also, both computers have ...
- 195
0
votes
1
answer
596
views
Create ODBC Connection from Access to SQL Server
I need help connecting from a blank access 2010 database to my remote SQL Server 2005 database. This is because I'm going to write all my client apps in Access, and store everything on the server with ...
- 137
0
votes
1
answer
1k
views
How do I add a linked server in SQL Server 2008?
I want to pull some data into my queries from a remote server (also SQL Server 2008), because some related data is on the remote server but not the local server.
The "add linked server" wizard in SQL ...
- 3,418
1
vote
1
answer
3k
views
Adding a linked server via Powershell
I'm trying to add a linked server to my local SQL Server 2008 R2 setup from within a Powershell script.
Here's what I've been trying so far (and variants):
EXEC master.dbo.sp_addlinkedsrvlogin
@...
- 111
5
votes
2
answers
47k
views
How to successfully connect to Foxpro database files using MSSQL Linked Server feature and ODBC?
We're trying to access Foxpro file-based database files via MSSQL Server's linked server feature, using Foxpro ODBC driver.
For this, we've
installed the latest Foxpro ODBC Driver from Microsoft,
...
- 1,056
-1
votes
1
answer
2k
views
Create linked server from SQL Server 2008 to Intersystems Caché
The linked server has been created but failed a connection test. Do
you want to keep the linked server?
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft....
3
votes
1
answer
3k
views
Error when connecting to Named Instance as a Linked Server
I have a MS SQL2008 server running a root instance and a named instances.
SQL001\.
SQL001\Pilgrim
When I connected to SQL001\Pilgrim I can set-up a link to the default instance SQL001\. no ...
- 145
2
votes
2
answers
2k
views
Transfering BLOBS on a MSSQL -> MySQL Linked Server
Working on setting up a new MySQL database for a website, and I'm trying to figure out how to transfer over long strings.
I have quite a few MSSQL tables that have Varchars ranging from 500 to 2000.
...
- 207
0
votes
1
answer
1k
views
Linked server to MSSQL from MySQL
We are working on setting up a Linux server with MySQL on it as a testing server.
I got a linked server set up on our current MSSql server so that we can query the MySQL server.
I would also like ...
- 207
6
votes
5
answers
10k
views
Double hop problem with sql server 2008
I'm trying to set up the following scenario. I have 3 servers, they are all in same domain.
Server A has web application which runs under (domain) service account, dom\web.
Server B has instance of ...
- 61
1
vote
1
answer
6k
views
MS SQL 2008 - Setup Oracle Linked Server [SERVICE_NAME not given error]
I'm trying to setup a linked server on MS SQL 2008 R2 to an Oracle 11g server. I've got the Oracle client installed and sqlnet.ora, tnsnames.ora & listener.ora copied from the server and in place ...
- 113
0
votes
1
answer
847
views
sql Server 2008 R2(64 bit) and oracle 10g linked server
we are migrating from our old SQL server 2005 (32 bit) to a windows server 2008 R2 with SQL server 2008 installed on it (64 bit) . in the old server we had a linked server to our other server which ...
- 101
1
vote
1
answer
467
views
Problem adding Oracle to SQL 2005 as a Linked Server
I have a SQL 2005 server that I need to link to an Oracle server.
I've installed the Oracle client, and followed several sets of instructions found online. I have an error every time I test the ...
1
vote
1
answer
1k
views
SQL Server 2008 Replicating Linked Server Tables
I have a SQL2008 server with a linked Sybase server. I have several tables on the SQL2008 server that I need have merge replicated to some SQL2008 Express clients. I also need to get two tables from ...
- 211
2
votes
1
answer
858
views
How to create a shared lock blocking an intent exclusive lock
As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
- 136
10
votes
2
answers
72k
views
How to install Oracle OLE drivers for use in SQL Server 2008 R2 x64
As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our ...
- 387
0
votes
1
answer
1k
views
MSSQL 2005 > Linked Server Connection Fails > MSSQL 2000
At the company I work for, we currently are running 3xSQL 2005 servers and 1xSQL 2000 server. All of the 2005 servers can communicate with each other, however they cannot communicate with the 2000 ...
- 339
0
votes
1
answer
724
views
Sql server 2005 linked server to 2008 error A severe error occurred on the current command
I am able to query few tables on the linked server but few tables are giving me this error.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, ...
- 133
7
votes
4
answers
10k
views
Can SQL Server 2008 Linked Servers be edited? Is there the equivalent of an ALTER statement for Linked Servers?
I have a Linked Server which was made using SQL Server Management Studio 2008.
If the linked server destination changes, I will have to change the properties of it to direct to the right place.
But ...
- 289
4
votes
2
answers
5k
views
how does ping resolve to ipv4 on one machine, but ipv6 on another?
Background
I have two environments, TEST and STAGE. I use Microsoft Distributed Transaction Coordinator (MS DTC) with two linked 2008 SQL servers. A SQL job runs every couple of minutes and ...
- 337
3
votes
1
answer
5k
views
Trigger is not working on LInked Server. Both servers are SQL Server 2005
I have link a server with another server. I can access records from linked server and I can also insert record using INSERT statement like
INSERT INTO [LINKED-SERVER-IP].MyDb.dbo.Customer (CustomerId,...
- 193
1
vote
4
answers
5k
views
Can we have Linked Servers when using NTLM?
I don't have access to the Active Directory settings, nor do I have access to change anything on the linked server.
From everything I've read, it seems like this means I cannot use Kerberos - which ...
- 1,096
0
votes
3
answers
968
views
SQL Server 2005 - Oracle Linked servers stop working
[URGENT - PRODUCTION ISSUE]
All of a sudden, on a SQL Server 2005 instance, all the Linked Servers to Oracle stopped working. All other instances can connect to the linked servers without a problem ...
- 387
2
votes
2
answers
3k
views
SQL Server: severe error when querying a MySQL Linked Server
Hey, I have been having a problem with my linked servers. I am using Microsoft Server 2003 and Microsoft SQL Server Management Studio 2005.
The linked server is a MySQL database. It was defined ...
- 183
4
votes
2
answers
8k
views
How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?
I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been ...
- 71
3
votes
1
answer
3k
views
How do I add a self-referencing linked server in SQL 2008
I am trying to replicate our live server set up local using a single SQL database.
In SQL 2005 I would added 2 linked servers both referencing itself with different names, each point to a different ...
- 233
-1
votes
1
answer
7k
views
Access to the remote server is denied because no login-mapping exists
I've got a Linked Server in my SQL Express install that is using SQL Server Authentication.
I've created a SQL Server login-mapping and it's using Impersonate.
I've confirmed that the account exists ...
- 250
3
votes
4
answers
2k
views
Using linked servers to query across database servers?
We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The ...
0
votes
2
answers
1k
views
Backup a Linked MySQL DB through SQL Server Management Studio
I have a MySQL database that I'm able to query as a Linked Server through SQL Server Mgt Studio. I'm wondering if it's possible to create a backup task in Studio that will backup the MySQL DB, so that ...
- 263
2
votes
2
answers
493
views
Linking to oracle from SQL Server 2005, this sucks
I need to create a link server from SQL Server to Oracle, but I'm having no luck.
I've install the oracle 10g client software and I'm able to use TOAD for oracle and use ODBC to connect to the ...
- 209
2
votes
3
answers
12k
views
User cannot access a system DSN on Windows Server 2008
We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control ...
- 173
1
vote
2
answers
1k
views
Why can't I access stored procedures on a linked MSDE 8.x server?
I am trying to execute a stored procedure on a linked MSDE 8.x server by running the following SQL against the parent SQL Server 2000 instance...
DECLARE @RC int
EXECUTE @RC = [LINKED_SERVER_NAME].[...
- 187
0
votes
2
answers
2k
views
execute a script against a table on a different instance
Scenario
Its pretty involved to explain but I have a procedure that updates data in two databases on instance1 and as part of the process (its a cursor for relevant reasons) it needs to make updates ...
- 419
0
votes
2
answers
2k
views
SQL Server crashes when remote query fails
Setup:
I have a linked server setup on SQL Server 2005 which is pointing to an Oracle DB. The linked server has RPC enabled.
Problem: When a query throws an exception on the remote server (Oracle DB) ...
- 111
0
votes
1
answer
992
views
SQL Server 2005 - My Linked Servers to it are broken now!
I'm a programmer working over a VPN.
I use local databases most of the time, but my local SQL Server 2005 has "Link Server" server object pointing at the production server.
This has been working ...
- 1,123