Queries to remote servers through linked servers and distributed transactions.
7202
Could not find server in sys.serversA four-part name or OPENQUERY names a linked server that is not defined here.
7399
The OLE DB provider for linked server reported an errorThe linked server provider failed; the reason is the text after "reported an error."
7303
Cannot initialize the data source object of OLE DB provider for linked serverThe provider could not open its file, DSN or remote server; read the provider message.
7391
The provider was unable to begin a distributed transactionA transaction across a linked server needed MSDTC, which is stopped, closed to the network or blocked.
7411
Server is not configured for DATA ACCESS (or RPC)The linked server has rpc out (EXEC ... AT) or data access (OPENQUERY) switched off.
7416
Access to the remote server is denied because no login-mapping existsThe linked server has no mapping for your login and no default mapping for all logins.
7356
The OLE DB provider supplied inconsistent metadata for a columnA linked server provider described a remote column differently at compile time and at run time.
No errors in this category match your search. Search the whole library.
Other categories
- Constraint & Integrity 5
- Logins & Permissions 19
- Connectivity 9
- Syntax & Object Resolution 22
- Data Type & Conversion 15
- Concurrency & Locking 2
- Transactions 5
- Log & Storage Space 3
- Backup & Restore 15
- Database State & Recovery 13
- Corruption & Consistency 8
- Memory 6
- Query Processing & Performance 7
- High Availability 8
- SQL Server Agent 4