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 ...
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 ...
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 ...
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 ...
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 ...
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
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 ...