Tagged Questions
1
vote
2answers
90 views
Working Linked Server Query fails in sp_send_dbmail
Take the following example:
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'me@whatever.co.uk' ,
@query = 'SELECT TOP 10 * FROM LINKEDSERVERA.DATABASE.dbo.TABLE' ,
@attach_query_result_as_file = N'True' ...
1
vote
1answer
60 views
How do I specify a linked server to a remote database over tcp/ip?
I have a remote database running on an IAAS provider and I need to be able to execute joined queries from my local workstation. I am having trouble because when I attempt to create the link it is ...
0
votes
1answer
60 views
BUILTIN\Administrators allowing access via linked server but not locally
We have two servers:
LYNDB01 & LYNDB02
On LYNDB01 we have a database called db_ExampleDatabase
We have created a Linked Server on LYNDB02 to LYNDB01 using no mappings and the "Be made using the ...
0
votes
1answer
325 views
How to fix “The OLE DB provider ”MSOLAP“ has not been registered”?
Here's the code I'm using to register a linked server to SSAS:
USE [master];
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'ServerAlias',
@srvproduct = N'',
@provider= N'MSOLAP',
...
2
votes
1answer
54 views
Pervasive linked server provider missing
I am having the same problem as this question.
I installed Pervasive v11 (which does have 64bit ODBC drivers) and I still do not see Pervasive listed as a provider when trying to create a linked ...
0
votes
2answers
1k views
SQL Server : Is it possible to have a linked server link to another linked server?
Hello to all and thanks ahead of time for taking the time to look at my question!
I'm trying to do a work-around to access a 32bit Advantage Database Server 8.1 database with 64bit SQL Server 2008R2.
...
3
votes
2answers
137 views
Sudden Query Performance Degradation On A Linked Server
I have an application that uses a view on a SQL Server 2008 R2 instance. This view actually queries a linked server (SQL Server 2008) that has replicated data from our main ERP database. Yesterday, we ...
6
votes
1answer
260 views
Is there a way to DENY CRUD operations on connections from linked server?
I have a SQL Server instance, RPT1 (2008 R2), that was set up for "power users" to run their own queries. This server is linked to our production reporting server, PRD1 (SQL Server 2008 instance), ...
2
votes
1answer
1k views
Linked servers: Transaction context in use by another session
I'm using linked servers to perform some queries in a distributed transaction. It doesn't work in a distributed transaction. I get the following error:
Transaction context in use by another ...
3
votes
2answers
1k views
Linked servers login failure: Impersonate works, Username/password fails
I'm trying to set up a linked server between 2 instances of Sql Server 2008 R2.
The login works perfectly when I select the impersonate option. However when I try to use the remote user/password ...
2
votes
1answer
388 views
Correct SQL Server linked server connection settings to MySQL that will allow inserts
I'm in linked server hell! I've created a linked server to a remote MySQL database. I'm able to query and do updates. However when I attempt an insert I get an error:
"[MySQL][ODBC 5.1 ...
