Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [linked-server]

50 questions
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
0
votes
1 answer

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 from the old LAN to the new one and are now…
HashHazard
  • 156
  • 4
0
votes
1 answer

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 localhost to Server B. So, I'm wondering why I can't…
AbeP
  • 135
  • 2
  • 7
0
votes
2 answers

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) the SQL Server instance crashes. The logs say…
Hemanshu Bhojak
  • 111
  • 1
  • 4
0
votes
1 answer

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 great (albeit, slow over VPN) until the company had…
Brian Webster
  • 1,123
  • 1
  • 18
  • 39
0
votes
1 answer

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 was also able get results by running a query in a…
l3utterfly
  • 111
  • 2
0
votes
1 answer

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 information in 2008R2 - where you can in 2000 Note: This is…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
0
votes
2 answers

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 Windows 7. I don't have any issues creating the…
Nick O
  • 195
  • 1
  • 6
0
votes
1 answer

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 SQL Server. I'm using the wizard, and trying to…
Scriptonaut
  • 137
  • 6
0
votes
1 answer

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 Server 2008 asks me for a "Linked Server Name",…
Triynko
  • 3,418
  • 6
  • 31
  • 30
0
votes
1 answer

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 to be able to go the other way, ask the MSSQL server…
AndyD273
  • 207
  • 1
  • 11
0
votes
1 answer

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 was oracle 10g ,can some one please tell me how can…
Asha
  • 101
  • 3
0
votes
1 answer

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 server. On the reverse side, the 2000 server can…
ThaKidd KG5ORD
  • 329
  • 1
  • 7
  • 17
0
votes
1 answer

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, should be discarded. Msg 0, Level 20, State 0, Line…
Ved
  • 133
  • 1
  • 4
0
votes
3 answers

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 using identical configurations. When I right-click…
SomeGuy
  • 387
  • 1
  • 3
  • 16
1 2
3
4