Exchange Reporting Pack

Has anyone been able to successfully install the Exchange reporting pack
without also having Visual Studio .Net installed? I've tried but receive the
following error: "Object Reference not set to an instance of object" and the
install fails.I have the same problem and would really like to find out if it is possible
to install without VS.Net. I've tried installing not only the Exchange
reporting pack but also the Financial which is what I'm really interested in
now.
"Tony G" wrote:
> Has anyone been able to successfully install the Exchange reporting pack
> without also having Visual Studio .Net installed? I've tried but receive the
> following error: "Object Reference not set to an instance of object" and the
> install fails.

Exchange Report Pack

We have a Two Server Deployment: CRM, Reporting Services and IIS on
one Server and our SQL Server 2000 Backend on another Server - which
happends to be a Named Instance.
Because we have a Named Instance as our SQL Server backend......In
order to get Reporting Services to work correctly, we had temporarily
disable the EDW (Environmental Diagnostics Wizard) in CRM using a
registry key change in order for the the 'canned' CRM Reports to work
against our SQL Named Instance (see this link for more info on this
http://blogs.msdn.com/ukcrm/archive/2006/08/17/704229.aspx)
Well... now I am attempting to get the reports in the Exchange Report
Pack for Reporting Servives to work. What I did so far was: Turned off
EDW in the registry on the CRM Server, installed the Exchange Report
Pack, attached the Sample Databases to my CRM named Instance, created
an ODBC connection to the sample Exchange database, and uiploaded the
Reports from the Report Pack and configured them to use the ODBC
connection to the Sample database. Now when I try and run any of the
Exchange Reports, I get this error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'SSW Exchange Reporter'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
Has anyone gotten this to work or can anyone help'?Are you sure that this isn't a simple double-hop problem?
We should ask our Active Directory Wizards what they know about
double-hop and then run this by them if they look at us with a blank
stare
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
(4) The user's domain account must NOT select "Account is
sensitive and cannot be delegated" in its Active Directory properties
of domain D. Please refer to [1] on how to configure this on Active
Directory machine.
(5) The service account under which the SQL instance is running must
be "trusted for delegation", configured in Active Directory. If the
service is running as "NT AUTHORITY\SYSTEM" or "NT
AUTHORITY\NETWORK SERVICE", the computer must be "trusted for
delegation". Please refer to [1] on how to configure this on Active
Directory Machine. You need to have domain admin privilege to do/verify
so.
Also; I think that we may need to run 'setspn' with the service account
for the sql box in order to allow it to participate in a double-hop
authentication..
Janice wrote:
> We have a Two Server Deployment: CRM, Reporting Services and IIS on
> one Server and our SQL Server 2000 Backend on another Server - which
> happends to be a Named Instance.
> Because we have a Named Instance as our SQL Server backend......In
> order to get Reporting Services to work correctly, we had temporarily
> disable the EDW (Environmental Diagnostics Wizard) in CRM using a
> registry key change in order for the the 'canned' CRM Reports to work
> against our SQL Named Instance (see this link for more info on this
> http://blogs.msdn.com/ukcrm/archive/2006/08/17/704229.aspx)
> Well... now I am attempting to get the reports in the Exchange Report
> Pack for Reporting Servives to work. What I did so far was: Turned off
> EDW in the registry on the CRM Server, installed the Exchange Report
> Pack, attached the Sample Databases to my CRM named Instance, created
> an ODBC connection to the sample Exchange database, and uiploaded the
> Reports from the Report Pack and configured them to use the ODBC
> connection to the Sample database. Now when I try and run any of the
> Exchange Reports, I get this error:
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'SSW Exchange Reporter'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
> Has anyone gotten this to work or can anyone help'?

Exchange Pack for Reporting Services

Has anyone successfully installed the Exchange Pack for Reporting Services?
I've attempted a couple of times and continue to get "Object Reference not
set to an instance of object", which causes the install to rollback.
Does anyone know how to correct this problem?
Thanks.Several others are having the same problem. I haven't found a fix yet.
It seems the version available on SSW's site is different and
time-limited.|||Any updates on this that you know of? I am seeing the same issue.
"bret@.fishbrains.com" wrote:
> Several others are having the same problem. I haven't found a fix yet.
> It seems the version available on SSW's site is different and
> time-limited.
>

Exchange Pack for Reporting Services

Is there any way to get data from a real install of Exchange into the
database for the Exchange Pack for Reporting Services, or is it just to look
at pretty reports that mean nothing to us?
Am I missing something here?
MichaelThe goal of the report packs is to show reports one might write using
reporting services. It is not necessarily to ship solutions that monitor
the specified application. This particular report pack contains a reference
to a tool from SSW for a product they support for extracting data about
exchange. This could be a start. Alternatively, you can use an ETL tool
such as DTS to do so, though I'm sure tools such as SSW Exchange Extraction
Service provide additional analytics.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
<michael@.civis.com> wrote in message
news:OUTh16MBFHA.1392@.tk2msftngp13.phx.gbl...
> Is there any way to get data from a real install of Exchange into the
> database for the Exchange Pack for Reporting Services, or is it just to
> look
> at pretty reports that mean nothing to us?
> Am I missing something here?
> Michael
>

Exchange & Reporting server

i recently read an article on how you could do reports on your exchange
environment with the SQL 2000 report pack for Exchange.
http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
I have installed this on my SQL box and am unable to access the 13
predefined reports. Could someone assist me and let me know if there are
any special things that need to be done. ThanksNothing specific. The Report Pack should have installed a sample database.
If for some reason this didn't work, you can just attach the database
manuall.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris" <Chris.bates@.maritz.com> wrote in message
news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
>i recently read an article on how you could do reports on your exchange
> environment with the SQL 2000 report pack for Exchange.
> http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> I have installed this on my SQL box and am unable to access the 13
> predefined reports. Could someone assist me and let me know if there are
> any special things that need to be done. Thanks
>|||How do you connect manually?
Do you have to have sql and exchange on the same box?
I uninstalled and then reinstalled and now i am getting this error
"Object reference not set to instance of an object"
Any clue to what is the problem?
thanks.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<umttjjUzEHA.2568@.TK2MSFTNGP10.phx.gbl>...
> Nothing specific. The Report Pack should have installed a sample database.
> If for some reason this didn't work, you can just attach the database
> manuall.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Chris" <Chris.bates@.maritz.com> wrote in message
> news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> >i recently read an article on how you could do reports on your exchange
> > environment with the SQL 2000 report pack for Exchange.
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> >
> > I have installed this on my SQL box and am unable to access the 13
> > predefined reports. Could someone assist me and let me know if there are
> > any special things that need to be done. Thanks
> >
> >|||batescr@.gmail.com (Chris Bates) wrote in message news:<52d5e6a3.0411212133.376e2eaa@.posting.google.com>...
> How do you connect manually?
> Do you have to have sql and exchange on the same box?
> I uninstalled and then reinstalled and now i am getting this error
> "Object reference not set to instance of an object"
> Any clue to what is the problem?
> thanks.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<umttjjUzEHA.2568@.TK2MSFTNGP10.phx.gbl>...
> > Nothing specific. The Report Pack should have installed a sample database.
> > If for some reason this didn't work, you can just attach the database
> > manuall.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Chris" <Chris.bates@.maritz.com> wrote in message
> > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> > >i recently read an article on how you could do reports on your exchange
> > > environment with the SQL 2000 report pack for Exchange.
> > >
> > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> > >
> > > I have installed this on my SQL box and am unable to access the 13
> > > predefined reports. Could someone assist me and let me know if there are
> > > any special things that need to be done. Thanks
> > >
> > >
I get the same error, both while installing on Reporting server and on
Exchange server. Using Ex2003 w/ SP1, and reporting server SP1.
Thanks.|||Some people are hitting some but in setup but we have not been able to repro
it here. You might want to take a look at the log file. You don't need
Exchange on the box at all.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"sonicbum" <bret@.fishbrains.com> wrote in message
news:e370ce09.0412011409.743a50df@.posting.google.com...
> batescr@.gmail.com (Chris Bates) wrote in message
> news:<52d5e6a3.0411212133.376e2eaa@.posting.google.com>...
>> How do you connect manually?
>> Do you have to have sql and exchange on the same box?
>> I uninstalled and then reinstalled and now i am getting this error
>> "Object reference not set to instance of an object"
>> Any clue to what is the problem?
>> thanks.
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:<umttjjUzEHA.2568@.TK2MSFTNGP10.phx.gbl>...
>> > Nothing specific. The Report Pack should have installed a sample
>> > database.
>> > If for some reason this didn't work, you can just attach the database
>> > manuall.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Chris" <Chris.bates@.maritz.com> wrote in message
>> > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
>> > >i recently read an article on how you could do reports on your
>> > >exchange
>> > > environment with the SQL 2000 report pack for Exchange.
>> > >
>> > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
>> > >
>> > > I have installed this on my SQL box and am unable to access the 13
>> > > predefined reports. Could someone assist me and let me know if there
>> > > are
>> > > any special things that need to be done. Thanks
>> > >
>> > >
> I get the same error, both while installing on Reporting server and on
> Exchange server. Using Ex2003 w/ SP1, and reporting server SP1.
> Thanks.|||I am also seeing this error when trying to install. Any updates on the cause?
"Brian Welcker [MS]" wrote:
> Some people are hitting some but in setup but we have not been able to repro
> it here. You might want to take a look at the log file. You don't need
> Exchange on the box at all.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "sonicbum" <bret@.fishbrains.com> wrote in message
> news:e370ce09.0412011409.743a50df@.posting.google.com...
> > batescr@.gmail.com (Chris Bates) wrote in message
> > news:<52d5e6a3.0411212133.376e2eaa@.posting.google.com>...
> >> How do you connect manually?
> >>
> >> Do you have to have sql and exchange on the same box?
> >>
> >> I uninstalled and then reinstalled and now i am getting this error
> >>
> >> "Object reference not set to instance of an object"
> >>
> >> Any clue to what is the problem?
> >>
> >> thanks.
> >> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> >> news:<umttjjUzEHA.2568@.TK2MSFTNGP10.phx.gbl>...
> >> > Nothing specific. The Report Pack should have installed a sample
> >> > database.
> >> > If for some reason this didn't work, you can just attach the database
> >> > manuall.
> >> >
> >> > --
> >> > Brian Welcker
> >> > Group Program Manager
> >> > Microsoft SQL Server Reporting Services
> >> >
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> > "Chris" <Chris.bates@.maritz.com> wrote in message
> >> > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> >> > >i recently read an article on how you could do reports on your
> >> > >exchange
> >> > > environment with the SQL 2000 report pack for Exchange.
> >> > >
> >> > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> >> > >
> >> > > I have installed this on my SQL box and am unable to access the 13
> >> > > predefined reports. Could someone assist me and let me know if there
> >> > > are
> >> > > any special things that need to be done. Thanks
> >> > >
> >> > >
> >
> > I get the same error, both while installing on Reporting server and on
> > Exchange server. Using Ex2003 w/ SP1, and reporting server SP1.
> > Thanks.
>
>|||It appears that you reproduce this issue by installing on a machine that does
not have Visual Studio .Net installed. And I don't want to install VS on my
report server because it is also my intranet server.
"Brian Welcker [MSFT]" wrote:
> Nothing specific. The Report Pack should have installed a sample database.
> If for some reason this didn't work, you can just attach the database
> manuall.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Chris" <Chris.bates@.maritz.com> wrote in message
> news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> >i recently read an article on how you could do reports on your exchange
> > environment with the SQL 2000 report pack for Exchange.
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> >
> > I have installed this on my SQL box and am unable to access the 13
> > predefined reports. Could someone assist me and let me know if there are
> > any special things that need to be done. Thanks
> >
> >
>
>|||Yes, after installing VS I was able to install the Report Pack. Still do not
know if you can really do any "real reporting" with this product though. I
think you can just use the sample database.
"Tony G" wrote:
> It appears that you reproduce this issue by installing on a machine that does
> not have Visual Studio .Net installed. And I don't want to install VS on my
> report server because it is also my intranet server.
> "Brian Welcker [MSFT]" wrote:
> > Nothing specific. The Report Pack should have installed a sample database.
> > If for some reason this didn't work, you can just attach the database
> > manuall.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Chris" <Chris.bates@.maritz.com> wrote in message
> > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> > >i recently read an article on how you could do reports on your exchange
> > > environment with the SQL 2000 report pack for Exchange.
> > >
> > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> > >
> > > I have installed this on my SQL box and am unable to access the 13
> > > predefined reports. Could someone assist me and let me know if there are
> > > any special things that need to be done. Thanks
> > >
> > >
> >
> >
> >|||I was trying to install the report pack without installing VS. That was my
real question: How do you do that'
"winkle60" wrote:
> Yes, after installing VS I was able to install the Report Pack. Still do not
> know if you can really do any "real reporting" with this product though. I
> think you can just use the sample database.
> "Tony G" wrote:
> > It appears that you reproduce this issue by installing on a machine that does
> > not have Visual Studio .Net installed. And I don't want to install VS on my
> > report server because it is also my intranet server.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> > > Nothing specific. The Report Pack should have installed a sample database.
> > > If for some reason this didn't work, you can just attach the database
> > > manuall.
> > >
> > > --
> > > Brian Welcker
> > > Group Program Manager
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > > "Chris" <Chris.bates@.maritz.com> wrote in message
> > > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> > > >i recently read an article on how you could do reports on your exchange
> > > > environment with the SQL 2000 report pack for Exchange.
> > > >
> > > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> > > >
> > > > I have installed this on my SQL box and am unable to access the 13
> > > > predefined reports. Could someone assist me and let me know if there are
> > > > any special things that need to be done. Thanks
> > > >
> > > >
> > >
> > >
> > >|||I do not know if you can. I HAD to install VS to get the Report Pack to
install.
"Tony G" wrote:
> I was trying to install the report pack without installing VS. That was my
> real question: How do you do that'
> "winkle60" wrote:
> > Yes, after installing VS I was able to install the Report Pack. Still do not
> > know if you can really do any "real reporting" with this product though. I
> > think you can just use the sample database.
> >
> > "Tony G" wrote:
> >
> > > It appears that you reproduce this issue by installing on a machine that does
> > > not have Visual Studio .Net installed. And I don't want to install VS on my
> > > report server because it is also my intranet server.
> > >
> > > "Brian Welcker [MSFT]" wrote:
> > >
> > > > Nothing specific. The Report Pack should have installed a sample database.
> > > > If for some reason this didn't work, you can just attach the database
> > > > manuall.
> > > >
> > > > --
> > > > Brian Welcker
> > > > Group Program Manager
> > > > Microsoft SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > >
> > > > "Chris" <Chris.bates@.maritz.com> wrote in message
> > > > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> > > > >i recently read an article on how you could do reports on your exchange
> > > > > environment with the SQL 2000 report pack for Exchange.
> > > > >
> > > > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
> > > > >
> > > > > I have installed this on my SQL box and am unable to access the 13
> > > > > predefined reports. Could someone assist me and let me know if there are
> > > > > any special things that need to be done. Thanks
> > > > >
> > > > >
> > > >
> > > >
> > > >|||Unfortunately, the Exchange extractor is not built-in. We rely on a 3rd
party product for that. The IIS log report pack does the extract, though.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:371C5E22-F46A-4AFA-9EE3-E9E6F48869F4@.microsoft.com...
> Yes, after installing VS I was able to install the Report Pack. Still do
> not
> know if you can really do any "real reporting" with this product though. I
> think you can just use the sample database.
> "Tony G" wrote:
>> It appears that you reproduce this issue by installing on a machine that
>> does
>> not have Visual Studio .Net installed. And I don't want to install VS on
>> my
>> report server because it is also my intranet server.
>> "Brian Welcker [MSFT]" wrote:
>> > Nothing specific. The Report Pack should have installed a sample
>> > database.
>> > If for some reason this didn't work, you can just attach the database
>> > manuall.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "Chris" <Chris.bates@.maritz.com> wrote in message
>> > news:uwj7HqOzEHA.2788@.TK2MSFTNGP15.phx.gbl...
>> > >i recently read an article on how you could do reports on your
>> > >exchange
>> > > environment with the SQL 2000 report pack for Exchange.
>> > >
>> > > http://www.microsoft.com/downloads/details.aspx?FamilyId=108C2B01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
>> > >
>> > > I have installed this on my SQL box and am unable to access the 13
>> > > predefined reports. Could someone assist me and let me know if there
>> > > are
>> > > any special things that need to be done. Thanks
>> > >
>> > >
>> >
>> >
>> >