Problem installing SQL Server Reporting Services

I've been trying to install the MSDN Developers edition of SQL Server
Reporting Services for serveral hours. My environment is as follows:
XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
(Enterprise).
I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
The problem is that when I try to install the RS I only get the option
to install the Client Components (not very helpful for developing
reports locally)
While this looks like a great tool I'm inclined to go back to using
Crystal Reports unless I can get this resolved without <<<wasting>>
much more time!
Anyone have any thoughts?
GlennYou only want the client app on your computer. You can only install the RS
Enterprise on a server. The client app works perfectly fine for developing
reports and deploying them locally to view them. You will have to setup a
separate report server to deploy reports into production, if I understand
your needs.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> I've been trying to install the MSDN Developers edition of SQL Server
> Reporting Services for serveral hours. My environment is as follows:
> XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> (Enterprise).
> I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> The problem is that when I try to install the RS I only get the option
> to install the Client Components (not very helpful for developing
> reports locally)
> While this looks like a great tool I'm inclined to go back to using
> Crystal Reports unless I can get this resolved without <<<wasting>>
> much more time!
> Anyone have any thoughts?
> Glenn|||You are supposed to be able to install this version of XP Pro (see this
link: http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp)
Do you have XP Pro with SP1?
Another point to consider, XP Pro does not have IIS by default running. Have
you installed IIS? Add/Remove Programs Windows Components.
IIS needs to be installed plus ASP.Net needs to be installed and running. My
guess is something with the web server is not setup correctly.
Bruce L-C
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl...
> You only want the client app on your computer. You can only install the
RS
> Enterprise on a server. The client app works perfectly fine for
developing
> reports and deploying them locally to view them. You will have to setup a
> separate report server to deploy reports into production, if I understand
> your needs.
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn
>|||I am having the same problem.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> I've been trying to install the MSDN Developers edition of SQL Server
> Reporting Services for serveral hours. My environment is as follows:
> XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> (Enterprise).
> I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> The problem is that when I try to install the RS I only get the option
> to install the Client Components (not very helpful for developing
> reports locally)
> While this looks like a great tool I'm inclined to go back to using
> Crystal Reports unless I can get this resolved without <<<wasting>>
> much more time!
> Anyone have any thoughts?
> Glenn|||I'm having a similar problem...
Enterprise and Developer set up on one server machine, Developer on 2
other desktops. If you access Report Manager from the Server machine,
everything looks fine. But Report Manager accessed from the
non-server machines shows the top banner only... No tabs, no folders,
nothing below the line, so a developer can't upload without switching
over to the server, and even then there are often errors.
Is there some configuration subtlety we missed?
Otherwise this thing is giving me problems with OutOfMemory errors on
local debugs that I know aren't too big.
Ideas?
Jody
"Lance" <ldacy@.fellowshiptech.com> wrote in message news:<eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl>...
> You only want the client app on your computer. You can only install the RS
> Enterprise on a server. The client app works perfectly fine for developing
> reports and deploying them locally to view them. You will have to setup a
> separate report server to deploy reports into production, if I understand
> your needs.
>
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn|||Your problem seems different. He was having a problem installing. Your
problem seems to be accessing it. It looks to me like you haven't setup your
roles for the developers on other machines.
Bruce L-C
"JodyT" <datagal@.msn.com> wrote in message
news:f9d864c3.0408111251.61c4d16f@.posting.google.com...
> I'm having a similar problem...
> Enterprise and Developer set up on one server machine, Developer on 2
> other desktops. If you access Report Manager from the Server machine,
> everything looks fine. But Report Manager accessed from the
> non-server machines shows the top banner only... No tabs, no folders,
> nothing below the line, so a developer can't upload without switching
> over to the server, and even then there are often errors.
> Is there some configuration subtlety we missed?
> Otherwise this thing is giving me problems with OutOfMemory errors on
> local debugs that I know aren't too big.
> Ideas?
> Jody
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
news:<eOVowwufEHA.2468@.TK2MSFTNGP12.phx.gbl>...
> > You only want the client app on your computer. You can only install the
RS
> > Enterprise on a server. The client app works perfectly fine for
developing
> > reports and deploying them locally to view them. You will have to setup
a
> > separate report server to deploy reports into production, if I
understand
> > your needs.
> >
> >
> > "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> > news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > > I've been trying to install the MSDN Developers edition of SQL Server
> > > Reporting Services for serveral hours. My environment is as follows:
> > >
> > > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > > (Enterprise).
> > >
> > > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > > The problem is that when I try to install the RS I only get the option
> > > to install the Client Components (not very helpful for developing
> > > reports locally)
> > >
> > > While this looks like a great tool I'm inclined to go back to using
> > > Crystal Reports unless I can get this resolved without <<<wasting>>
> > > much more time!
> > >
> > > Anyone have any thoughts?
> > >
> > > Glenn|||Hello all. Thanks for the feedback... sorry for not finishing up the
thread.
My solution was to re-install WIN XP Pro SP1. Once SP1 was
re-installed RS installed with no further problems.
Hope this helps!
Glenn
"Kurt" <kurt_junk@.sdlf.com> wrote in message news:<OUz#lSzfEHA.1092@.TK2MSFTNGP11.phx.gbl>...
> I am having the same problem.
> "Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
> news:bc4291aa.0408100706.3f11c1c1@.posting.google.com...
> > I've been trying to install the MSDN Developers edition of SQL Server
> > Reporting Services for serveral hours. My environment is as follows:
> >
> > XP Pro, SQL Server 2000, SQL Server SP3a, .Net Framework, VS.Net
> > (Enterprise).
> >
> > I have uninstalled/reinstalled SQL Server (and SP3a) - several times.
> > The problem is that when I try to install the RS I only get the option
> > to install the Client Components (not very helpful for developing
> > reports locally)
> >
> > While this looks like a great tool I'm inclined to go back to using
> > Crystal Reports unless I can get this resolved without <<<wasting>>
> > much more time!
> >
> > Anyone have any thoughts?
> >
> > Glenn

Problem Installing SQL Server 2005 Enterprise Edition On Windows Server 2003 Box

While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows...

Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007
Process ID : 5440
E:\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/8/20 11:11:35
Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35
Loaded DLL:E:\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/8/20 11:11:35
Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true
Running: ValidateMinOSAction at: 2007/8/20 11:11:35
Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true
Running: PerformSCCAction at: 2007/8/20 11:11:35
Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true
Running: ActivateLoggingAction at: 2007/8/20 11:11:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Any ideas?

Thanks in advance.

Ensure that you have all the prerequisites installed for installing sql 2005 in windows 2003 server ! you need to have windows 2003 server with SP1,.NET framework 2.0 etc.......pls refer the link for the prerequsites !

http://technet.microsoft.com/hi-in/library/ms143506.aspx

Thanxx
Deepak