Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2014

Avoiding a split brain in database mirroring

You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means that the mirroring configuration includes having a witness server to ensure that the system can automatically switch over to the partner in the event of a failure of the principal. Read more

1 comments, 1,023 reads

Posted in A Discussion of SQL Server-Related Topics on 22 May 2014

Cannot start SSAS after install in tabular mode

After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error occurred:  A required privilege is not held by the client.” when trying to start the service.

Examining http://msdn.microsoft.com/en-us/library/ms175371.aspx shows that the only security privilege needed for the SSAS service account… Read more

4 comments, 773 reads

Posted in A Discussion of SQL Server-Related Topics on 13 May 2014