Reporting Services and .NET can not co-exist?

Hi,
I had trouble getting reporting services going. I would
get the configuration error. If I restart the IIS Admin
the reporting services works fine but my other aspx pages
get the same configuration error. Something about
Microsoft.Office.Interop.Owc. If I restart IIS Admin
again the other aspx pages work but reporting services
does not.
What is going on here?
Can't Reporting Services and other .NET pages co-exist?
Please help.
-Marciaapplications can co-exist, but not in the same virtual folder.
maybe you can try to create a new application pool dedicated to reporting
services. (this is required when installing reporting services and
sharepoint on the same server)
I've already installed RS on some computer and I never get any error.
What is the content of your web.config files? (under the RS folders and un
der parent folder)
"Marcia Gorby" <anonymous@.discussions.microsoft.com> a écrit dans le message
de news:5ffc01c48174$eb0e7840$a401280a@.phx.gbl...
> Hi,
> I had trouble getting reporting services going. I would
> get the configuration error. If I restart the IIS Admin
> the reporting services works fine but my other aspx pages
> get the same configuration error. Something about
> Microsoft.Office.Interop.Owc. If I restart IIS Admin
> again the other aspx pages work but reporting services
> does not.
> What is going on here?
> Can't Reporting Services and other .NET pages co-exist?
> Please help.
> -Marcia

Reporting Services 2005 on a separate server

I recently installed an instance of SQL Server 2005 on a server that didn't have IIS. I received an error notification in the install logs that some components of SQL Server would not work. This lead me to wonder if Reporting Services 2005 truly can be installed on a separate server and run efficiently, so I pose the question to anyone out there who has had success doing so. Does IIS need to be installed on a server running an instance of SQL Server 2005 even if Reporting Services is not installed and is intended to be installed on a separate server? Any installation recommendations in installing RS 2005 on a separate server?Hi, some short answers, I hope they are suffiecient to your questions:

RS needs IIS to run. SQL Server 2005 does not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Reporting service Installation issues

Dear all,
i need some help with this problem: i'm trying to install Reporting Services
on a win2k IIS
server and when it asks me the istance of MSSQL i specify SQL login Account,
I insert the sa account with its password.
I received the following message:
"Login failed for user '(null)'. Reason: not associated with a trusted SQL
Server connection."
I tried to specify a domain account but the answer is "The domain account
that you specified cannot be validated".
I've tried to use a named pipes protocol but it no works.
thxI had the same problem on a machine in our testing environment. I'm not sure
why the credentials are not passed from the install GUI correctly. Perhaps
the credentials provided there are only used in the communication to the SQL
server after the install is complete? Anyway, what I did was pass the
correct credentials in the command line. I invoked the setup by running the
following command.
(in your install root)
setup /i "(install root)\setup\rsrun.msi" RSSETUPACCOUNT=accountname
RSSETUPPASSWORD=password
Hopefully that will work for you.
"andreab" wrote:
> Dear all,
> i need some help with this problem: i'm trying to install Reporting Services
> on a win2k IIS
> server and when it asks me the istance of MSSQL i specify SQL login Account,
> I insert the sa account with its password.
> I received the following message:
> "Login failed for user '(null)'. Reason: not associated with a trusted SQL
> Server connection."
> I tried to specify a domain account but the answer is "The domain account
> that you specified cannot be validated".
> I've tried to use a named pipes protocol but it no works.
> thx
>
>|||Nathan,
many thanks for your reply.
I've followed your instruction and it has worked.
Many thanks,
Andrea
"Nathan" <Nathan@.discussions.microsoft.com> wrote in message
news:C9BCC04A-6B0E-4FC1-B1B4-A2D6891A97D1@.microsoft.com...
> I had the same problem on a machine in our testing environment. I'm not
sure
> why the credentials are not passed from the install GUI correctly.
Perhaps
> the credentials provided there are only used in the communication to the
SQL
> server after the install is complete? Anyway, what I did was pass the
> correct credentials in the command line. I invoked the setup by running
the
> following command.
> (in your install root)
> setup /i "(install root)\setup\rsrun.msi" RSSETUPACCOUNT=accountname
> RSSETUPPASSWORD=password
> Hopefully that will work for you.
> "andreab" wrote:
> > Dear all,
> > i need some help with this problem: i'm trying to install Reporting
Services
> > on a win2k IIS
> > server and when it asks me the istance of MSSQL i specify SQL login
Account,
> > I insert the sa account with its password.
> > I received the following message:
> > "Login failed for user '(null)'. Reason: not associated with a trusted
SQL
> > Server connection."
> >
> > I tried to specify a domain account but the answer is "The domain
account
> > that you specified cannot be validated".
> > I've tried to use a named pipes protocol but it no works.
> >
> > thx
> >
> >
> >

Reporting Server on Window Server 2000, IIS 5.1

I have SQL server 2005 with reporting service on a machine with Windows 2000 with IIS 5.1. Now in the Reporting Services Manager I see a big X on Server Status, Web Service Identity and Initialisation.

In Server Status if I click on start I get the error: and if I click on it I get the message:
"The task failed:
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)"

If I click on Initialization I get:
"There was en error while switching panels. The most likely cause is an error retreiving WMI properties. The exception detailsare:
An error accured when attemting to connect to the report server remote ca (RCP) end point. Verify that the Report Server Windows service is running, and the retry the operation.
Details:
The RCP server is not listening (Exception from HRESULT: 0x800706B3)"

I went and look in the SQL Server Configuration Manager and I can see that the SQL Server Reporting Services is stoped and is set to start automatically. If I try to start it manually I get an error as well:
"The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details.

Now if I look in my Application log I see the following error:
"Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'SERVEUR\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) "

If one of you have ideas on what I have to do to make this work please let me know.

Thanks

Is there any other forums more specialize where I could ask this question?

Thanks

|||

Ok I think I got a solution. Wow you really have to know it because honestly the error messages provided by windows were not helping at all.

So anyway find the file rsreportserver.config and locate the line <WebServiceAccount></WebServiceAccount>
and replace it with
<WebServiceAccount>NT Authority\System</WebServiceAccount>
Save the file.
Go in the SQL Server Configuration Manager and start the SQL Server Reporting Services.
Now if you go in the Reporting Services Configuration Manager the Initialization should be green instead of a red X.|||

Hey Freedom, thanks for the post. It worked for me.

Reporting Server - Replication Topology

Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
works great. Our application runs on two IIS web servers and connects to the
SQL back end.
When people are running reports the SQL server can get taxed. What is the
best replication method where uses can connected to a different SQL server
and run reports on that server? The data has to be as current as possible.
Thanks!
Transactional replication.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
> Currentlly, we have 2 SQL 2000 Servers in a Win2003 Cluster. Everything
> works great. Our application runs on two IIS web servers and connects to
> the
> SQL back end.
> When people are running reports the SQL server can get taxed. What is the
> best replication method where uses can connected to a different SQL server
> and run reports on that server? The data has to be as current as possible.
> Thanks!
>
|||Hilary,
Where can I find a good "How To" to set this up properly? Is this fairly
easy? What do you have to watch for? I have setup log shipping before and
that is pretty simple. Thanks!
"Hilary Cotter" wrote:

> Transactional replication.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:32E4ED5A-7928-431B-9FC6-DA83610E7553@.microsoft.com...
>
>
|||On SQL Server 2000 I have used transactional replication and log shipping
for this - please see this article for the pros and cons of each approach:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Google around for transactional replication tutorials - or check out my
book. The best approach is to get your hands dirty right away and post back
here if you encounter problems.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:DB1C8113-C62C-41E4-8D85-390B8424EE3D@.microsoft.com...[vbcol=seagreen]
> Hilary,
> Where can I find a good "How To" to set this up properly? Is this fairly
> easy? What do you have to watch for? I have setup log shipping before and
> that is pretty simple. Thanks!
> "Hilary Cotter" wrote: