Active\Active Shared Database.

Thanks shea. The shared disk will not be accessed by more than one node. Each node will have its own shared bay and database. But the data will be federated\partitioned across the databases on both instances horizontally. Using DP Views the application ac
cess the data required. This is my thought and not sure whether practically possible or not. This way we can use the resources of both the nodes (scale out). When a failover happens, a single node will share the load which is obvious in case of Oracle's R
eal Application Cluster also.
Marx.
You can create 2 SQL Instances. Each partitioned table will reside in a database in each SQL Instance. The distributed view will read/write data to the correct SQL Instance. If SQLInstance1 is on Node1 and SQLInstance2 is on Node2 you will achieve a de
gree of load balancing via the distributed views. However, if Node1 fails SQLInstance1 will failover to Node2 and you will now have degraded performance. If you wish to maintain this high availability AND high performance scenario then you need 2 x 2-no
de clusters. Then if any node fails in either cluster you will maintain the same level of performance even though you now have a reduced level of redundancy. Of course this solution costs a whole lot more...
When ever you design a clustered solution you need to ask your clients if they are prepared to take a reduced level of service (in this case performance) when you loose some of your redundancy (due to a hardware or software failure).
|||That will work. Managing the DPV is challenging to say the least, but it is
possible.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Accessing Reports through a web application?

Hi All,

I have developed few reports in SQL Server 2005 Reporting Services and deployed them on a reporting server.

These reports are accessed through a web application that is deployed on a different server. I am using the Report Viewer control in my web application.

The problem is when I access the reports through my web application, it gives me a Page not found error.

If I have both web server and reporting server on the same machine, then this problem does not come.

I need to have separate web and reporting server. Can anyone please provide help on how to solve this authentication issue. My web application is taking the credentials but the credentials are not getting passed if the reports are deployed on a different server.

Any help will be greatly appreciated!!!

Has anyone tried this before?

Regards!!!

accessing remote sql server 2000 ( enterprise manager like tool)

Hi all,

I need to gain access to a remote SQL Server 2000 storing my data.
The remote SQL machine can only be accessed via an internet connection,
that is - it is not part of my network.

I know Enterprise Manager can do the job, but EM only comes bundled in
MS SQL Server, which is not installed on the client machine.

Please let me know which other (preferably free) tools can perform
such remote access.

Thanks,
Gilad HaimovOn 25 Oct 2003 03:36:11 -0700, giladha@.hotmail.com (gilad) wrote:

>Hi all,
>I need to gain access to a remote SQL Server 2000 storing my data.
>The remote SQL machine can only be accessed via an internet connection,
>that is - it is not part of my network.
>I know Enterprise Manager can do the job, but EM only comes bundled in
>MS SQL Server, which is not installed on the client machine.
>Please let me know which other (preferably free) tools can perform
>such remote access.
>Thanks,
>Gilad Haimov
In theory anything that can attach to a database, VB MS-Access Fxopro
etc etc. More of a problem would be is the database directly
accessible from the internet at all? I would have thought this was a
very bad idea.