Re: non-sa users get access denied in OLE DB query
- From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@xxxxxxxxxx>
- Date: Sat, 10 Feb 2007 08:31:04 +0100
Ad-hoc remote queries are disabled by default in SQL 2005. Check the
"Surface Area Configuration for Features (Ad Hoc Remote Queries) - Database
Engine " topic in BOL
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/fe754945-2cd2-4cc1-8ae1-4de01907b382.htm).
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
"Stu" <Stu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0896B540-3262-42A8-8D4E-97D900C35A91@xxxxxxxxxxxxxxxx
On SQL Server 2005, 64 bit, this query:
SELECT * FROM OPENROWSET('IBMDADB2', 'DSN=DB2T;', 'SELECT SCAC_CODE,
SCAC_NAME,SCAC_CITY, SCAC_ST, SCAC_STATUS FROM
MISDB2A.FASMSCAC_STD_CARRIER_CODE')
Gets this message:
Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'IBMDADB2' has been denied. You must
access
this provider through a linked server.
I works if it is run by the sa login, or by a login that has been granted
the sysadmin Server Role.
How can I permission non-sa logins to access the OLE DB provider?
.
- Prev by Date: Re: Stored Proc with unlimited parameters
- Next by Date: Re: how to get all the user permission in 1 query?
- Previous by thread: Stored Proc with unlimited parameters
- Next by thread: Re: non-sa users get access denied in OLE DB query
- Index(es):
Relevant Pages
|
