sql server reporting services: Reporting services initilization problem -- sql server reporting services

You're in the

sql server reporting services

group:

Reporting services initilization problem

Re: Reporting services initilization problem

Daniel Reib [MSFT]
12/16/2004 2:24:07 PM

sql server reporting services: The 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.

[quoted text, click to view]

Reporting services initilization problem

Skeptical
12/16/2004 4:06:24 PM

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

Re: Reporting services initilization problem

Skeptical
12/16/2004 7:26:13 PM

Well, I forgot to mention. I have already tried that :(
I am thinking of reinstalling 2003 or even downgrading to 2000
Any other suggestions ?

[quoted text, click to view]

Re: Reporting services initilization problem

Herman K
12/16/2004 7:41:03 PM

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.

[quoted text, click to view]

Re: Reporting services initilization problem

Skeptical
12/17/2004 10:43:25 AM

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.

[quoted text, click to view]

Re: Reporting services initilization problem

Skeptical
12/18/2004 1:45:26 PM

Formatted, new 2003...

It works... Thanks...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn