The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
34 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
59 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
98 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
397 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
221 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
53 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
267 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
321 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
333 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
6k 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
777 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. ...
0
votes
1answer
400 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
191 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
431 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
350 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
5k 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 ...
0
votes
0answers
177 views

SQL 2005 linked server to MS Access 2003 breaks after a while

On our production server, I linked to an unsecured Access 2003 mdb file which worked nicely for a few days. EXEC sp_addlinkedserver 'NUWDB', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', ...
1
vote
1answer
2k 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
511 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
211 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
462 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
395 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
13k 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
657 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
395 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
3answers
1k 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
2k 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 ...
2
votes
1answer
1k 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
536 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
998 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
551 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
397 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
374 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
6k 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
312 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
826 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
861 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
696 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 ...