Re: Can SQL Users have Access to A Win2k Share?
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 06/25/03
- Previous message: Dejan Sarka: "Re: Error 21002: [SQL-DMO] user 'username' already exist"
- In reply to: Luis Wiedemann: "Can SQL Users have Access to A Win2k Share?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 25 Jun 2003 10:05:18 +0200
Yes, they can use so-called proxy account for the xp_cmdshell operations.
Check the "xp_sqlagent_proxy_account" topic in Books OnLine
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ts
qlref.chm::/ts_xp_aa-sz_8sdm.htm).
-- Dejan Sarka, SQL Server MVP FAQ from Neil & others at: http://www.sqlserverfaq.com Please reply only to the newsgroups. PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Luis Wiedemann" <luis.wiedemann@florence[antispam]bank.com> wrote in message news:e4hQ12bODHA.2316@TK2MSFTNGP12.phx.gbl... > Hello All! > Because we use Netware and eDirectory for our directory services, we > installed SQL 2000 SP3 to not use Windows and SQL user account info, but > rather just the SQL user info. Now, because of a misunderstanding and lack > of competence from our service provider/data center, we have implemented a > new mission critical application that for some reason needs to see a share > on the server. No drives need to be mapped, it just seems that it wants to > know its there, then do its thing...is there a way to give sql users access > to a share? I would really hate having to deal with eDirectory in a mixed > environment! > > TIA > > Luis > >
- Previous message: Dejan Sarka: "Re: Error 21002: [SQL-DMO] user 'username' already exist"
- In reply to: Luis Wiedemann: "Can SQL Users have Access to A Win2k Share?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
