# SQL Server Msg 7399: OLE DB provider reported an error — linked server query failed

**Code:** `7399` · **Category:** SQL · **Seen on:** SQL Server, Windows

A query to a linked server failed because the provider couldn't connect, authenticate or run it.

## Meaning

Test the linked server (`EXEC sp_testlinkedserver`), check login mappings, firewall/port, the provider (MSOLEDBSQL, ACE), RPC/RPC Out settings and that the remote object exists. "Cannot initialize the data source object" usually means a provider or credentials problem.

## Common causes

- Login mapping missing or wrong password
- Remote server unreachable/firewalled
- Provider not installed or 32/64-bit mismatch
- RPC Out disabled
- Remote object name wrong

## Quick fix

1. `EXEC sp_testlinkedserver 'LS'`
2. Fix the login mapping and provider
3. Enable RPC / RPC Out for stored procedures

## Detailed fix by platform

### SQL

1. 

```sql
EXEC sp_testlinkedserver N'REMOTE1';
EXEC sp_serveroption 'REMOTE1', 'rpc out', 'true';
```


## How to diagnose

1. **Test** — Passes?
2. **Mapping** — Valid?
3. **Provider** — Installed?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/mssql-linked-server-ole-db-error-7399)
