Archive for the ‘Clustering’ Category
All About SQL server 2005 Clustering and Windows Clustering
Posted by: Manpreet Singh on: July 9, 2009
Basic hardware requirement
Minimum two servers with windows server 2003 datacenter, enterprise or standard edition (Two node clustering only).
Shared storage (SQN, ISCSI) etc. with Minimum 3 partitions (for Quorum (500 MB), MSDTC(2 GB) and Data files (Depends))
Minimum 2 Network card per server for public and private network with 500-millisecond or less round-trip response time
Nodes must be [...]
SQL Installation Server Setup Checklist
Posted by: Manpreet Singh on: June 26, 2009
Before Install
Create at least one new Active Directory account for SQL Server.
This is best practices, and a popular shortcut is to run all of the database servers under the same service account. I’ve run into two problems with this approach. First, I’ve had a sysadmin repeatedly fat-finger the service account password, thereby locking out [...]
ISCSI and SQL Server
Posted by: Manpreet Singh on: June 22, 2009
ISCSI is a great new technology in the world of storage. It is the standard which provide storage interface by carrying SCSI command over TCP/IP network. It helps organizations to consolidate storage and provide host with a illusion of locally – attached disk storage. Microsoft fully supports Microsoft SQL Server when it is deployed on [...]
Configuring Active Directory and Domain Controller
Posted by: Manpreet Singh on: May 19, 2009
Installing Active Directory needs static IP address. This can be assign by selecting network card properties and then typing in the IP address we wish to use. The subnet mask must also be provided. Both values must be correctly chosen given the networking configuration of the network that the cluster will be a part of. [...]
