Reporting Services and an old sharepoint install

Hello,
I'm trying to install Reporting Service on a windows 2003 SP1 server
where a sharepoint had been uninstalled.
The install program still detect my old sharepoint installation.
i have checked the 2 documents from the support to remove manually
sharepoint, but the problem still occurs.
Please help. :'(
--
Ceci est une signature automatique de MesNews.
Site : http://mesnews.no-ip.comReporting services should still install. Is there a problem installing RS
other then the warning?
--
| Subject: Reporting Services and an old sharepoint install
| From: "Julien Dumetier" <julien.dumetier@.gmail.com>
| Message-ID: <mn.e39f7d54264629de.0@.gmail.com>
| Organization: DL Consultant
| X-Newsreader: MesNews/1.03.00.00
| Date: Thu, 28 Apr 2005 15:27:10 +0200
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"; format=flowed
| Content-Transfer-Encoding: 8bit
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 81.255.66.8
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42174
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello,
|
| I'm trying to install Reporting Service on a windows 2003 SP1 server
| where a sharepoint had been uninstalled.
| The install program still detect my old sharepoint installation.
|
| i have checked the 2 documents from the support to remove manually
| sharepoint, but the problem still occurs.
|
| Please help. :'(
|
| --
| Ceci est une signature automatique de MesNews.
| Site : http://mesnews.no-ip.com
|
||||> Reporting services should still install. Is there a problem installing RS
> other then the warning?
> --
The problem is at runtime, when i log in using the admin profile, if i
click on the button "New Folder" in the page
http://myserver/Reports/Pages/Folder.aspx, the page doesn't seem to
submit.
I've checked the report server log (using the verbose mode), and i
only have INFO level messages.
I can surf to "site parameters" or "Properties", but when i press an Ok
button nothing seems to occurs.
Tell me if you need more precisions.
--
Ceci est une signature automatique de MesNews.
Site : http://mesnews.no-ip.com|||Check out this web link. It might help you resolve your issues.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/h
tm/gs_installingrs_v1_9fdy.asp
--
| Subject: RE: Reporting Services and an old sharepoint install
| From: "Julien Dumetier" <julien.dumetier@.gmail.com>
| References: <mn.e39f7d54264629de.0@.gmail.com>
<Uv8OizATFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| Message-ID: <mn.ebb87d54847889f0.0@.gmail.com>
| Organization: DL Consultant
| X-Newsreader: MesNews/1.03.00.00
| Date: Fri, 29 Apr 2005 15:52:35 +0200
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"; format=flowed
| Content-Transfer-Encoding: 8bit
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 81.255.66.8
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42301
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| > Reporting services should still install. Is there a problem installing
RS
| > other then the warning?
| > --
|
| The problem is at runtime, when i log in using the admin profile, if i
| click on the button "New Folder" in the page
| http://myserver/Reports/Pages/Folder.aspx, the page doesn't seem to
| submit.
| I've checked the report server log (using the verbose mode), and i
| only have INFO level messages.
| I can surf to "site parameters" or "Properties", but when i press an Ok
| button nothing seems to occurs.
|
| Tell me if you need more precisions.
|
| --
| Ceci est une signature automatique de MesNews.
| Site : http://mesnews.no-ip.com
|
||||Brad Syputa - MS vient de nous annoncer :
> Check out this web link. It might help you resolve your issues.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/h
> tm/gs_installingrs_v1_9fdy.asp
> --
Unfortunatly, i don't have sharepoint installed on the server, it has
been uninstalled before the Reporting Service Install.
I don't have a SharePoint Web.config file, the only .config file i
have is web.config which is located at c:\Inetpub\wwwroot\wpresources
The config file looks like :
<configuration>
<system.web>
<customErrors mode="On" />
<httpHandlers>
<add verb="*" path="*.asax"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.ascx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.asmx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.aspx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.ashx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httpHandlers>
</system.web>
</configuration>
If i might add :
<HttpModules>
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and
<pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
Where should i write them ?
Second solution :
How the install program detect my old sharepoint install ? Maybe if we
could make the installation of Reporting Service (RS ) unable to detect
the old sharepoint install, i could try another uninstall-install of
RS.

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>sql

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?
Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>

Reporting Services 2005 on Windows 2000 SP4 Domain Controller

Hi all,

I'm experiencing a problem with Reporting Services 2005 running on a Windows 2000 AD Domain Controller.

Installation has been done correctly, SQL 2005 and SSRS 2005 are running correctly (I've followed Microsoft KB911846 to solve the "not dtarting after installation" problem).

Accessing reports virtual folder (http://machinename/reports) from localhost, logged on with user Administrator Report Builder option displays correctly. Also accessing from LAN, but with user Administrator, displys Report Builder Option.

Report Builder button is not displayed with other users (i.e. user Dave)

I've given user Dave same permission as Administrator (Content Manager, in SSRS) but Report Buildr still can't be viewed.

If it can be userful to understand this strange behaviour, looking in "Reporting Services Configuration" tool I can see that Web Service Identity is reported as Not configured, with a beautiful red X besides.

Can someone please help me?

Thank you very much for any suggestion.

Regards,

Dave

Solved! :-)

Just had to set domain users as "System Users" in Report Server Management

Dave

Reporting Services 2005 on Windows 2000 server

Hi,

I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>\ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>.

Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting?

Thanks

Could you please post the whole error message ?|||

I have the same problem too...

I can't change the value of ASP .NET Service Account in the text box and when I try to apply what is proposed (MACHINENAME\ASPNET - that don't exists), I receive the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

I hope in a solution ....

|||

Hi Matteo and rodgerst,

Could you, please, connect to your Report Server instance using the config tool, choose Report Server and Report Manager virtual directories tabs, check Apply Default Settings, and then press Apply?

If the previous workaround was not working, could you, please, go to this registry key corresponding to the RS instance:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.x\Setup

and look for this key: ReportManagerIdentityConfigured. Please change its value to what you want to have for your web service identity (the IWAM user).

I hope it helps. Please let me know how this is working for you.

Mihaela

|||

Hi Mihaela

I've tried the first workaround, close and open RS Config Manager but ....nothing: a red X on web service identity and a locked textbox with the same wrong value.

The value specified in the second workaround don't exists in the registry key, and in entire registry... I've tried to create it, close and reopen Config Manager but .... nothing ....

If can be useful at this link i've saved a screenshot of registry

http://www.matteodistefano.it/public/registrySS.gif

Thanks in advance

Matteo

|||

Matteo,

I see from your screenshot that you have SQL Express Advanced SP1 installed on the Windows 2000 machine, which is your Reporting Services server. I would suggest to try to install SP2 and see if this is working.

Thank you,

Mihaela

|||

Hi Mihaela

Thanks for your answer,

For the moment I can't access directly to it, so I won't risk to install a service pack remotely on a production server.

I'll do it after 6 weeks.

Any other suggestions are appreciate.

Thanks

|||

Tried applying default settings; did not help. Tried regedit; ReportManagerIdentityConfigured is not a key in either MSSQL.1 or MSSQL.2. Should I try adding it to MSSQL.2\Setup?

|||My registry looks like Matteo's snapshot except we are running the Enterprise Evaluation Edition.

Reporting Services 2005 on Windows 2000 server

Hi,

I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>\ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>.

Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting?

Thanks

Could you please post the whole error message ?|||

I have the same problem too...

I can't change the value of ASP .NET Service Account in the text box and when I try to apply what is proposed (MACHINENAME\ASPNET - that don't exists), I receive the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

I hope in a solution ....

|||

Hi Matteo and rodgerst,

Could you, please, connect to your Report Server instance using the config tool, choose Report Server and Report Manager virtual directories tabs, check Apply Default Settings, and then press Apply?

If the previous workaround was not working, could you, please, go to this registry key corresponding to the RS instance:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.x\Setup

and look for this key: ReportManagerIdentityConfigured. Please change its value to what you want to have for your web service identity (the IWAM user).

I hope it helps. Please let me know how this is working for you.

Mihaela

|||

Hi Mihaela

I've tried the first workaround, close and open RS Config Manager but ....nothing: a red X on web service identity and a locked textbox with the same wrong value.

The value specified in the second workaround don't exists in the registry key, and in entire registry... I've tried to create it, close and reopen Config Manager but .... nothing ....

If can be useful at this link i've saved a screenshot of registry

http://www.matteodistefano.it/public/registrySS.gif

Thanks in advance

Matteo

|||

Matteo,

I see from your screenshot that you have SQL Express Advanced SP1 installed on the Windows 2000 machine, which is your Reporting Services server. I would suggest to try to install SP2 and see if this is working.

Thank you,

Mihaela

|||

Hi Mihaela

Thanks for your answer,

For the moment I can't access directly to it, so I won't risk to install a service pack remotely on a production server.

I'll do it after 6 weeks.

Any other suggestions are appreciate.

Thanks

|||

Tried applying default settings; did not help. Tried regedit; ReportManagerIdentityConfigured is not a key in either MSSQL.1 or MSSQL.2. Should I try adding it to MSSQL.2\Setup?

|||My registry looks like Matteo's snapshot except we are running the Enterprise Evaluation Edition.sql

Reporting Services 2005 Error Creating Report Server Virtual Directory

Hi all,
I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
installed SQL 2005 Reporting Services. However when I got to configure
the reporting services the following happens
When creating a new report server virtual directory on our server, (I
am installing to the default web site and the default virtual directory
name 'ReportServer'.)
1) It creates the virtual directory and says The virtual directory was
created and assigned
2) this is followed by a green tick next to 'Change Secure Connection
Level'
3) This is immediatly followed by a message coming up stating
'ReportServicesConfigUI has encountered a problem and needs to close.
We are sorry for the inconvenience.'.
I cant help feeling that it hasnt finished this correctly as the
'Report Manager Virtual Directory' section is still greyed out and I
cannot enter it.
Any help would be greatly appreciated.
TomHi,
This sounds like a permission error. In addition, what version of Windows
2003 are you running?
Have you checked the Event Log? If so, what other possible errors do you see?
Thanks,
Phillip
"tom@.isolditonline.co.uk" wrote:
> Hi all,
> I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
> installed SQL 2005 Reporting Services. However when I got to configure
> the reporting services the following happens
> When creating a new report server virtual directory on our server, (I
> am installing to the default web site and the default virtual directory
> name 'ReportServer'.)
> 1) It creates the virtual directory and says The virtual directory was
> created and assigned
> 2) this is followed by a green tick next to 'Change Secure Connection
> Level'
> 3) This is immediatly followed by a message coming up stating
> 'ReportServicesConfigUI has encountered a problem and needs to close.
> We are sorry for the inconvenience.'.
> I cant help feeling that it hasnt finished this correctly as the
> 'Report Manager Virtual Directory' section is still greyed out and I
> cannot enter it.
> Any help would be greatly appreciated.
> Tom
>|||If I use IE 6 I have no problems. I can access and view parts of the date
with IE7, but the controls do not come up in the reports.
"Phillip MacPherson-Cox" <PhillipMacPhersonCox@.discussions.microsoft.com>
wrote in message news:1FD05115-7F89-470F-AF3E-4866154C7B53@.microsoft.com...
> Hi,
> This sounds like a permission error. In addition, what version of Windows
> 2003 are you running?
> Have you checked the Event Log? If so, what other possible errors do you
see?
> Thanks,
> Phillip
> "tom@.isolditonline.co.uk" wrote:
> > Hi all,
> >
> > I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
> > installed SQL 2005 Reporting Services. However when I got to configure
> > the reporting services the following happens
> >
> > When creating a new report server virtual directory on our server, (I
> > am installing to the default web site and the default virtual directory
> > name 'ReportServer'.)
> >
> > 1) It creates the virtual directory and says The virtual directory was
> > created and assigned
> > 2) this is followed by a green tick next to 'Change Secure Connection
> > Level'
> > 3) This is immediatly followed by a message coming up stating
> > 'ReportServicesConfigUI has encountered a problem and needs to close.
> > We are sorry for the inconvenience.'.
> >
> > I cant help feeling that it hasnt finished this correctly as the
> > 'Report Manager Virtual Directory' section is still greyed out and I
> > cannot enter it.
> >
> > Any help would be greatly appreciated.
> > Tom
> >
> >|||In the Event Log, I just get the following:
Source - NET Runtime 2.0 Error Reporting
Event ID - 5000
EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.242.0, P3 443f597d, P4
rsconfigtool, P5 9.0.242.0, P6 443f597d, P7 154, P8 5, P9
system.nullreferenceexception, P10 NIL.
I am running on the local machine as an administrator.
The Windows 2003 Edition is Standard Edition.
Tom|||A uninstall of reporting services and re-install did the trick.
Tom
tom@.isolditonline.co.uk wrote:
> In the Event Log, I just get the following:
> Source - NET Runtime 2.0 Error Reporting
> Event ID - 5000
> EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.242.0, P3 443f597d, P4
> rsconfigtool, P5 9.0.242.0, P6 443f597d, P7 154, P8 5, P9
> system.nullreferenceexception, P10 NIL.
> I am running on the local machine as an administrator.
> The Windows 2003 Edition is Standard Edition.
> Tom

Reporting services 2005 crashes

Hi All ,
I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
enterprise edition 64 bit machine.
I created a project and using a wizard created a report with Analysis
services cube as a datasource.Preview works fine but when I try to fix the
fonts or add elements and try to save it it crashes.How ever with out saving
I build the report or use the debug it works fine for the first time the next
time all the columns are deleted from the dataset.
I reproduced this problem thrice using diffrent prifile logons and creating
the project in different drives.
Thank you .
Rose.Applied Service pack noweverything seems good.
"Rose" wrote:
> Hi All ,
> I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
> enterprise edition 64 bit machine.
> I created a project and using a wizard created a report with Analysis
> services cube as a datasource.Preview works fine but when I try to fix the
> fonts or add elements and try to save it it crashes.How ever with out saving
> I build the report or use the debug it works fine for the first time the next
> time all the columns are deleted from the dataset.
> I reproduced this problem thrice using diffrent prifile logons and creating
> the project in different drives.
>
> Thank you .
> Rose.

Reporting Services 2005 and Windows Sharepoint Services

Hi,

I have a small dilemma; is it possible to install WSS on the same server as SQL Server 2005?

We building a portal using SQL Server / RS 2005 and the idea is to use WSS as the base. The problem is that WSS uses .NET 1.0 and SQL 2005 uses .NET 2.0. And they doesn't seem to work together.

Is there a workaround, I have searched the net and there are people saying they are running this configuration but havn't been able to find out how to accomplish it.

Anyone who has done this?There is a section in the SQL 2005 online docs about getting this to work. Basically, you need to create a seperate app pool run run RS as well as exclude the /reports and /reportserver paths in the SharePoint admin.
In the RTM build of SQL 2005, this configuration will work "out of the box".

Reporting services 2005

Hello,

I installed SQL Server 2005 into a Windows 2005 Pro machine, I have following question:

1. will I be able to use Reporting services to deploy the reports to the same machine as a report server?

2. Can I modify and deploy mo old reports written in RS2000

3. Is there any web site that show step by step how I can work with RS2005?

Thanks,

for the first question, of course, you can
for the third question, you can view the tutorial on reporting servicein sqlserver2005 help, first you should install both 'adventurework'database and 'adventureworkdw'database which are used in the tutorial.The install manual is also in sqlserver2005 help

Reporting Services + Vista Home Premium = @!!$#%*

I am just wondering....

Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!

I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.

In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...

What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...

What edition of SQL 2005 do you have? Enterprise, Standard and Workgroup edition are not supported on

Windows Vista Home Premium Edition.

If you have a version other than those, what error messages are you getting?

|||

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

|||

ansonee wrote:

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

No, not on Vista Home Premium Edition. See this link: http://technet.microsoft.com/en-us/library/ms143506.aspx

|||Under SQL Server Business Intelligence Development Studio you will be able to develop reports. IIS must be installed with a specific set of features enabled. Home does not support one of the required authentication features. I am in the same boat. I too am not happy with Vista and Microsoft. We need the non-home edition of Vista.|||

A little clarification on my account ...

Reporting Service; the service side of it, requires hosting via IIS. One can run the RDL's in preview mode in the VS designer. A limited option is to use the 'local' (versus server) option in the report viewer controls.

The service part of Reporting Service in the 2008 release will be able to be hosted in something other than IIS. I would assume because it has been redone using WCF. What the hosting options are I do not know. So, one solution for both of us might be installing 2008 beta version.

|||

Hey there!

Nope, Reporting Services will not install /run in Home versions of Vista. You'll need

the business version or some other higher end version of it. In other words..more

$$$, that in MHO is MS's thinking. I wish you luck, you're on the right track with an XP

install.

Best,

>Scott

Reporting Services + Vista Home Premium = @!!$#%*

I am just wondering....

Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!

I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.

In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...

What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...

What edition of SQL 2005 do you have? Enterprise, Standard and Workgroup edition are not supported on

Windows Vista Home Premium Edition.

If you have a version other than those, what error messages are you getting?

|||

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

|||

ansonee wrote:

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

No, not on Vista Home Premium Edition. See this link: http://technet.microsoft.com/en-us/library/ms143506.aspx

|||Under SQL Server Business Intelligence Development Studio you will be able to develop reports. IIS must be installed with a specific set of features enabled. Home does not support one of the required authentication features. I am in the same boat. I too am not happy with Vista and Microsoft. We need the non-home edition of Vista.|||

A little clarification on my account ...

Reporting Service; the service side of it, requires hosting via IIS. One can run the RDL's in preview mode in the VS designer. A limited option is to use the 'local' (versus server) option in the report viewer controls.

The service part of Reporting Service in the 2008 release will be able to be hosted in something other than IIS. I would assume because it has been redone using WCF. What the hosting options are I do not know. So, one solution for both of us might be installing 2008 beta version.

|||

Hey there!

Nope, Reporting Services will not install /run in Home versions of Vista. You'll need

the business version or some other higher end version of it. In other words..more

$$$, that in MHO is MS's thinking. I wish you luck, you're on the right track with an XP

install.

Best,

>Scott

Reporting Services + Vista Home Premium = @!!$#%*

I am just wondering....

Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!

I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.

In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...

What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...

What edition of SQL 2005 do you have? Enterprise, Standard and Workgroup edition are not supported on

Windows Vista Home Premium Edition.

If you have a version other than those, what error messages are you getting?

|||

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

|||

ansonee wrote:

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

No, not on Vista Home Premium Edition. See this link: http://technet.microsoft.com/en-us/library/ms143506.aspx

|||Under SQL Server Business Intelligence Development Studio you will be able to develop reports. IIS must be installed with a specific set of features enabled. Home does not support one of the required authentication features. I am in the same boat. I too am not happy with Vista and Microsoft. We need the non-home edition of Vista.|||

A little clarification on my account ...

Reporting Service; the service side of it, requires hosting via IIS. One can run the RDL's in preview mode in the VS designer. A limited option is to use the 'local' (versus server) option in the report viewer controls.

The service part of Reporting Service in the 2008 release will be able to be hosted in something other than IIS. I would assume because it has been redone using WCF. What the hosting options are I do not know. So, one solution for both of us might be installing 2008 beta version.

|||

Hey there!

Nope, Reporting Services will not install /run in Home versions of Vista. You'll need

the business version or some other higher end version of it. In other words..more

$$$, that in MHO is MS's thinking. I wish you luck, you're on the right track with an XP

install.

Best,

>Scott

Reporting Services - credentials error.

Hi everyone.

I have created a report in RS and it works fine (am invoking from VB.Net - windows forms).

However, I have copied the report into a new one as I need a very similar looking report to be called from the same application, but if I attempt to invoke it in the same way as the first I get the following error:

"An attempt was made to set credentials for a data source '<name>' associated with thre report. Report data source settings are specified in a way that prevens credentials from being submitted to the report server."

I am passing the credentials like so:

Dim cc As New DataSourceCredentials
Dim cred() As DataSourceCredentials = {cc}

cred(0).Password = "*****"
cred(0).UserName = "****"
cred(0).DataSourceName = "**DSNAME**"

Any help would be gratfully recieved, as this is driving me completely nuts.

Thanks in advance.Anyone? Someone must have come across this before.

I am slowly banging my head against a wall here ;-)

Reporting Services

I was trying to install Reporting Services on Windows Server 2003. but
it seems to need Visual Studio .Net 2003 installed.

I just can't download .Net 2003 anywhere.is it any different than
Visual Studio .net?

is there another way to install Reporting Services for SQL Server 2000.

we cannot get Sql Server 2005 coz we have Great Plains 7.0 running on
our server and that 2005 is not supported yet(I would think)

thank you.You can install it without Visual Studio, you only need Visual Studio
if you want to author reports.|||oh really?

I thought you need Visual Studio .Net 2003 for the Report Designer
feature.

thanks.

WS

Reporting Service Problem

Hi Billy,
I have received the same error when installing the production version of rep
orting services onto Windows 2000 Server.
I tryed setting DTC to manual and then re-installing but still received the
same error message.
Do you have any other ideas?Hello,
Thank you for your posting in the community!
Based on the description, the issue is related to the installation of the Re
porting Service.If
you would, please post this question in the <microsoft.beta.reporting.servic
es.general>
newsgroup.
The reporting services newsgroup is primarily for issues involving the insta
lling problem of
Reporting Service. The reason why we recommend posting appropriately is you
will get
the most qualified pool of respondents, and other partners who read the news
groups
regularly can either share their knowledge or learn from your interaction wi
th us.
Thanks and have a good day!
Best regards,
Billy Yao
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Reporting Service Performance

I have developed a Windows Forms Control that renders ReportingService reports as a metafile, This way the reports can be shown on as 'Crystal Reports' does in the wysiwyg way. But when the reports contain some hundered pages (and that happens often) the rendering of one page takes up to 3 seconds. The reason for this is not the SQL statement (it is a simple listing of 15000 records in one table). Is there a way to speed this up without using caches or snapshots? The Controls main feature must be that it can easily show and print reports.
The Control is based on the following code: http://blogs.msdn.com/bryanke/articles/71491.aspxThe image rendering extension was not really designed to be used this way
and is known to have issues with large reports. Bryan's code is a interim
approach until we have the supported set of report controls available in VS
Whidbey.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dasirr" <Dasirr@.discussions.microsoft.com> wrote in message
news:0BE027EA-51C5-4B4E-BC32-2CC51EE01E0C@.microsoft.com...
>I have developed a Windows Forms Control that renders ReportingService
>reports as a metafile, This way the reports can be shown on as 'Crystal
>Reports' does in the wysiwyg way. But when the reports contain some
>hundered pages (and that happens often) the rendering of one page takes up
>to 3 seconds. The reason for this is not the SQL statement (it is a simple
>listing of 15000 records in one table). Is there a way to speed this up
>without using caches or snapshots? The Controls main feature must be that
>it can easily show and print reports.
> The Control is based on the following code:
> http://blogs.msdn.com/bryanke/articles/71491.aspx

reporting service install help files only

Hi,
I am trying to install reporting services on windows 2003 server, everytime
it only installs help files. there are no virtual directories and nothing in
IIS at all.
there is no log file, no error messages...install runs ithout even
prompting for the settings such as sql server etc....install just runs and
after few minutes says it is finished.
what can be causing this.
thanks
K DhariwalI had this problem some months ago, when someone only installed Books
Online and not the whole Reporting Services 2000 package as planned. In
the end, I had to uninstall everything, reboot the server, and then
start the installation again.
If you're installing Reporting Services 2000 version:
Start your Reporting Services installation setup. When you're asked if
you want to repair/modify or uninstall, choose uninstall. This should
clean up most of it. Boot and start setup. See if there's anything
missing. If IIS (Internet Information Services) or .NET framework is
missing, you need to install these first, before continuing with the
installation. IIS can be installed by opening "Add/remove programs",
click on "Add/remove Windows Components" and adding it from the
Application Server menu.
Read more at http://support.microsoft.com/kb/324742/en-us
If the installation wizard says that Visual Studio is missing, you can
continue, if you're installing this on a server not used for developing
reports.
This should send you on the right track to install Reporting Services
properly.
Kaisa M. Lindahl|||Hello,
I ran the install file to remove sql reporting services. funny enough
install setup ran and tried to install reporting services and at the end it
says installation successful. then i removed it from add/remove programs and
rebooted the server. made sure all required components are there. install
reporting services, same issue. no prompts for sql server specification
server componenets etc.
i have done quite a few installations of sql reporting services and never
had funny program like this. worst part is that it is not even producing
error message. there is no log file to look at. only thing which is there is
the help file [bunch of html files etc.]
thanks in advance
k dhariwal
"Kaisa M. Lindahl" wrote:
> I had this problem some months ago, when someone only installed Books
> Online and not the whole Reporting Services 2000 package as planned. In
> the end, I had to uninstall everything, reboot the server, and then
> start the installation again.
> If you're installing Reporting Services 2000 version:
> Start your Reporting Services installation setup. When you're asked if
> you want to repair/modify or uninstall, choose uninstall. This should
> clean up most of it. Boot and start setup. See if there's anything
> missing. If IIS (Internet Information Services) or .NET framework is
> missing, you need to install these first, before continuing with the
> installation. IIS can be installed by opening "Add/remove programs",
> click on "Add/remove Windows Components" and adding it from the
> Application Server menu.
> Read more at http://support.microsoft.com/kb/324742/en-us
> If the installation wizard says that Visual Studio is missing, you can
> continue, if you're installing this on a server not used for developing
> reports.
> This should send you on the right track to install Reporting Services
> properly.
> Kaisa M. Lindahl
>|||Hello,
I'm with same problem, you can help-me?
Clayton Cardozo
"K M Dhariwal" wrote:
> Hello,
> I ran the install file to remove sql reporting services. funny enough
> install setup ran and tried to install reporting services and at the end it
> says installation successful. then i removed it from add/remove programs and
> rebooted the server. made sure all required components are there. install
> reporting services, same issue. no prompts for sql server specification
> server componenets etc.
> i have done quite a few installations of sql reporting services and never
> had funny program like this. worst part is that it is not even producing
> error message. there is no log file to look at. only thing which is there is
> the help file [bunch of html files etc.]
> thanks in advance
> k dhariwal
> "Kaisa M. Lindahl" wrote:
> > I had this problem some months ago, when someone only installed Books
> > Online and not the whole Reporting Services 2000 package as planned. In
> > the end, I had to uninstall everything, reboot the server, and then
> > start the installation again.
> >
> > If you're installing Reporting Services 2000 version:
> > Start your Reporting Services installation setup. When you're asked if
> > you want to repair/modify or uninstall, choose uninstall. This should
> > clean up most of it. Boot and start setup. See if there's anything
> > missing. If IIS (Internet Information Services) or .NET framework is
> > missing, you need to install these first, before continuing with the
> > installation. IIS can be installed by opening "Add/remove programs",
> > click on "Add/remove Windows Components" and adding it from the
> > Application Server menu.
> > Read more at http://support.microsoft.com/kb/324742/en-us
> >
> > If the installation wizard says that Visual Studio is missing, you can
> > continue, if you're installing this on a server not used for developing
> > reports.
> >
> > This should send you on the right track to install Reporting Services
> > properly.
> >
> > Kaisa M. Lindahl
> >
> >

Reporting service 400 bad request error

I have my reporting services installed on a Windows 2003 server. I have my Http://localhost/RepsortServer file directory opens fine.

However, I get this error when I try to access http://localhost/Reports.

Error

The request failed with HTTP status 400: Bad Request. Home

HELP

Any red X shows up when you open the configuration tool? Do you reportserver and reports vdirs live in the same application pool?

Try to recreate the report manager virtual directory using the configuration tool.