RSActivate

I have just installed RS (Standard Edition on Win2K. SQL instance on same
server). At the end of install, I got a dialog that said: Setup could not
initialize the report server. You must manually initialize the report
server before using using it for the first time..
I ran:
rsconfig -c -s sqlservername -d ReportServer -a SQL -u username -p
password
It returned:
The command completed successfully
I then ran:
rsactivate -c"C:\Program Files\.\RSReportServer.config" -t
It returns:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) .
I appreciate any help on this. Thanks!Hi Todd!
Did you find a solution? I have the same problem.
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=89f0d955-4f23-47a2-886b-dc3a6d8ec457&cat=en-us-msdnman-eprise-sql&lang=en&cr=US&sloc=en-us&m=1&p=1#top
thx, yara
"Todd" wrote:
> I have just installed RS (Standard Edition on Win2K. SQL instance on same
> server). At the end of install, I got a dialog that said: Setup could not
> initialize the report server. You must manually initialize the report
> server before using using it for the first time..
> I ran:
> rsconfig -c -s sqlservername -d ReportServer -a SQL -u username -p
> password
>
> It returned:
> The command completed successfully
>
> I then ran:
> rsactivate -c"C:\Program Files\.\RSReportServer.config" -t
>
> It returns:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548) .
>
> I appreciate any help on this. Thanks!
>
>

RS2005 Standard install error..

I am installing SQL 2005 and RS 2005 on a new W2k3 server. I have tried to
install to a default instance and to a named instance and continue to get the
following error when I try to retrieve the reports page or connect to the
reporting services thru Microsoft SQL server Management Studio.
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
In the Log file ReportServerWebApp__01_03_2006_13_51_00.log I see:
w3wp!ui!7!1/3/2006-12:01:32:: e ERROR: The attempt to connect to the report
server failed. Check your connection information and that the report server
is a compatible version.
w3wp!ui!7!1/3/2006-12:01:33:: e ERROR: HTTP status code --> 500
--Details--
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version. -->
System.Net.WebException: The request failed with HTTP status 404: Not Found.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
-- End of inner exception stack trace --
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!1/3/2006-12:01:34:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Did anyone find a solutions to this issue, i have encountered the same
problem, and cannot seem to get it to work.
Thanks
Jim wrote:
> I am installing SQL 2005 and RS 2005 on a new W2k3 server. I have tried to
> install to a default instance and to a named instance and continue to get the
> following error when I try to retrieve the reports page or connect to the
> reporting services thru Microsoft SQL server Management Studio.
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
>
> In the Log file ReportServerWebApp__01_03_2006_13_51_00.log I see:
>
> w3wp!ui!7!1/3/2006-12:01:32:: e ERROR: The attempt to connect to the report
> server failed. Check your connection information and that the report server
> is a compatible version.
> w3wp!ui!7!1/3/2006-12:01:33:: e ERROR: HTTP status code --> 500
> --Details--
> Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version. -->
> System.Net.WebException: The request failed with HTTP status 404: Not Found.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> -- End of inner exception stack trace --
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!1/3/2006-12:01:34:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)|||I'm experiencing the same problems, you might think it has something to do
with SSL, but it is not necessary to use it, is it?
I would be very pleased with some help regarding this subject!|||Why are no microsoft people responding to these posts? Thought that was the
deal with this support option via msdn?
I'm having the same issue and have yet to get report manager to work via
http://servername/reports.
--
Thanks,
Chris.
"Ruud0011" wrote:
> I'm experiencing the same problems, you might think it has something to do
> with SSL, but it is not necessary to use it, is it?
> I would be very pleased with some help regarding this subject!|||I've had this same issue. I installed RS2005 and VS2005 on a new Windows
2003 server. This was not an upgrade. I am using an SSL certificate and
edited the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager\RSWebApplication.config file by removing the entry for
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
The ReportURL entry looks like this
ReportServerUrl>https://localhost/reportserver</ReportServerUrl> -- Note that
it says "reportserver" and not reports which is why I kept getting the same
error. The C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\RSReportServer.config file was edited to reflect the
SecureConnectionLevel Value 3 and the URLRoot was
https://localhost/reportserver
All is well. No more error messages.
WMH
"whoopdaddy" wrote:
> Why are no microsoft people responding to these posts? Thought that was the
> deal with this support option via msdn?
> I'm having the same issue and have yet to get report manager to work via
> http://servername/reports.
> --
> Thanks,
> Chris.
>
> "Ruud0011" wrote:
> > I'm experiencing the same problems, you might think it has something to do
> > with SSL, but it is not necessary to use it, is it?
> >
> > I would be very pleased with some help regarding this subject!|||Thanks WMH - I had same problem - just spent a few very frustrating days
trying to fix this until I spotted your advice.
Paddy
"WMH" wrote:
> I've had this same issue. I installed RS2005 and VS2005 on a new Windows
> 2003 server. This was not an upgrade. I am using an SSL certificate and
> edited the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config file by removing the entry for
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
> The ReportURL entry looks like this
> ReportServerUrl>https://localhost/reportserver</ReportServerUrl> -- Note that
> it says "reportserver" and not reports which is why I kept getting the same
> error. The C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\RSReportServer.config file was edited to reflect the
> SecureConnectionLevel Value 3 and the URLRoot was
> https://localhost/reportserver
> All is well. No more error messages.
> WMH
>
> "whoopdaddy" wrote:
> > Why are no microsoft people responding to these posts? Thought that was the
> > deal with this support option via msdn?
> >
> > I'm having the same issue and have yet to get report manager to work via
> > http://servername/reports.
> > --
> > Thanks,
> > Chris.
> >
> >
> > "Ruud0011" wrote:
> >
> > > I'm experiencing the same problems, you might think it has something to do
> > > with SSL, but it is not necessary to use it, is it?
> > >
> > > I would be very pleased with some help regarding this subject!|||I feel certain that I missed some important documentation that Microsoft
provided us on this issue, but your "removing the entry for
<ReportServerVirtualDirectory>" is the best information on this error
message. I don't have SSL and the Configuration Tool doesn't fix this problem
when you move the virtual directories to another website. I have wasted
entirely too many hours on this and have actually reloaded our 2003 server
twice. Simply remove the <ReportServerVirtualDirectory> tag and all is well.
Thank you very much for your post!!!
Thanks,
Chris
"WMH" wrote:
> I've had this same issue. I installed RS2005 and VS2005 on a new Windows
> 2003 server. This was not an upgrade. I am using an SSL certificate and
> edited the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config file by removing the entry for
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
> The ReportURL entry looks like this
> ReportServerUrl>https://localhost/reportserver</ReportServerUrl> -- Note that
> it says "reportserver" and not reports which is why I kept getting the same
> error. The C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\RSReportServer.config file was edited to reflect the
> SecureConnectionLevel Value 3 and the URLRoot was
> https://localhost/reportserver
> All is well. No more error messages.
> WMH
>
> "whoopdaddy" wrote:
> > Why are no microsoft people responding to these posts? Thought that was the
> > deal with this support option via msdn?
> >
> > I'm having the same issue and have yet to get report manager to work via
> > http://servername/reports.
> > --
> > Thanks,
> > Chris.
> >
> >
> > "Ruud0011" wrote:
> >
> > > I'm experiencing the same problems, you might think it has something to do
> > > with SSL, but it is not necessary to use it, is it?
> > >
> > > I would be very pleased with some help regarding this subject!

rs won't start

I got 4 computers, all connected to a domain controller. I got one instance
of standard report server running OK on the W2k domain controller. On my
other 3 machines I installed one local copy of report server developper
edition together with VS 2003( I develop different projects on different
machines, its a good way I think to keep em clearly separated and have one
portable for demos). Anyway, problem is that after doing a successfull
install on all three machines when I start report server I can't access the
server On all of the 3 client computers I have the report server databases
and web sites installed locally in the local inetpub folders. I log in as a
domain adminisitrator and I gave Iwam_machineName full rights to the the
local bin folders. The aspent_wp.exe service is running locally under the
local system account. In spite of all of this I always get.
Server Error in '/Reports' Application.
----
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String
userPath, Boolean file) +229
System.IO.Directory.InternalGetDirectories(String path, String userPath,
String searchPattern) +24
System.IO.Directory.GetDirectories(String path, String searchPattern)
+477
Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localization..cctor()
[TypeInitializationException: The type initializer for
"Microsoft.ReportingServices.Diagnostics.Localization" threw an exception.]
Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
localeList) +0
Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
sender, EventArgs e)
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
I can successfully access the report server on the server computer using
my internet explorer, but never any of the local report server instances. I
have exactly the identical problem at a customer site where I installed
report services on their sql server, following the steps outlined in the ms
docs.
I also think that if I try to run a webservice locally o an of these
machines it will fail with essentially the same message, going to try that
next using the ms samples on my laptop, will keep you posted. Something is
amiss. Has anyone had similar experioences and how did you fix them.
Thanks for any help.
BobJust started the ms sample Async web service on my laptop, that works OK. I
thinkthe problem lies in the security configuration section of the web.
config file but I don't know what to change so that I keep the normal
secirity functionality of the application.
Help, help, help :-(
Bob
"Bob" <bdufour@.sgiims.com> wrote in message
news:%23oiyUjttFHA.2328@.TK2MSFTNGP10.phx.gbl...
>I got 4 computers, all connected to a domain controller. I got one instance
>of standard report server running OK on the W2k domain controller. On my
>other 3 machines I installed one local copy of report server developper
>edition together with VS 2003( I develop different projects on different
>machines, its a good way I think to keep em clearly separated and have one
>portable for demos). Anyway, problem is that after doing a successfull
>install on all three machines when I start report server I can't access the
>server On all of the 3 client computers I have the report server databases
>and web sites installed locally in the local inetpub folders. I log in as a
>domain adminisitrator and I gave Iwam_machineName full rights to the the
>local bin folders. The aspent_wp.exe service is running locally under the
>local system account. In spite of all of this I always get.
>
> Server Error in '/Reports' Application.
> ----
> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.UnauthorizedAccessException: Access to the path
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> ASP.NET is not authorized to access the requested resource. Consider
> granting access rights to the resource to the ASP.NET request identity.
> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
> or Network Service on IIS 6) that is used if the application is not
> impersonating. If the application is impersonating via <identity
> impersonate="true"/>, the identity will be the anonymous user (typically
> IUSR_MACHINENAME) or the authenticated request user.
> To grant ASP.NET write access to a file, right-click the file in Explorer,
> choose "Properties" and select the Security tab. Click "Add" to add the
> appropriate user or group. Highlight the ASP.NET account, and check the
> boxes for the desired access.
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
> Stack Trace:
> [UnauthorizedAccessException: Access to the path "C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
> denied.]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
> String userPath, Boolean file) +229
> System.IO.Directory.InternalGetDirectories(String path, String userPath,
> String searchPattern) +24
> System.IO.Directory.GetDirectories(String path, String searchPattern)
> +477
> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
> [TypeInitializationException: The type initializer for
> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
> exception.]
> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
> localeList) +0
> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
> sender, EventArgs e)
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> +60
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +87
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> I can successfully access the report server on the server computer using
> my internet explorer, but never any of the local report server instances.
> I have exactly the identical problem at a customer site where I installed
> report services on their sql server, following the steps outlined in the
> ms docs.
> I also think that if I try to run a webservice locally o an of these
> machines it will fail with essentially the same message, going to try that
> next using the ms samples on my laptop, will keep you posted. Something is
> amiss. Has anyone had similar experioences and how did you fix them.
> Thanks for any help.
> Bob
>|||Further Info: Te docs says to give permissions to the account
Iwam_MachineName, but because we are on a domain controller the only ASPNET
account that I can find is IWAM_DomainName.
I give that account rights to either the default internet root folder or to
the bin folder of the reportserver. It still does not work.
Bob, help , you don't wanna see a grown man cry :-(
"Bob" <bdufour@.sgiims.com> wrote in message
news:eXLRKtttFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Just started the ms sample Async web service on my laptop, that works OK.
> I thinkthe problem lies in the security configuration section of the web.
> config file but I don't know what to change so that I keep the normal
> secirity functionality of the application.
> Help, help, help :-(
> Bob
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:%23oiyUjttFHA.2328@.TK2MSFTNGP10.phx.gbl...
>>I got 4 computers, all connected to a domain controller. I got one
>>instance of standard report server running OK on the W2k domain
>>controller. On my other 3 machines I installed one local copy of report
>>server developper edition together with VS 2003( I develop different
>>projects on different machines, its a good way I think to keep em clearly
>>separated and have one portable for demos). Anyway, problem is that after
>>doing a successfull install on all three machines when I start report
>>server I can't access the server On all of the 3 client computers I have
>>the report server databases and web sites installed locally in the local
>>inetpub folders. I log in as a domain adminisitrator and I gave
>>Iwam_machineName full rights to the the local bin folders. The
>>aspent_wp.exe service is running locally under the local system account.
>>In spite of all of this I always get.
>>
>> Server Error in '/Reports' Application.
>> ----
>> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>> Exception Details: System.UnauthorizedAccessException: Access to the path
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> ASP.NET is not authorized to access the requested resource. Consider
>> granting access rights to the resource to the ASP.NET request identity.
>> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
>> or Network Service on IIS 6) that is used if the application is not
>> impersonating. If the application is impersonating via <identity
>> impersonate="true"/>, the identity will be the anonymous user (typically
>> IUSR_MACHINENAME) or the authenticated request user.
>> To grant ASP.NET write access to a file, right-click the file in
>> Explorer, choose "Properties" and select the Security tab. Click "Add" to
>> add the appropriate user or group. Highlight the ASP.NET account, and
>> check the boxes for the desired access.
>> Source Error:
>> An unhandled exception was generated during the execution of the
>> current web request. Information regarding the origin and location of the
>> exception can be identified using the exception stack trace below.
>> Stack Trace:
>> [UnauthorizedAccessException: Access to the path "C:\Program
>> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
>> denied.]
>> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
>> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
>> String userPath, Boolean file) +229
>> System.IO.Directory.InternalGetDirectories(String path, String
>> userPath, String searchPattern) +24
>> System.IO.Directory.GetDirectories(String path, String searchPattern)
>> +477
>> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
>> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
>> [TypeInitializationException: The type initializer for
>> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
>> exception.]
>> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
>> localeList) +0
>> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
>> sender, EventArgs e)
>> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
>> +60
>> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
>> completedSynchronously) +87
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>> I can successfully access the report server on the server computer
>> using my internet explorer, but never any of the local report server
>> instances. I have exactly the identical problem at a customer site where
>> I installed report services on their sql server, following the steps
>> outlined in the ms docs.
>> I also think that if I try to run a webservice locally o an of these
>> machines it will fail with essentially the same message, going to try
>> that next using the ms samples on my laptop, will keep you posted.
>> Something is amiss. Has anyone had similar experioences and how did you
>> fix them.
>> Thanks for any help.
>> Bob
>

RS URL access

Is URL access possible using SQL Server Standard Edition?

Assuming you are talking about accessing Reporting Services via URL access, it is supported in all editions. If you are talking about HTTP endpoints in the database, they are supported in standard and enterprise.

See http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx for full edition differences.|||It is RS but SQL Server 2000 not 2005.|||yes. if you still have not found out. I use 2000 version too because we have not got around to getting updated.

RS Service Pack 1 question

Does installing RS SP1 upgrade the version of sql server? We are
running SP3A as a standard. I want to verify that if I install RS sp1
sql server will not be upgraded to 8.00.859 (this version contains a
hotfix). We noticed our test sever contains the hotfix and are
trying to figure out how it got there. RS SP1 was installed about a
week back.Are you sure that someone didn't install it? If your test server is running
Windows 2003 the install instruction say to install that hotfix.
I don't think SP1 does anything to the SQL Server version but I am not at
work today to verify that. I know it does upgrade the database used by RS
but that is just normal data objects, not applying a hotfix.
Bruce L-C
"Dave" <davidbr93@.hotmail.com> wrote in message
news:4e5222b5.0408130700.52c993f2@.posting.google.com...
> Does installing RS SP1 upgrade the version of sql server? We are
> running SP3A as a standard. I want to verify that if I install RS sp1
> sql server will not be upgraded to 8.00.859 (this version contains a
> hotfix). We noticed our test sever contains the hotfix and are
> trying to figure out how it got there. RS SP1 was installed about a
> week back.|||SP1 does NOT upgrade the SQL server. It does upgrade the database that RS
uses.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lc@.hotmail.com> wrote in message
news:OVE6tjUgEHA.592@.TK2MSFTNGP11.phx.gbl...
> Are you sure that someone didn't install it? If your test server is
running
> Windows 2003 the install instruction say to install that hotfix.
> I don't think SP1 does anything to the SQL Server version but I am not at
> work today to verify that. I know it does upgrade the database used by RS
> but that is just normal data objects, not applying a hotfix.
> Bruce L-C
>
> "Dave" <davidbr93@.hotmail.com> wrote in message
> news:4e5222b5.0408130700.52c993f2@.posting.google.com...
> > Does installing RS SP1 upgrade the version of sql server? We are
> > running SP3A as a standard. I want to verify that if I install RS sp1
> > sql server will not be upgraded to 8.00.859 (this version contains a
> > hotfix). We noticed our test sever contains the hotfix and are
> > trying to figure out how it got there. RS SP1 was installed about a
> > week back.
>

RS problems after upgrade from SQLExpress to Standard

Hello

I've uninstalled SQLExpress(with adv. features, RS worked fine) and then installed Standard edition.

After reinstallation and deploying reports I failed in viewing report through web browser.

Here are errors:

- when I try to view report

Reporting Services Error

---

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Error executing child request for /ReportServer/Pages/ReportViewer.aspx. Exception of type 'System.Web.HttpUnhandledException' was thrown. Value does not fall within the expected range.

- when I try to navigate to Get Online Help Error executing child request for /ReportServer/Pages/ReportViewer.aspx. Exception of type 'System.Web.HttpUnhandledException' was thrown. Value does not fall within the expected range.

- when I try to navigate to http://localhost/reports

The website cannot display the page

Thank you for any help!

Here is log:

aspnet_wp!library!1!05/09/2007-17:05:01:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.InvalidOperationException: Computer name could not be obtained.
at System.Environment.get_MachineName()
at Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String jobId, String requestPath, JobActionEnum action, JobType type, RunningJobList parentList, UserContext userContext, HttpContext optionalWebCtx)
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String jobId, String requestPath, JobActionEnum action, JobType jobType, UserContext userContext)

.....

aspnet_wp!library!1!05/09/2007-17:05:01:: e ERROR: Error rending control: System.ArgumentException: Value does not fall within the expected range.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Web.Configuration.MachineKeySection.GetHMACSHA1Hash(Byte[] buf, Byte[] modifier, Int32 start, Int32 length)
at System.Web.Configuration.MachineKeySection.HashData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length)
at System.Web.Configuration.MachineKeySection.GetEncodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32& length)
at System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph)
at System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state)
at System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph)
at System.Web.UI.HiddenFieldPageStatePersister.Save()
at System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state)
at System.Web.UI.Page.SaveAllState()

.....

RS Printing Issues with SP2

Hi,
I'm creating some reports using SQL RS .
Windows 2000 SP4,
SQL Server 2000, Standard Edition, SP3a
Reporting Services 2000 - SP2 ( recently updated)
Had no problems while updating with the new SP2.
But realised that the Print option in SP2 isn't working for me.
In the Web environment,
When we output the report, we can right click and click on the print ...it's
getting the printer dialog and now it goes to the printer
So, it's printing the same zoomed report whatever is currently there on the
screen..say 50% or 70%.
That's fine...but that will not print all the pages in the report.
But this new SP which is supposed to solve that prob...got the print option
When u print the report...irrespective of what u've got on the screen or
what u've zoomed..it's printing the 100% and crossing the page boundaries and
printing the report on two pages, though the width was set to 8"
Can anyone help me in resolving this.
I'm using Report Viewer to render my report.
Surprisingly, when I installed the RS SP2 on the server ( Windows 2003
SBS),open the same report and click on the print Icon, I'm getting some Error
related to GDI, and the entire application is gettiing crashed.
Thanks in advance.
srinivasTry re-deploying the report and printing again. There are some attributes
that the printing function need that only show up after redeploying the
report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"srinivas" <srinivas@.discussions.microsoft.com> wrote in message
news:E66C5E80-CDE3-4F78-8F42-EFE356652AEE@.microsoft.com...
> Hi,
> I'm creating some reports using SQL RS .
> Windows 2000 SP4,
> SQL Server 2000, Standard Edition, SP3a
> Reporting Services 2000 - SP2 ( recently updated)
> Had no problems while updating with the new SP2.
> But realised that the Print option in SP2 isn't working for me.
> In the Web environment,
> When we output the report, we can right click and click on the print
> ...it's
> getting the printer dialog and now it goes to the printer
> So, it's printing the same zoomed report whatever is currently there on
> the
> screen..say 50% or 70%.
> That's fine...but that will not print all the pages in the report.
> But this new SP which is supposed to solve that prob...got the print
> option
> When u print the report...irrespective of what u've got on the screen or
> what u've zoomed..it's printing the 100% and crossing the page boundaries
> and
> printing the report on two pages, though the width was set to 8"
> Can anyone help me in resolving this.
> I'm using Report Viewer to render my report.
> Surprisingly, when I installed the RS SP2 on the server ( Windows 2003
> SBS),open the same report and click on the print Icon, I'm getting some
> Error
> related to GDI, and the entire application is gettiing crashed.
> Thanks in advance.
> srinivas

RS installation trouble on the server

We have a server machine running Window 2000, .net 1.1 framework and SQL
server 2000 standard edition and it's a domain controller. We tried to
install RS standard edition onto that server machine. At the end of
installation, the message shows that Setup has successfully installed RS, but
Setup can't initialize Report Server. So we manually initialize report server
from command line by using rsactivate -c"path to RSReporttserver.config" and
it was succeful. However, when we tried to verify the installation by going
to "http://servername/reportserver", we got the internal error and access is
denied and when we tried to access "http://servername/reports", we got the
error of "Access to the path "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\bin" is denied." We tried both
Local system and domain account during the installation but with the same
error occured.
Any help will be highly appreciated.Look at section 1.8 in the Reporting Services README.
You'd be surprised how much good stuff gets overlooked in there...
I hope this helps.
David
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:9AFF2D07-BFB2-4221-94D8-081AB4140748@.microsoft.com...
> We have a server machine running Window 2000, .net 1.1 framework and SQL
> server 2000 standard edition and it's a domain controller. We tried to
> install RS standard edition onto that server machine. At the end of
> installation, the message shows that Setup has successfully installed RS,
> but
> Setup can't initialize Report Server. So we manually initialize report
> server
> from command line by using rsactivate -c"path to RSReporttserver.config"
> and
> it was succeful. However, when we tried to verify the installation by
> going
> to "http://servername/reportserver", we got the internal error and access
> is
> denied and when we tried to access "http://servername/reports", we got the
> error of "Access to the path "C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportManager\bin" is denied." We tried
> both
> Local system and domain account during the installation but with the same
> error occured.
> Any help will be highly appreciated.
>
>

RS Install killing me w/ 'NT AUTHORITY\ANONYMOUS LOGON' error

Hi - my config is as follows:
- RS Standard on Windows Server 2003 (server1)
- SQL Server 2000 for repository on a different server server2 (same domain)
- I am logged onto server1 as domain admin (full SQL perms to server2)
- I have successfully installed other RS repositories to server2 (different
db names of course)
Installation fails at the "Configuring Microsoft SQL Server" part with error
message: "SQL Setup failed to connect to the database service for server
configuration. The error was: Login failed for user 'NT Authority\Anonymous
Logon'. "
It appears to be losing my interactively logged on credentials.
Here is info from the log:
SQL_ERROR (-1) in SQLDriverConnectW
sqlstate=28000, level=0, state=0, native_error=18456, msg=Login failed for
user 'NT AUTHORITY\ANONYMOUS LOGON'.
Error 29545. SQL Setup failed to connect to the database service for server
configuration. The error was: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.
Refer to the Server error logs and setup logs for more detailed information.
MSI (s) (F0!E4): Product: Microsoft SQL Server 2000 Reporting Services
Standard Edition -- Error 29545. SQL Setup failed to connect to the database
service for server configuration. The error was: Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.
Refe
r to the Server error logs and setup logs for more detailed information.
--
Thoughts?
thanksHow are permissions configured for server2? I've had some problems in the
past connecting from a local machine account to a domain sql server
(configured with mixed security). I was attempting SQL authentication. It
started working when I changed the service to run with a domain user
identity rather than a local machine user; then it connected with SQL
authentication just fine. That was odd, because I expected SQL
authentication to work regardless of the windows login identity.
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:576C839C-156B-4648-B9D2-DE56EB7EA60A@.microsoft.com...
> Hi - my config is as follows:
> - RS Standard on Windows Server 2003 (server1)
> - SQL Server 2000 for repository on a different server server2 (same
> domain)
> - I am logged onto server1 as domain admin (full SQL perms to server2)
> - I have successfully installed other RS repositories to server2
> (different
> db names of course)
> Installation fails at the "Configuring Microsoft SQL Server" part with
> error
> message: "SQL Setup failed to connect to the database service for server
> configuration. The error was: Login failed for user 'NT
> Authority\Anonymous
> Logon'. "
> It appears to be losing my interactively logged on credentials.
> Here is info from the log:
> SQL_ERROR (-1) in SQLDriverConnectW
> sqlstate=28000, level=0, state=0, native_error=18456, msg=Login failed for
> user 'NT AUTHORITY\ANONYMOUS LOGON'.
> Error 29545. SQL Setup failed to connect to the database service for
> server
> configuration. The error was: Login failed for user 'NT
> AUTHORITY\ANONYMOUS
> LOGON'.
> Refer to the Server error logs and setup logs for more detailed
> information.
> MSI (s) (F0!E4): Product: Microsoft SQL Server 2000 Reporting Services
> Standard Edition -- Error 29545. SQL Setup failed to connect to the
> database
> service for server configuration. The error was: Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.
> Refe
> r to the Server error logs and setup logs for more detailed information.
> --
> Thoughts?
> thanks|||Hi Jeff - Just to clarify my understanding of the installation process as a
baseline assumption so we're on the same page - it's the ID of the
interactively logged on user performing the install who the repository
database is created under.
Regarding permissions for server2, the user I am logged onto server1 as is
domainA\userA. This user is a domain admin and has full admin to server1 and
server2, as well as SQL Server on server2.
regards
"Jeff A. Stucker" wrote:
> How are permissions configured for server2? I've had some problems in the
> past connecting from a local machine account to a domain sql server
> (configured with mixed security). I was attempting SQL authentication. It
> started working when I changed the service to run with a domain user
> identity rather than a local machine user; then it connected with SQL
> authentication just fine. That was odd, because I expected SQL
> authentication to work regardless of the windows login identity.
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:576C839C-156B-4648-B9D2-DE56EB7EA60A@.microsoft.com...
> > Hi - my config is as follows:
> >
> > - RS Standard on Windows Server 2003 (server1)
> > - SQL Server 2000 for repository on a different server server2 (same
> > domain)
> > - I am logged onto server1 as domain admin (full SQL perms to server2)
> > - I have successfully installed other RS repositories to server2
> > (different
> > db names of course)
> >
> > Installation fails at the "Configuring Microsoft SQL Server" part with
> > error
> > message: "SQL Setup failed to connect to the database service for server
> > configuration. The error was: Login failed for user 'NT
> > Authority\Anonymous
> > Logon'. "
> >
> > It appears to be losing my interactively logged on credentials.
> >
> > Here is info from the log:
> >
> > SQL_ERROR (-1) in SQLDriverConnectW
> > sqlstate=28000, level=0, state=0, native_error=18456, msg=Login failed for
> > user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >
> > Error 29545. SQL Setup failed to connect to the database service for
> > server
> > configuration. The error was: Login failed for user 'NT
> > AUTHORITY\ANONYMOUS
> > LOGON'.
> > Refer to the Server error logs and setup logs for more detailed
> > information.
> > MSI (s) (F0!E4): Product: Microsoft SQL Server 2000 Reporting Services
> > Standard Edition -- Error 29545. SQL Setup failed to connect to the
> > database
> > service for server configuration. The error was: Login failed for user 'NT
> > AUTHORITY\ANONYMOUS LOGON'.
> > Refe
> > r to the Server error logs and setup logs for more detailed information.
> >
> > --
> >
> > Thoughts?
> > thanks
>
>|||I had the same problem when I installed RS yesterday. For some reason the
credentials are not passed correctly and I had to run the setup program from
the command line and explicitly pass it credentials with which to run the
setup program. The command to run setup ends up looking something like this:
setup /i "setup\rsrun.msi" RSSETUPACCOUNT=sa RSSETUPPASSWORD=sapwd
I've been told you can use any credentials you want (domain administrator,
etc.), but I just used the sql sa account, and that worked correctly.
I had the same problem when installing sp1. I had to manually extract the
.cab file and run setup from the command line once again:
sp1setup RSSETUPACCOUNT=sa RSSETUPPASSWORD=sapwd
Hope this helps.
David
"ISGADMIN" wrote:
> Hi - my config is as follows:
> - RS Standard on Windows Server 2003 (server1)
> - SQL Server 2000 for repository on a different server server2 (same domain)
> - I am logged onto server1 as domain admin (full SQL perms to server2)
> - I have successfully installed other RS repositories to server2 (different
> db names of course)
> Installation fails at the "Configuring Microsoft SQL Server" part with error
> message: "SQL Setup failed to connect to the database service for server
> configuration. The error was: Login failed for user 'NT Authority\Anonymous
> Logon'. "
> It appears to be losing my interactively logged on credentials.
> Here is info from the log:
> SQL_ERROR (-1) in SQLDriverConnectW
> sqlstate=28000, level=0, state=0, native_error=18456, msg=Login failed for
> user 'NT AUTHORITY\ANONYMOUS LOGON'.
> Error 29545. SQL Setup failed to connect to the database service for server
> configuration. The error was: Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.
> Refer to the Server error logs and setup logs for more detailed information.
> MSI (s) (F0!E4): Product: Microsoft SQL Server 2000 Reporting Services
> Standard Edition -- Error 29545. SQL Setup failed to connect to the database
> service for server configuration. The error was: Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.
> Refe
> r to the Server error logs and setup logs for more detailed information.
> --
> Thoughts?
> thanks|||> Installation fails at the "Configuring Microsoft SQL Server" part
with error
> message: "SQL Setup failed to connect to the database service for
server
> configuration. The error was: Login failed for user 'NT
Authority\Anonymous
> Logon'. "
>
Another fix for this - add the 'NT Authority\Anonymous Logon' account
as Local Admin on the SQL Server box and then be sure
Builtin\Administrators has SA access on the SQL Server.
Run the install and then change the dbowner to "sa" and remove the
account.
That's how I finally got it installed on a Win2003 box...
-Annette

RS Backup

Hi,
I have SQL Reporting Services SP1 standard edition and I am trying to
develop a disaster recovery process.
The challange that I have is I don't know how to restore a new server using
exsting backup. The Reporting Services installation program always try to
create a new database. How can I make it work with existing restored
database?
Thanks,
AlanHi Alan,
From your descriptions, I understood that you would like to backup existing
database and restore it in another new machine. Have I understood you?
Correct me if I was wrong.
Based on my knowledge, there is a Knowledge Base article describes how to
move a Reporting Services database from a computer that is running
Microsoft SQL Server Reporting Services to another computer.
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/kb/842425
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.