Wednesday, March 28, 2012
Reporting Services 2005 on Vista
When I go to http://localhost/reports on my laptop running Vista and SQL
Server Reporting Services 2005 SP2 I recive the following error:
HTTP Error 401.1 - Unauthorized
Description: You do not have permission to view this directory or page using
the credentials that you supplied.
Does anyone know how to resolve this?
Thanks
- DavidNot sure if this is to do with you having to be logged in to the machine as
Admin or someone with admin rights.
"David" wrote:
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>|||I don't run Vista but here is a post I saved that might help you:
>>>>>
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:90D7717A-5883-4EB8-BFDF-A97EE9E5FE40@.microsoft.com...
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page
> using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>
Friday, March 23, 2012
Reporting Services 2000 & 2005 on same machine
both working on my development laptop ???
I have ASP.NET 1.1 and 2.0 installed on my laptop.
I have Visual Studio 2003 and 2005 installed on my laptop.
I have my default website configured for ASP.NET 2.0.
I have the developer edition of SQL Server 2000 installed on my laptop as
instance RMK006 in the MSSQL folder. I have the developer edition of SQL
Server installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.
I have the corresponding versions of SQL Server Reporting Services installed
on my laptop.
I have the Reports web site and the Reports web site and ReportServer web
site configured to ASP.NET 1.1
I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006
configured to ASP.NET 2.0
Entering http://localhost/reports$rmk0062005 in my web browser works fine.
Entering http://localhost/reportserver in my web browser generates the
following error:
Reporting Services Error
------------------------
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help
Bad Data.
------------------------
Microsoft Reporting Services
Entering http://localhost/Reports in my web browser generates the following
error:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help Bad Data.
The only way I can seem to get 2000 Reporting Services working is to do the
following:
- run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspn et_regiis.exe -u
- uninstall 2000 Reporting Services
- run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspne t_regiis.exe -i
- install 2000 Reporting Services
But once I've done that Visual Studio 2005 etc no longer work.
The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio
2005; the application is based on a SQL Server 2000 database and needs to
invoke SQL Server 2000 Reporting Services to run reports.
What am I doing wrong?
ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT IS
LOSING PATIENCE !!!!!Look at the options for aspnet_regiis; you want to run the 2.0 version
with -i to make it the default, then run the 1.1 version again but use
the command line options to change just the web folder for SQL 2000
Reporting Services.
rmk wrote:
Quote:
Originally Posted by
How can I get the 2000 and 2005 versions of SQL Server Reporting Services
both working on my development laptop ???
>
I have ASP.NET 1.1 and 2.0 installed on my laptop.
>
I have Visual Studio 2003 and 2005 installed on my laptop.
>
I have my default website configured for ASP.NET 2.0.
>
I have the developer edition of SQL Server 2000 installed on my laptop as
instance RMK006 in the MSSQL folder. I have the developer edition of SQL
Server installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.
I have the corresponding versions of SQL Server Reporting Services installed
on my laptop.
>
I have the Reports web site and the Reports web site and ReportServer web
site configured to ASP.NET 1.1
>
I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006
configured to ASP.NET 2.0
>
Entering http://localhost/reports$rmk0062005 in my web browser works fine.
>
Entering http://localhost/reportserver in my web browser generates the
following error:
Reporting Services Error
------------------------
>
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help
Bad Data.
>
------------------------
Microsoft Reporting Services
>
Entering http://localhost/Reports in my web browser generates the following
error:
>
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help Bad Data.
>
The only way I can seem to get 2000 Reporting Services working is to do the
following:
>
- run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspn et_regiis.exe -u
- uninstall 2000 Reporting Services
- run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspne t_regiis.exe -i
- install 2000 Reporting Services
>
But once I've done that Visual Studio 2005 etc no longer work.
>
The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio
2005; the application is based on a SQL Server 2000 database and needs to
invoke SQL Server 2000 Reporting Services to run reports.
>
What am I doing wrong?
>
ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT IS
LOSING PATIENCE !!!!!
Wednesday, March 21, 2012
Reporting Services - The underlying connection was closed: The remote name could not be re
Services to work on my laptop computer. I have gotten it to work in
office/development environments several times, so it's not just
beginner cluelessness.
Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000
Developer's Edition with SP 3a, ASP.NET 1.1, VS.NET 2003, not connected
to any network or even internet/wireless.
Installation ran fine, no error messages. Designer works fine, I can
select queries from my local NorthWind connecting as "sa". (I know
about not using sa, but this is for simplicity's sake)
Deploy seems to work fine. However, when I hit F5 (Play) or open IE
and navigate to localhost/Reports/Pages/Folder.aspx, I see this...
(X) Error
---
The underlying connection was closed: The remote name could not be
resolved.
Home
--
What can I do to fix this?
Thanks.
Jason
ps - localhost/reportserver?... works just fine. But the Report
Manager doesn't come up.First thing I would do is check my proxy settings in your browser. Ensure
you have selected to bypass the proxy for local request.
Next I would ensure that the machine name of your comptuer is the same as it
was when you intalled report server (the setup uses that value when forming
the URL).
Next, check that in the file rswebapplication.config under the report
manager install folder, you should find the entry reportserverurl. Ensure
the URL references your actual machinename.
If that fails, try to remove the reportserverurl element and replace it with
a reportservervirtualdirectory element and set the value to the path
"/reportserver". This should mean the report manager will look for the
report server on whatever path you access it on (e..g if you type
http://localhost/reports in the address bar, report manager will look at
http://localhost/reportserver to find the URL.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<jason_wisdom@.yahoo.com> wrote in message
news:1108157981.898349.110400@.l41g2000cwc.googlegroups.com...
> Hi, Help, I am having trouble getting SQL Server 2000 Reporting
> Services to work on my laptop computer. I have gotten it to work in
> office/development environments several times, so it's not just
> beginner cluelessness.
> Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000
> Developer's Edition with SP 3a, ASP.NET 1.1, VS.NET 2003, not connected
> to any network or even internet/wireless.
> Installation ran fine, no error messages. Designer works fine, I can
> select queries from my local NorthWind connecting as "sa". (I know
> about not using sa, but this is for simplicity's sake)
> Deploy seems to work fine. However, when I hit F5 (Play) or open IE
> and navigate to localhost/Reports/Pages/Folder.aspx, I see this...
>
> (X) Error
> ---
> The underlying connection was closed: The remote name could not be
> resolved.
> Home
> --
>
> What can I do to fix this?
> Thanks.
> Jason
> ps - localhost/reportserver?... works just fine. But the Report
> Manager doesn't come up.
>
Friday, March 9, 2012
Reporting service licensing question?
I have SQL server Dev edt. installed on my laptop and my company has SQL
server Ent. Edt. on our production server.
I recently downloaded the reporting services trail of 120 days from the site
of microsoft.
Anyway my question is if i install the trail reporting services on both my
laptop and maybe later the production server, will it stop functioning after
120 days?
TIA,
Martin.Yes, I would expect the trial edition to stop working after the trial
period.
If you have a licensed copy of Enterprise Edition you should contact
your supplier to get a copy of the Reporting Services CD. Once you
have that you shouldn't be time limited.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 12:35:34 -0300, "Martin" <jk123@.hotmail.com> wrote:
>Hi everyone,
>I have SQL server Dev edt. installed on my laptop and my company has SQL
>server Ent. Edt. on our production server.
>I recently downloaded the reporting services trail of 120 days from the site
>of microsoft.
>Anyway my question is if i install the trail reporting services on both my
>laptop and maybe later the production server, will it stop functioning after
>120 days?
>TIA,
>Martin.
>