The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
12 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 ...
1
vote
0answers
37 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 ...
0
votes
1answer
135 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 ...
0
votes
1answer
107 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 ...
0
votes
1answer
140 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 ...
3
votes
3answers
749 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, ...
1
vote
2answers
254 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 ...
0
votes
2answers
61 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 ...
0
votes
1answer
308 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 ...
0
votes
1answer
457 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 ...
1
vote
1answer
442 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 ...
0
votes
2answers
9k 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
votes
1answer
1k 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. ...
1
vote
1answer
653 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 ...
1
vote
0answers
238 views

SQL 2005 to SQL 2000 Linked Server Update Error

I have a linked server from a 2005 instance to a 2000 instance that I am getting an error when trying to do an Update accross the linked server. This Update has worked for the past 2 years without ...
2
votes
2answers
563 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. ...
0
votes
1answer
478 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, but I would also like ...
6
votes
5answers
6k 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 ...
1
vote
1answer
3k 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 ...
0
votes
1answer
629 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 ...
1
vote
1answer
226 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
1answer
610 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 ...
2
votes
1answer
428 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 ...
4
votes
2answers
17k 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 ...
0
votes
1answer
713 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 ...
0
votes
1answer
431 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, ...
5
votes
4answers
2k 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 ...
4
votes
2answers
3k 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 ...
3
votes
1answer
2k 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 ...
1
vote
4answers
3k 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 ...
0
votes
2answers
567 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 ...
2
votes
2answers
1k 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 ...
4
votes
2answers
6k 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 ...
1
vote
1answer
1k 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 ...
0
votes
3answers
3k 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 ...
3
votes
4answers
1k 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
2answers
581 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 ...
2
votes
2answers
411 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 ...
1
vote
1answer
381 views

linked-server sql - access

I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access. When running ...
2
votes
3answers
7k 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 ...
1
vote
2answers
355 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 = ...
0
votes
2answers
948 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 ...
0
votes
2answers
980 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) ...
0
votes
1answer
710 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 ...