3

Provision Subscriptions and Alerts - SQL Server Reporting Service with SQL AlwaysOn Cluster

view full story
linux-howto

http://serverfault.com – I have an SQL 2012 AlwaysOn Cluster and need to setup SharePoint reporting services. Within SharePoint farm configuration it reports that the SQL server agent is not running. Since I have multiple SQL nodes to which the connection can fail over to any, how do I handle the SQL server agent or is this clustered also? Does the downloadable SharePoint reporting SQL script need to be ran on each node? Finally, how does SharePoint switch to a different SQL Server agent if a node in the cluster goes down? (HowTos)

xskl's picture
Submitted by xskl on 08/02/2012 – Made popular on 08/02/2012

Stories similar to Provision Subscriptions and Alerts - SQL Server Reporting Service with SQL AlwaysOn Cluster

I'm in the process of configuring a sort-of Beowulf cluster, the major difference being that I want to be able to add nodes from any network. Because of this I can't run DHCP on the server to inventory all the nodes.

New nodes would run a package or script to configure SSH, MPI, NFS and the like. During installation they'll require the IP address of the server.

I have SharePoint 2007. When the database backups run using SQLCMD SharePoint sites go into read-only. Users can't add anything to the sites the buttons are grayed out. On the backend the databases do not get set to read-only. My question is this, is this normal with SharePoint? I have read some forums that say SharePoint does this by default but the information is a little murky.

Thanks

Bryan

Sharepoint Reports on Mac 1 year 16 weeks ago

When trying to view Sharepoint Reports, Mac users get the error "An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

We tried both Safari and Firefox, and get the same error. On the Firefox end, I tried enabling NTLM Authentication, but that did not work. Can Sharepoint reports work on Mac?

My company isn't ready to migrate SP2007 to SP2010 yet (don't ask). But we need to get Office Web Apps working for some users. Is this at all possible without migrating the whole farm? e.g. can an SP2010 server share the database of the SP2007 farm?

We don't need all SharePoint functionality, just Office Web Apps.

I'm having trouble trying to do a simple backup of our 2-server SharePoint 2010 farm. I'm running the backup process with a Powershell command, backing up to a UNC shared folder on the SharePoint server.

I have SP2010 on one server and SQL 2012 on another. SQLserver.exe is being run by a new Managed Service Account.

I am installing SharePoint Server 2013 on Windows Server 2008 R2 SP1 with SQL 2012 on a VMware. During the SharePoint Configuration Wizard, I need to provide a DB access account.

The VM is not part of a domain as well.

I tried VMname\Admin & password it didn't work. Giving the message that the local admin can't be used.

I need some help regarding this problem please.

I am trying to setup an active/passive (2 nodes) Linux-HA cluster with corosync and pacemaker to hold a PostgreSQL-Database up and running. It works via DRBD and a service-ip. If node1 fails, node2 should take over. The same if PG runs on node2 and it fails.

The Install Microsoft SharePoint Server 2010 and Microsoft SQL Server 2008 (FAST Search Server 2010 for SharePoint) TechNet article states:

Do not install SharePoint Server 2010 and FAST Search Server 2010 for SharePoint on the same server.

But it doesn't say why? Why should the two not be on the same machine?

Hi experts, I have some custom application which I need to make Highly Available using red hat cluster service. How do I do it? i know in /usr/share/cluster i shall find HA agents for well known services like Apache or Sybase but I want to write HA agent for my own. I tried looking up on internet, and red hat documentation but couldn't find any systematic resource for the same.