 | |
MAPI and ActiveX Script
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
MAPI and ActiveX Script -
09-17-2003
, 10:55 AM
#2
| |||
| |||
|
|
I have an activeX script that reads public folders on an Exchange 2000 server. I can run the job successfully one step at a time, but when I try and run the DTS job or schedule it, the job fails because it has a logon failure to MAPI. I figure that MAPI can't find the profile I am specifying because DTS runs the script aa a service. How can I logon to an Exchange server while the script ffrom DTS? |
#3
| |||
| |||
|
|
Content-Class: urn:content-classes:message From: "David Day" <DavidDay22 (AT) Hotmail (DOT) com Sender: "David Day" <DavidDay22 (AT) Hotmail (DOT) com Subject: MAPI and ActiveX Script Date: Wed, 17 Sep 2003 08:55:52 -0700 Lines: 8 Message-ID: <0f5201c37d34$2c335980$a401280a (AT) phx (DOT) gbl MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Thread-Index: AcN9NCwwi7XLRf7URgyJMXsDxH6ELA== X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 Newsgroups: microsoft.public.sqlserver.dts Path: cpmsftngxa06.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:38776 NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164 X-Tomcat-NG: microsoft.public.sqlserver.dts I have an activeX script that reads public folders on an Exchange 2000 server. I can run the job successfully one step at a time, but when I try and run the DTS job or schedule it, the job fails because it has a logon failure to MAPI. I figure that MAPI can't find the profile I am specifying because DTS runs the script aa a service. How can I logon to an Exchange server while the script ffrom DTS? |
#4
| |||
| |||
|
|
Hi David, When you run the DTS package successfully, which Windows account did you use to log to Exchange Server? You may check with article 269074 to find which security context DTS package runs under when scheduled. Generally you may try the following steps if you want to schedule DTS package to run under a specific account: 1. Make a login who belongs to System Administrators role in SQL Server the owner of the DTS package and job. 2. Make SQL Server Agent service to run under the specific account. Restart SQL Server and SQL Server Agent service. Bill Cheng Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- | Content-Class: urn:content-classes:message | From: "David Day" <DavidDay22 (AT) Hotmail (DOT) com | Sender: "David Day" <DavidDay22 (AT) Hotmail (DOT) com | Subject: MAPI and ActiveX Script | Date: Wed, 17 Sep 2003 08:55:52 -0700 | Lines: 8 | Message-ID: <0f5201c37d34$2c335980$a401280a (AT) phx (DOT) gbl | MIME-Version: 1.0 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Thread-Index: AcN9NCwwi7XLRf7URgyJMXsDxH6ELA== | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 | Newsgroups: microsoft.public.sqlserver.dts | Path: cpmsftngxa06.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:38776 | NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164 | X-Tomcat-NG: microsoft.public.sqlserver.dts | | I have an activeX script that reads public folders on an | Exchange 2000 server. I can run the job successfully one | step at a time, but when I try and run the DTS job or | schedule it, the job fails because it has a logon failure | to MAPI. I figure that MAPI can't find the profile I am | specifying because DTS runs the script aa a service. How | can I logon to an Exchange server while the script ffrom | DTS? | |
#5
| |||
| |||
|
|
Reply-To: "David Day" <DavidDay22 (AT) Hotmail (DOT) com From: "David Day" <DavidDay22 (AT) Hotmail (DOT) com References: <0f5201c37d34$2c335980$a401280a (AT) phx (DOT) gbl Yn9fYlbfDHA.2596 (AT) cpmsftngxa06 (DOT) phx.gbl Subject: Re: MAPI and ActiveX Script Date: Thu, 18 Sep 2003 08:53:50 -0400 Lines: 61 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: <#AtStPefDHA.2576 (AT) TK2MSFTNGP11 (DOT) phx.gbl Newsgroups: microsoft.public.sqlserver.dts NNTP-Posting-Host: d14-69-79-252.try.wideopenwest.com 69.14.252.79 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:38816 X-Tomcat-NG: microsoft.public.sqlserver.dts We have set up an account with domain admin privledges that runs SQL Server and SQL Agent. This account is also the owner of the DTS job. I think the problem is finding an Exchange profile that matches the account that runs the service. How can I get a profile created that DTS can use? ""Bill Cheng [MSFT]"" <billchng (AT) online (DOT) microsoft.com> wrote in message news:Yn9fYlbfDHA.2596 (AT) cpmsftngxa06 (DOT) phx.gbl... Hi David, When you run the DTS package successfully, which Windows account did you use to log to Exchange Server? You may check with article 269074 to find which security context DTS package runs under when scheduled. Generally you may try the following steps if you want to schedule DTS package to run under a specific account: 1. Make a login who belongs to System Administrators role in SQL Server the owner of the DTS package and job. 2. Make SQL Server Agent service to run under the specific account. Restart SQL Server and SQL Server Agent service. Bill Cheng Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- | Content-Class: urn:content-classes:message | From: "David Day" <DavidDay22 (AT) Hotmail (DOT) com | Sender: "David Day" <DavidDay22 (AT) Hotmail (DOT) com | Subject: MAPI and ActiveX Script | Date: Wed, 17 Sep 2003 08:55:52 -0700 | Lines: 8 | Message-ID: <0f5201c37d34$2c335980$a401280a (AT) phx (DOT) gbl | MIME-Version: 1.0 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | Thread-Index: AcN9NCwwi7XLRf7URgyJMXsDxH6ELA== | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 | Newsgroups: microsoft.public.sqlserver.dts | Path: cpmsftngxa06.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:38776 | NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164 | X-Tomcat-NG: microsoft.public.sqlserver.dts | | I have an activeX script that reads public folders on an | Exchange 2000 server. I can run the job successfully one | step at a time, but when I try and run the DTS job or | schedule it, the job fails because it has a logon failure | to MAPI. I figure that MAPI can't find the profile I am | specifying because DTS runs the script aa a service. How | can I logon to an Exchange server while the script ffrom | DTS? | |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.