CDO Access Denied to Mailbox after move to 2007 Server

Scott Townsend · Joined: 05 Aug 2007 Posts: 33

We have an Application running on a SQL Server that opens up users mailboxes
and adds appointments to their calendars. It works great and has been for
years.

We are in the process of migration to Exchange 2007. We moves some
mailboxes over to the 2007 Server and now the Application cant access the
mailboxes that we moved to the new Server. The user that the Code is
running on has been given Full Control to all Mailboxes. It is listed as an
Administrator in the Exchange Admins Org Config.

The command I'm executing is:
Set objTopFolder = objInfoStore.RootFolder
The Error I'm getting is:

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft Data Transformation Services (DTS) Data Pump
(80020101): Error Code: 1285
Error Source= Collaboration Data Objects
Error Description: [Collaboration Data Objects -
[MAPI_E_FAILONEPROVIDER(8004011D)]] Error on Line 95)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Where do I go from here?

Archived from group: microsoft>public>exchange>applications

SvenC · Joined: 05 Aug 2007 Posts: 8

Hi Scott,

> We have an Application running on a SQL Server that opens up users
> mailboxes and adds appointments to their calendars. It works great and
> has been for years.
>
> We are in the process of migration to Exchange 2007. We moves some
> mailboxes over to the 2007 Server and now the Application cant access the
> mailboxes that we moved to the new Server. The user that the Code is
> running on has been given Full Control to all Mailboxes. It is listed as
> an Administrator in the Exchange Admins Org Config.

I assume that Ex2007 does not have a public folder store and that you use
CDO from the Exchange Server 2003 management tools?
As far as I know only the new standalone package of MAPI/CDO for Exchange
2007 can connect to a server without a public folder store. To make things
more complicate that standalone CDO package does not connect to Exchange
2003 because of this new feature. You have to install a hotfix for Exchange
2003 to that the new CDO package can connect.

So you might try to create a public folder store to use the "old" CDO to
connect to Ex2003 and Ex2007.

--
SvenC

Scott Townsend · Joined: 05 Aug 2007 Posts: 33

Thank you for the Reply...

So on my Exchange install already has a Public Folder Store.

Under Server Configuration/Mailbox/Second Storage Group there is a 'Public
Folder Database'
Last Backup: Wednesday, July 25, 2007 9:12:18 PM
Status: Mounted
Last Modified : Thursday, April 19, 2007 5:11:20 PM
Which I think was around when it was installed.

I think it has something to do with Permissions.

From within the Outlook Client I used to be able to open Everyone's InBox
(File Open Other Users Folder)

Now I cant open 99% of the InBoxes that are on the 2007 server. I can
however open the Calendars of those people, just not the InBox.

There is one user on the 2007 Server I can open His InBox, though looking at
the Folder Permissions, there does not seem to be anything specific for me
in there.

In 2003 there was a way to look at the 'Mailbox Rights' it does not seem to
appear in the 2007 Management console. In the 2003 ADUG I can see the
mailbox rights and it has listed the users and Groups that I want to have
access to the Mailboxes. The User on the SQL Server that is trying to access
the Mailbox is a Member of the Exchange Org Admin group.

Any Suggestions?

Thanks,
Scott<-

"SvenC" wrote in message @microsoft.com...
> Hi Scott,
>
>> We have an Application running on a SQL Server that opens up users
>> mailboxes and adds appointments to their calendars. It works great and
>> has been for years.
>>
>> We are in the process of migration to Exchange 2007. We moves some
>> mailboxes over to the 2007 Server and now the Application cant access the
>> mailboxes that we moved to the new Server. The user that the Code is
>> running on has been given Full Control to all Mailboxes. It is listed as
>> an Administrator in the Exchange Admins Org Config.
>
> I assume that Ex2007 does not have a public folder store and that you use
> CDO from the Exchange Server 2003 management tools?
> As far as I know only the new standalone package of MAPI/CDO for Exchange
> 2007 can connect to a server without a public folder store. To make things
> more complicate that standalone CDO package does not connect to Exchange
> 2003 because of this new feature. You have to install a hotfix for
> Exchange 2003 to that the new CDO package can connect.
>
> So you might try to create a public folder store to use the "old" CDO to
> connect to Ex2003 and Ex2007.
>
> --
> SvenC

SvenC · Joined: 05 Aug 2007 Posts: 8

Hi,

"Scott Townsend" wrote in message @microsoft.com...
> Thank you for the Reply...
>
> I think it has something to do with Permissions.

Yes.

> From within the Outlook Client I used to be able to open Everyone's InBox
> (File Open Other Users Folder)
>
> Now I cant open 99% of the InBoxes that are on the 2007 server. I can
> however open the Calendars of those people, just not the InBox.

The user needs extended rights send-as and receive-as. Check this article:
http://technet.microsoft.com/en-us/library/aa996343.aspx

Also google for AdminSDHolder. You will find articles explaining how admin
accounts are effected of having extended rights removed automatically.

--
SvenC

Dgoldman [MSFT] · Joined: 05 Aug 2007 Posts: 45

Make sure when you use AdminSDHolder you dont have an account that is part
of the an administartors group otherwise you will get restricted again. The
permissions model changes slightly. If you need MAPI access to mailboxes you
need to make sure that the account you are using as admin rights on the
information store so you can access those tables, otherwise you wont be
connecting Smile

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Dgoldman
http://blogs.msdn.com/dgoldman
Download OABInteg
(http://gotdotnet.com/Community/UserSamples/Download.aspx?SampleGuid=A2338E73-F521-4071-9B1D-AAF49C346ACD)
"SvenC" wrote in message @microsoft.com...
> Hi,
>
> "Scott Townsend" wrote in message
> @microsoft.com...
>> Thank you for the Reply...
>>
>> I think it has something to do with Permissions.
>
> Yes.
>
>> From within the Outlook Client I used to be able to open Everyone's InBox
>> (File Open Other Users Folder)
>>
>> Now I cant open 99% of the InBoxes that are on the 2007 server. I can
>> however open the Calendars of those people, just not the InBox.
>
> The user needs extended rights send-as and receive-as. Check this article:
> http://technet.microsoft.com/en-us/library/aa996343.aspx
>
> Also google for AdminSDHolder. You will find articles explaining how admin
> accounts are effected of having extended rights removed automatically.
>
> --
> SvenC

Impersonsate User and Access Mailbox I am writing an application in VB6 that will prompt a user to enter their username and password. It will then call the LogonUser API to log the user in, then call After that, it will log them in to Exchange to send an email using

Access Exchange Client Mailbox Hi Guys, I need to write a script to allow me to connect to the mailbox of a specific exchange client. Once connected I need to be able to loop through each email in the inbox and do the following: 1. Access the mail recipients 2. Save the details of the

Access other Exchange Server Dear, We are one Company , using Exchange server 5.5 for Mail Server. We have create one Orangziation on Exchange , and on the Orangization have different Site. Each Site on different country . ( like ExchHK01 , ExchUS01 ) On the client Site . it is usin

Outlook Web Access and Active Server Hello I have been working on getting a network back up which has a SBS 4.5 NT4.0 Server.I have Exchange 5.5 from the SBS4.5 build on it and here is my situation.I am trying to get Outlook Web Access working and when I go to install the OWA USA support it

Permission denied trying to save Appointment (CDOEX) Hi. I'm facing this annoying "Permission denied" error when I try to execute the code below inside a ASP.NET page. When I run the page, it pops me a system form asking for credentials, but it fails no matter what user/pass I type. The same code is execut