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
>