RSActivate Error

I am getting the following error when attempting to run RSActivate to add a
server to a web farm:
Failure starting the web service:
The local NT service is not activated
The log file contains the following entries:
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
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 --
w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
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(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng 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.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()What error do you see in the Windows service log file?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> I am getting the following error when attempting to run RSActivate to add
a
> server to a web farm:
> Failure starting the web service:
> The local NT service is not activated
> The log file contains the following entries:
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> 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 --
> w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> 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(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng 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.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>|||Here is what I see in the Windows service log file:
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
public key
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT Service
not activated
ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
start service again...
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> What error do you see in the Windows service log file?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > I am getting the following error when attempting to run RSActivate to
add
> a
> > server to a web farm:
> >
> > Failure starting the web service:
> > The local NT service is not activated
> >
> > The log file contains the following entries:
> >
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
user:
> > NT AUTHORITY\NETWORK SERVICE
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > Activating web service via RPC.
> > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information., ;
> > Info:
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > 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 --
> > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
error
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > 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(Stri
> > ng key)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > (String name)
> > at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > ng 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.WebServer.ReportServiceHttpHandler.RenderPageCon
> > tent()
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
>|||Are you reusing a database from a previous installation? It looks like the
windows service is not activating automatically because it thinks another
report server is using the database. If this is not the case, you can clear
out the old entries by running rskeymgmt -d, then restart the windows and
web service.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:upNDrRJhEHA.3980@.TK2MSFTNGP12.phx.gbl...
> Here is what I see in the Windows service log file:
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT
Service
> not activated
> ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR:
Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
> while starting service. Error:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
> start service again...
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> > What error do you see in the Windows service log file?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> > news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > > I am getting the following error when attempting to run RSActivate to
> add
> > a
> > > server to a web farm:
> > >
> > > Failure starting the web service:
> > > The local NT service is not activated
> > >
> > > The log file contains the following entries:
> > >
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
> user:
> > > NT AUTHORITY\NETWORK SERVICE
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not
activated
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > > Activating web service via RPC.
> > > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information., ;
> > > Info:
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > 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 --
> > > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
> error
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > 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(Stri
> > > ng key)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > > (String name)
> > > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > > name)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > > ng 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.WebServer.ReportServiceHttpHandler.RenderPageCon
> > > tent()
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > >
> > >
> >
> >
>

RS2005 email delivery problem

We started using RS 2005 web farm a month ago. Since then we have
problem delivering reports trough email. When using shared
subscription with several reports some reports are sent and some are
not.
Errors displayed by various parts of system are below:
Subscription Last Status text:
The delivery extension for this subscription could not be loaded.
Windows Application event log:
Report Server (MSSQLSERVER) cannot load the Report Server
DocumentLibrary
extension.
At first we thought that problem is our postfix mail server so we
transferred from directly sending mail to sending mail to local SMTP
which then sends mail to postfix. One problem was a connection
timeout. It seems that connection with mail server is opened at the
same time the shared schedule execution has started. With SMTP service
standard time-out of 10 minutes or so reports lasting more than that
have no chance to be sent. So my solution was installing local SMTP
Service from windows components setup and setting its timeout to
timeout needed by our reports. But the problem didn't go away. I was
hoping that unsent mail will be in badmail SMTP folder or that I will
find it in drop folder as unsent mail. Strange thing is that all the
folders are empty. There is no bad mail. My SRS can't send mail to my
local SMTP! When shared subscription with several reports is fired
connection to local SMTP is created. I can see it in Current Sessions.
If subscription is shared I suppose that reports, belonging to shared
subscription, are being executed one by one and sent to SMTP server as
they are finished. Time out of my SMTP is 180 minutes. All the reports
executed one by one take about 30 minutes so I guess now time out is
not a problem. I think that there are 2 possible reasons:
1. Opened connection to SMTP somehow brakes between two reports being
sent and can't be reestablished
2. SRS successfully execute some reports and send them to SMTP and
when next report is finished and have to be sent, SRS can't load DLL
needed to send mail.
Every suggestion will be appreciated!Any ideas?
ijeremi...@.gmail.com wrote:
> We started using RS 2005 web farm a month ago. Since then we have
> problem delivering reports trough email. When using shared
> subscription with several reports some reports are sent and some are
> not.
> Errors displayed by various parts of system are below:
> Subscription Last Status text:
> The delivery extension for this subscription could not be loaded.
> Windows Application event log:
> Report Server (MSSQLSERVER) cannot load the Report Server
> DocumentLibrary
> extension.
> At first we thought that problem is our postfix mail server so we
> transferred from directly sending mail to sending mail to local SMTP
> which then sends mail to postfix. One problem was a connection
> timeout. It seems that connection with mail server is opened at the
> same time the shared schedule execution has started. With SMTP service
> standard time-out of 10 minutes or so reports lasting more than that
> have no chance to be sent. So my solution was installing local SMTP
> Service from windows components setup and setting its timeout to
> timeout needed by our reports. But the problem didn't go away. I was
> hoping that unsent mail will be in badmail SMTP folder or that I will
> find it in drop folder as unsent mail. Strange thing is that all the
> folders are empty. There is no bad mail. My SRS can't send mail to my
> local SMTP! When shared subscription with several reports is fired
> connection to local SMTP is created. I can see it in Current Sessions.
> If subscription is shared I suppose that reports, belonging to shared
> subscription, are being executed one by one and sent to SMTP server as
> they are finished. Time out of my SMTP is 180 minutes. All the reports
> executed one by one take about 30 minutes so I guess now time out is
> not a problem. I think that there are 2 possible reasons:
> 1. Opened connection to SMTP somehow brakes between two reports being
> sent and can't be reestablished
> 2. SRS successfully execute some reports and send them to SMTP and
> when next report is finished and have to be sent, SRS can't load DLL
> needed to send mail.
> Every suggestion will be appreciated!|||If no-one responds here I suggest trying the web based forums. That is where
MS people hang out and the other RS MVP.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ijeremicyu@.gmail.com> wrote in message
news:1184243847.242957.320910@.w3g2000hsg.googlegroups.com...
> Any ideas?
> ijeremi...@.gmail.com wrote:
>> We started using RS 2005 web farm a month ago. Since then we have
>> problem delivering reports trough email. When using shared
>> subscription with several reports some reports are sent and some are
>> not.
>> Errors displayed by various parts of system are below:
>> Subscription Last Status text:
>> The delivery extension for this subscription could not be loaded.
>> Windows Application event log:
>> Report Server (MSSQLSERVER) cannot load the Report Server
>> DocumentLibrary
>> extension.
>> At first we thought that problem is our postfix mail server so we
>> transferred from directly sending mail to sending mail to local SMTP
>> which then sends mail to postfix. One problem was a connection
>> timeout. It seems that connection with mail server is opened at the
>> same time the shared schedule execution has started. With SMTP service
>> standard time-out of 10 minutes or so reports lasting more than that
>> have no chance to be sent. So my solution was installing local SMTP
>> Service from windows components setup and setting its timeout to
>> timeout needed by our reports. But the problem didn't go away. I was
>> hoping that unsent mail will be in badmail SMTP folder or that I will
>> find it in drop folder as unsent mail. Strange thing is that all the
>> folders are empty. There is no bad mail. My SRS can't send mail to my
>> local SMTP! When shared subscription with several reports is fired
>> connection to local SMTP is created. I can see it in Current Sessions.
>> If subscription is shared I suppose that reports, belonging to shared
>> subscription, are being executed one by one and sent to SMTP server as
>> they are finished. Time out of my SMTP is 180 minutes. All the reports
>> executed one by one take about 30 minutes so I guess now time out is
>> not a problem. I think that there are 2 possible reasons:
>> 1. Opened connection to SMTP somehow brakes between two reports being
>> sent and can't be reestablished
>> 2. SRS successfully execute some reports and send them to SMTP and
>> when next report is finished and have to be sent, SRS can't load DLL
>> needed to send mail.
>> Every suggestion will be appreciated!
>sql

RS web farm installation problem

Hi,
we have a web farm of two IIS servers, running under Windows 2003. Because of the security requirements, the servers are not part of a domain. After installing the Reporting Services on both machines, we have an activation problem: activation of the second server de-activates the first one and vice versa.
Following configuration is being used:
- Mirrored windows accounts are used to run RS windows and web services
- A SQL account is used to connect to the ReportServer database
- A mirrored account with RS administrative privileges is used to connect to another Report Server in the web farm
Is it possible at all to install the Reporting Server in such a configuration?
Please advise.
--
Regards,
Alex Korygin.do you copy the config files?
or do you use the rsconfig tool to setup the RS database connection?
Because RS generates an encrypted key at startup. This key is unique for
each computer.
Also, do you use the enterprise edition?
"Alex Korygin" <AlexKorygin@.discussions.microsoft.com> a écrit dans le
message de news:EDE0C681-C3D2-4BCC-A853-EEEA0312CAC5@.microsoft.com...
> Hi,
> we have a web farm of two IIS servers, running under Windows 2003. Because
of the security requirements, the servers are not part of a domain. After
installing the Reporting Services on both machines, we have an activation
problem: activation of the second server de-activates the first one and vice
versa.
> Following configuration is being used:
> - Mirrored windows accounts are used to run RS windows and web services
> - A SQL account is used to connect to the ReportServer database
> - A mirrored account with RS administrative privileges is used to connect
to another Report Server in the web farm
> Is it possible at all to install the Reporting Server in such a
configuration?
> Please advise.
> --
> Regards,
> Alex Korygin.|||Jéjé,
I'm sorry for not responding earlier. We use rsconfig utility to activate the Reporting Servers. And yes, we have the Enterprise edition installed. Does it have anything to do with the fact that we use mirrored accounts and domain names of each account are different?
There must be some way to work around. I hope we do not need a domain to get it working; not having the domain in the production environment is a commonly used case. Thanks.
--
Regards,
Alex Korygin.
"Jéjé" wrote:
> do you copy the config files?
> or do you use the rsconfig tool to setup the RS database connection?
> Because RS generates an encrypted key at startup. This key is unique for
> each computer.
> Also, do you use the enterprise edition?
>
> "Alex Korygin" <AlexKorygin@.discussions.microsoft.com> a écrit dans le
> message de news:EDE0C681-C3D2-4BCC-A853-EEEA0312CAC5@.microsoft.com...
> > Hi,
> >
> > we have a web farm of two IIS servers, running under Windows 2003. Because
> of the security requirements, the servers are not part of a domain. After
> installing the Reporting Services on both machines, we have an activation
> problem: activation of the second server de-activates the first one and vice
> versa.
> > Following configuration is being used:
> > - Mirrored windows accounts are used to run RS windows and web services
> > - A SQL account is used to connect to the ReportServer database
> > - A mirrored account with RS administrative privileges is used to connect
> to another Report Server in the web farm
> >
> > Is it possible at all to install the Reporting Server in such a
> configuration?
> > Please advise.
> >
> > --
> > Regards,
> >
> > Alex Korygin.
>
>

RS architecture

Hi ,
I need to use a RS 2005 on a web farm ,
displaing the reports as part of my web application,
connected to asingle SS 2005.
Do I need to install RS on every web server ?
Do I need to pay for every instanse installed on the web farm ?
10x,
Liz.For a web farm you need license for SQL Server Enterprise Edition on each
web server and on the SQL Server Database. RS is a asp.net application that
uses SQL Server database as an object store (all reports, subscriptions, etc
are stored in the database).
Now, if you want to have a web farm that uses either URL integration or web
services to integrate with RS then you could have your application on a web
farm and RS on a single server (either the server with your database or on a
IIS box). Anyplace RS is installed you need a license. If you integrated
your app with RS and you have RS installed only on a single box then you
could use either standard or enterprise edition. A good link to check out:
http://www.microsoft.com/technet/prodtechnol/sql/2000/technologies/rptsvcs.mspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz Matyas" <lizmts@.mail.com> wrote in message
news:eAG6BAcpFHA.2444@.tk2msftngp13.phx.gbl...
> Hi ,
> I need to use a RS 2005 on a web farm ,
> displaing the reports as part of my web application,
> connected to asingle SS 2005.
> Do I need to install RS on every web server ?
> Do I need to pay for every instanse installed on the web farm ?
> 10x,
> Liz.
>