View Complete Post
I am trying to install SSRS 2008 on a clustered environment. I have found so many contradicting views on web regarding SSRS and clustering. My understanstanding on SSRS and SQL 2008 server cluster(2-node) is that :
1. SSRS2008 is not cluster aware.
2. We can cluster the Reporting Databases. We already have a SQL server 2008 clustering. I guess, we need to install Reporting Databases on both of them.
3. We can install report server on each node in the cluster but that will not be cluster aware(the fail over does not take place).
4. Is there any way we can install report server on a cluster? Right now, we are planning to have one Report server that runs on the sql cluster which has Report databases in it(this way Report databases are clustered). It would be nice if we could
have report server also clustered.
I would like to know when and if SQL Sever 2008 will support multisiteÃÂ clustering and how to achive this. I have already installed/tested the basic multisite clustering for static data but would like a more detailed document on the procedures. everything so far have been general high level with papers indicating it can be done but give no real direction on the configuration.
I am trying to do SSRS scale out deployment on our Cluster. I am confused in which way I should proceed, based on what I have read and done, i am having two ideas.
FYI:node1 and node 2 are clustered and node3 has SAN.The configuration is active-active configuration. The SQL server clustering works fine. Now, I have to add SSRS functionality to the cluster. SSRS is not cluster aware, so I have to do a
scale out deployment.
Here is my Plan A:
1.Install SSRS on both the nodes (node1, node2) and have them pointing to the same database or same report database instance. Have NLB on top of it. I guess NLB is built in feautre in microsoft Windows Server 2008 and it
Here is plan B:
2. have two more machines (node 4, node 5) and install report server on them pointing to the same Database on cluster.Have NLB on top off it.
Any help is greatly appreciated.
I want to implement a full redundant of SQL server for our client. My current topology is: 2 failover cluster of SQL server on 2 different physical servers, and 1 (HP 1000 series) with windows storage server 2008 connected to the SQL servers on SAN.
Now, i want to implement a full availability. I need to add another windows storage server 2008 (to prevent system down in case of crash of first windows storage). My question is, is this available and feasible? what are the requirements?? is there any scenario
on the internet that help in implementing such solutions? and is it solid infrastructure that could provide 99.9% ?
Your help is highly appreciated..
I am having problems with a user control. I want my solution to have a separate project for holding my user controls.
The main project can get a reference to this user control project and can import this user control dll into my main project.
Thanks in advance,
I'm getting th error "unable to connect to the asp.net development server 2008"
It's been working fine for months and all the sudden.I'm fairly new at this so if you have a fix I will need details.
My memory in task manager reaches about 900,000K and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.
is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem