A couple of questions related to Reported Services tuning that I hope
someone might be able to give me a clue about....
1) In the Reporting Services Books Online, I have found a lot of
information on performance monitoring, but very little on performance
tuning. Is any additional information available, perhaps a whitepaper? Or
perhaps I am just missing something that is in the BOL?
2) An immediate question we have that perhaps someone can answer is, is
there any way to give On Demand reports a higher execution priority than
Scheduled reports? A particular concern is that a shared schedule, say "End
of month" processing, might become very popular and have a large number of
reports subscribed to it. These reports might then overload the server,
adversely effecting the execution time of On Demand reports.
Any enlightenment would be greatly appreciated.
Thanks,
BobOne thing to keep in mind. A snapshot of the report/data can be saved. So,
you can schedule to run at night every night and then save x days of
reports. Or you can run weekly and save 10 weeks of data (you specify how
many snapshots to save). This report or a link to it can be emailed out. To
me that is what makes the most sense, run the scheduled reports in off time
and then you will have no concern about the On Demand reports.
Bruce L-C
"Bob Hug" <rhug@.brassring.com> wrote in message
news:O6LK84QZEHA.3944@.tk2msftngp13.phx.gbl...
> A couple of questions related to Reported Services tuning that I hope
> someone might be able to give me a clue about....
> 1) In the Reporting Services Books Online, I have found a lot of
> information on performance monitoring, but very little on performance
> tuning. Is any additional information available, perhaps a whitepaper? Or
> perhaps I am just missing something that is in the BOL?
> 2) An immediate question we have that perhaps someone can answer is,
is
> there any way to give On Demand reports a higher execution priority than
> Scheduled reports? A particular concern is that a shared schedule, say
"End
> of month" processing, might become very popular and have a large number of
> reports subscribed to it. These reports might then overload the server,
> adversely effecting the execution time of On Demand reports.
> Any enlightenment would be greatly appreciated.
> Thanks,
> Bob
>sql
Showing posts with label reported. Show all posts
Showing posts with label reported. Show all posts
Friday, March 30, 2012
Monday, March 12, 2012
Reporting services initilization problem
Hello,
I installed RS on a Windows 2003 box with SQL Server 2000 sp3. Unfortunately
setup reported that it could not initialize RS and it has to be initialized
manually
I have tried:
rsconfig & rsactivate with tons of different combinations of users ranging
from local system account to domain admin No luck, neither windows nor sql
authentications work, I tried some solutions suggested here and there like
re registering .net 1.1, installing a hotfix, adding permission to some
registry keys... etc. no luck.
The server is not a DC,
It's not going to be a part of a RS webfarm
A clean RS database is being used
There are no other web sites on the server
I tried re installing many many times, I even reinstalled SQL server and
applied sp3, still no luck...
It reports of a database connection failure, but I tried to config/activate
it as sa or windows admin it still fails...
I am out of options at this point. Anyone has a suggestion?
Thanks
PS: Below are the error messages from the log and rsactivate
w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159551 --> System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159551 --> System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
--RSACTIVATE--
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>rsac
tivate -c rsreportserver.config
Failure starting the web service:
Unable to connect to the database (-2147159551) 0x8007007fThe only thing I can think to try is reinstalling MDAC. You can find the
download here.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||Well, I forgot to mention. I have already tried that :(
I am thinking of reinstalling 2003 or even downgrading to 2000
Any other suggestions ?
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||I think you said this but I will ask to make sure. When you are in the
install wizard step that allows you to specify the SQL Server Instance, are
you choosing a 'SQL Credentials Type:' of 'SQL Login Account' and then
providing a SQL username/password that you have previously accessed the DB
(using QA for example)?
If so, take a look on the install wizard step that illustrates which account
the Report Server Web Service is run. This is normally ASPNET (I think
becuase none of the sites I use use the default) but if it is not, I have
found I have to add this user to the Administrators account of local machine
in order for it to run correctly.
"Skeptical" wrote:
> Well, I forgot to mention. I have already tried that :(
> I am thinking of reinstalling 2003 or even downgrading to 2000
> Any other suggestions ?
> "Skeptical" <skep@.yahoo.com> wrote in message
> news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> > Unfortunately setup reported that it could not initialize RS and it has to
> > be initialized manually
> >
> > I have tried:
> >
> > rsconfig & rsactivate with tons of different combinations of users
> > ranging from local system account to domain admin No luck, neither
> > windows nor sql authentications work, I tried some solutions suggested
> > here and there like re registering .net 1.1, installing a hotfix, adding
> > permission to some registry keys... etc. no luck.
> >
> > The server is not a DC,
> > It's not going to be a part of a RS webfarm
> > A clean RS database is being used
> > There are no other web sites on the server
> >
> > I tried re installing many many times, I even reinstalled SQL server and
> > applied sp3, still no luck...
> >
> > It reports of a database connection failure, but I tried to
> > config/activate it as sa or windows admin it still fails...
> >
> > I am out of options at this point. Anyone has a suggestion?
> >
> > Thanks
> >
> > PS: Below are the error messages from the log and rsactivate
> >
> >
> > w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> > System.Web.Services.Protocols.SoapException: The report server
> > installation is not initialized. Check the documentation for more
> > information. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> > The report server installation is not initialized. Check the documentation
> > for more information. --> System.Runtime.InteropServices.COMException
> > (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32 clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > at
> > Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > storedProcedureName)
> > at
> > Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> > key)
> > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> > name)
> > at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> > name)
> > at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > source)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path, Boolean validate, Boolean convert, Boolean translate)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> > pathTranslator, String userSuppliedPath, String parameterName)
> > at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> > item, StringCollection& Operations)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> > Item, String[]& Permissions)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> > Item, String[]& Permissions)
> > w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> > --Details--
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: The report server
> > installation is not initialized. Check the documentation for more
> > information. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> > The report server installation is not initialized. Check the documentation
> > for more information. --> System.Runtime.InteropServices.COMException
> > (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> > Int32 extendedError)
> >
> > --RSACTIVATE--
> > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer>rsac
> > tivate -c rsreportserver.config
> > Failure starting the web service:
> > Unable to connect to the database (-2147159551) 0x8007007f
> >
> >
>
>|||I tried that too. I am thinking that the problem might be with .net 1.1
Unfortunately it's not possible to uninstall and reinstall that part.
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||Formatted, new 2003...
It works... Thanks...
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>
I installed RS on a Windows 2003 box with SQL Server 2000 sp3. Unfortunately
setup reported that it could not initialize RS and it has to be initialized
manually
I have tried:
rsconfig & rsactivate with tons of different combinations of users ranging
from local system account to domain admin No luck, neither windows nor sql
authentications work, I tried some solutions suggested here and there like
re registering .net 1.1, installing a hotfix, adding permission to some
registry keys... etc. no luck.
The server is not a DC,
It's not going to be a part of a RS webfarm
A clean RS database is being used
There are no other web sites on the server
I tried re installing many many times, I even reinstalled SQL server and
applied sp3, still no luck...
It reports of a database connection failure, but I tried to config/activate
it as sa or windows admin it still fails...
I am out of options at this point. Anyone has a suggestion?
Thanks
PS: Below are the error messages from the log and rsactivate
w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159551 --> System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
item, StringCollection& Operations)
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
Item, String[]& Permissions)
w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: The report server installation
is not initialized. Check the documentation for more information. -->
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
The report server installation is not initialized. Check the documentation
for more information. --> System.Runtime.InteropServices.COMException
(0x80004005): -2147159551 --> System.Exception: 0x8007007f
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
--RSACTIVATE--
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>rsac
tivate -c rsreportserver.config
Failure starting the web service:
Unable to connect to the database (-2147159551) 0x8007007fThe only thing I can think to try is reinstalling MDAC. You can find the
download here.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||Well, I forgot to mention. I have already tried that :(
I am thinking of reinstalling 2003 or even downgrading to 2000
Any other suggestions ?
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||I think you said this but I will ask to make sure. When you are in the
install wizard step that allows you to specify the SQL Server Instance, are
you choosing a 'SQL Credentials Type:' of 'SQL Login Account' and then
providing a SQL username/password that you have previously accessed the DB
(using QA for example)?
If so, take a look on the install wizard step that illustrates which account
the Report Server Web Service is run. This is normally ASPNET (I think
becuase none of the sites I use use the default) but if it is not, I have
found I have to add this user to the Administrators account of local machine
in order for it to run correctly.
"Skeptical" wrote:
> Well, I forgot to mention. I have already tried that :(
> I am thinking of reinstalling 2003 or even downgrading to 2000
> Any other suggestions ?
> "Skeptical" <skep@.yahoo.com> wrote in message
> news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> > Unfortunately setup reported that it could not initialize RS and it has to
> > be initialized manually
> >
> > I have tried:
> >
> > rsconfig & rsactivate with tons of different combinations of users
> > ranging from local system account to domain admin No luck, neither
> > windows nor sql authentications work, I tried some solutions suggested
> > here and there like re registering .net 1.1, installing a hotfix, adding
> > permission to some registry keys... etc. no luck.
> >
> > The server is not a DC,
> > It's not going to be a part of a RS webfarm
> > A clean RS database is being used
> > There are no other web sites on the server
> >
> > I tried re installing many many times, I even reinstalled SQL server and
> > applied sp3, still no luck...
> >
> > It reports of a database connection failure, but I tried to
> > config/activate it as sa or windows admin it still fails...
> >
> > I am out of options at this point. Anyone has a suggestion?
> >
> > Thanks
> >
> > PS: Below are the error messages from the log and rsactivate
> >
> >
> > w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> > System.Web.Services.Protocols.SoapException: The report server
> > installation is not initialized. Check the documentation for more
> > information. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> > The report server installation is not initialized. Check the documentation
> > for more information. --> System.Runtime.InteropServices.COMException
> > (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32 clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > at
> > Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > storedProcedureName)
> > at
> > Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> > key)
> > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> > name)
> > at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> > name)
> > at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > source)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path, Boolean validate, Boolean convert, Boolean translate)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path)
> > at
> > Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> > pathTranslator, String userSuppliedPath, String parameterName)
> > at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> > item, StringCollection& Operations)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> > Item, String[]& Permissions)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> > Item, String[]& Permissions)
> > w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> > --Details--
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: The report server
> > installation is not initialized. Check the documentation for more
> > information. -->
> > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> > The report server installation is not initialized. Check the documentation
> > for more information. --> System.Runtime.InteropServices.COMException
> > (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> > Int32 extendedError)
> >
> > --RSACTIVATE--
> > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer>rsac
> > tivate -c rsreportserver.config
> > Failure starting the web service:
> > Unable to connect to the database (-2147159551) 0x8007007f
> >
> >
>
>|||I tried that too. I am thinking that the problem might be with .net 1.1
Unfortunately it's not possible to uninstall and reinstall that part.
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>|||Formatted, new 2003...
It works... Thanks...
"Skeptical" <skep@.yahoo.com> wrote in message
news:u$HR9t74EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I installed RS on a Windows 2003 box with SQL Server 2000 sp3.
> Unfortunately setup reported that it could not initialize RS and it has to
> be initialized manually
> I have tried:
> rsconfig & rsactivate with tons of different combinations of users
> ranging from local system account to domain admin No luck, neither
> windows nor sql authentications work, I tried some solutions suggested
> here and there like re registering .net 1.1, installing a hotfix, adding
> permission to some registry keys... etc. no luck.
> The server is not a DC,
> It's not going to be a part of a RS webfarm
> A clean RS database is being used
> There are no other web sites on the server
> I tried re installing many many times, I even reinstalled SQL server and
> applied sp3, still no luck...
> It reports of a database connection failure, but I tried to
> config/activate it as sa or windows admin it still fails...
> I am out of options at this point. Anyone has a suggestion?
> Thanks
> PS: Below are the error messages from the log and rsactivate
>
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32 clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
> Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
> Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator
> pathTranslator, String userSuppliedPath, String parameterName)
> at Microsoft.ReportingServices.Library.RSService.GetPermissions(String
> item, StringCollection& Operations)
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String
> Item, String[]& Permissions)
> w3wp!ui!afc!12/16/2004-15:02:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: The report server
> installation is not initialized. Check the documentation for more
> information. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedException:
> The report server installation is not initialized. Check the documentation
> for more information. --> System.Runtime.InteropServices.COMException
> (0x80004005): -2147159551 --> System.Exception: 0x8007007f
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> --RSACTIVATE--
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>rsac
> tivate -c rsreportserver.config
> Failure starting the web service:
> Unable to connect to the database (-2147159551) 0x8007007f
>
Subscribe to:
Posts (Atom)