Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [linked-server]

50 questions
2
votes
2 answers

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 through SSMS along with all our other databases being…
bvandrunen
  • 183
  • 2
  • 11
1
vote
2 answers

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 =…
Tim Lara
  • 187
  • 2
  • 8
1
vote
1 answer

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 Studio 2012? First, I have been able to do this before,…
Chad Harrison
  • 6,960
  • 10
  • 28
  • 41
1
vote
0 answers

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 ubuntu server and my sql server resides on Windows…
vini
  • 121
  • 4
1
vote
2 answers

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 employee logins. We also have a newer SQL Server 10…
jp2code
  • 175
  • 2
  • 13
1
vote
1 answer

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 @rmtsrvname = N'',…
dckrooney
  • 111
  • 1
  • 5
1
vote
1 answer

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 with the following…
cander
  • 113
  • 1
  • 3
1
vote
1 answer

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 connection, telling me that the "Oracle client and…
pete the pagan-gerbil
  • 181
  • 2
  • 13
1
vote
1 answer

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 the linked Sybase server down to the SQL2008…
ctrlalt313373
  • 211
  • 2
  • 7
1
vote
4 answers

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 is a big problem, because I don't know how to use a…
BlueRaja
  • 986
  • 1
  • 10
  • 17
0
votes
1 answer

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 from the old server to the new server, but still…
nano
  • 43
  • 1
  • 7
0
votes
1 answer

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, they are in different region so i used their public…
The One
  • 101
  • 5
0
votes
2 answers

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 I could schedule automated backups. Is this…
saturdayplace
  • 263
  • 3
  • 10
0
votes
0 answers

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.dbo.sp_addlinkedserver @server =…
BennyM
  • 101
  • 5
0
votes
2 answers

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 to a database on instance2 where certain criteria…
Fatherjack
  • 419
  • 3
  • 12
1
2
3 4