Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server Cluster: There was an error setting private property 'RequireKerberos' to value '1' for resource 'SQL Network Name'. Error: Value does not fall within the expected range

For a minute I thought the error is related to network as it refers 'RequireKerberos' and 'SQL Network name', on top of that this is a SQL Server 2008 Failover clustering environment. Both of these terms are registry based values that...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Dec 16 2010
Filed under: Filed under: sql server, kba, best practices, cluster, installation, instances, kerberos, slipstream, merge drop, network name, failover clustering
SQL Server 2005 and Windows Server 2008 - Failover clustering problems

Scenario: SQL Server 2005 and Windows 2008 X64 EE. Multiple errors after installing SQL Server as failover cluster, so here are the few gotchas on how to avoid them in your case. Failover Clustering - the first checkpoint I always look out is to ensure...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 18 2010
Filed under: Filed under: sql server, windows, cluster, installation, service pack, failover, setup, resource group
SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.

At the first instance the error is clear that some problem with SQL resource that was allocated to the Cluster resource. Just a background on SQL Server Failover Clustering, that the server cluster consists of a failover cluster instance that runs under...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 17 2010
Filed under: Filed under: sql server, kba, cluster, failover, filestream, SQL Server 2008
Обновите свои новостные каналы лентами из SQL Server BLOGROLL 2010

Продолжаю традицию в начале года верстать очередной BlogROLL . За основу этого списка новостных лент берётся мой актуализированный OPML , т.е. счастливым обладателям IE7 и выше достаточно просто импортировать его каналы. Как это сделать уже было подробно и наглядно описано в моём блоге. Тех же, кто предпочитает...

Posted to Alexander Gladchenko by gladchenko on Tue, Feb 2 2010
Filed under: Filed under: SQL Server, PowerShell, MSMQ, Tips for DBA, Cluster, Troubleshooting
SQL Server BLOGROLL 2010

Analysis Services/BI AdamJorgensen: Most Recent blogs An Uncommon Approach: Business Intelligence Andrew Calvett Andrew Fryer's Blog Arcane Code » SQL Server BIpartisan biresort.net Blog Colin White Boyan Penev on Microsoft BI Business Intelligence...

Posted to Alexander Gladchenko by gladchenko on Tue, Feb 2 2010
Filed under: Filed under: SQL Server, PowerShell, MSMQ, Tips for DBA, Cluster, Troubleshooting
SQL Server 2008 installation issues: Access is denied

In general the installation of SQL Server is straight forward and should not be a problem unless the server is not under hardware/software configuration link here. As SQL Server 2008 version is designed secured by default and part of security measures...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 14 2009
Filed under: Filed under: sql server, security, upgrade, cluster, installation, privileges, service account, setup, operating system
The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)

The above error clearly specifies the connectivity issues between 2 instance, to give more information I have been dealing with this problem at a client's place. The setup that was configured and deployed was a very complicated replication between...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 11 2009
Filed under: Filed under: sql server, services, replication, error, cluster, msdtc, distributor, subscriptions, linked server, error 7391
SQL Server 2008 Cluster environment based KBAs

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications How to change SQL Server parameters in a clustered environment when SQL Server is not online...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Nov 4 2008
Filed under: Filed under: sql server, error, cluster, environment, parameter, failover
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 8 2008
Filed under: Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability
Как включить SQL Server 2005 в кластер

По материалам статьи Рандай Диесс (Randy Dyess): How to Guide: SQL Server 2005 Clustering Введение Этот документ, опубликованный в журнале «SQL Server Magazine», предназначен для технических специалистов, которые хотят разобраться с тем, как работает отказоустойчивый кластер, как SQL Server...

Posted to Alexander Gladchenko by gladchenko on Thu, May 1 2008
Filed under: Filed under: SQL Server, Cluster
SQL Server Clustering get pre-installation information and choose the best practices for your environment

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Mar 27 2008
Filed under: Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist
Get SQL Server Clustering information with DMVs and SELECT statements

Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 11 2008
Filed under: Filed under: sql server, dmv, best practices, cluster, clustering, select, virtual server, nodes, shared drives, serverproperty
Error - There is not enough disk space on the destination disk, during a SQL Server failover cluster installation

Had an interesting problem on one of the SANs that will be used to setup a failover clustering installation. The issue error "'There is not enough disk space on the destination disk for the current SQL server data files" and when I have...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jan 4 2008
Filed under: Filed under: sql server, cluster, disk space, hardware, administrator, failover, errorr, installallation, not enough storage
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 16 2007
Filed under: Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 10 2007
Filed under: Filed under: sql server, dba, sqlagent, best practices, cluster, error log, online, failure, active/passive
Log Shipping error "Unable to copy the initialization file"

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 3 2007
Filed under: Filed under: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy
Is it possible to run SQL Server 2000 and 2005 version on same cluster?

Yes. This is supported as SQL Server 2005 and 2000 can be installed side by side on a cluster successfully. With regard to achieve this there should be more care on choosing the shared- disks & IP addresses with sensible resourced hardware. 1. Separate...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Aug 10 2007
Filed under: Filed under: sql server, cluster, 2000, 2005
Extending MSCS Cluster High Availability Offsite

MSCS clustering can be a good option for local high availability - but it doesn't provide complete protection from unplanned downtime. Download this free white paper and learn how extending your MSCS cluster offsite with a high availability solution...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jun 19 2007
Filed under: Filed under: sql server, high availability, cluster, offsite
Mount Points and Clustering blurb for SQL Server & windows operating system

Mount Point is the new concept introduced in the Windows 2003 Server (R2) that works as a mounted drive is a volume or a drive that is mapped to a folder on a volume that uses the NTFS file system. Mounted drives function as any other volume or drive...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, May 25 2007
Filed under: Filed under: sql server, security, disk, mount, shared, point, cluster

Page 1 of 1 (19 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.