December 16th, 2008 by Gabriel

If you try to run the Netdom.exe query fsmo command or if you try to run any remote procedure call (RPC)-based tool on the ISA server, you may receive the following error message :

“RPC server Unavailable”

Here is a quick fix for this error message :-

Configure the EnableRSS registry value and the EnableTCPA registry value

1. Click Start, click Run, type in regedit, and then click OK.

2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters

3. On the Edit menu, point to New, click DWORD Value, and then type EnableRSS.

4. Double-click EnableRSS, type 0, and then click OK.

5. On the Edit menu, point to New, click DWORD Value, and then type EnableTCPA.

6. Double-click EnableTCPA, type 0, and then click OK.

7. Exit Registry Editor, and then restart the server.

Configure the DisableTaskOffload registry entry

If you continue to receive RPC errors, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.

2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters

3. In the details pane, make sure that the DisableTaskOffload registry entry exists. If this entry does not exist, add the entry. To do this, follow these steps :

#. On the Edit menu, point to New, and then click DWORD Value
#. Type DisableTaskOffload.

4. Double Click DisableTaskOffload, type 1, and then click OK.

5. Exit Registry Editor, and then restart the server.

December 10th, 2008 by Gabriel

Simple steps to configure PHP with Windows

Suppose you have installed IIS and PHP say at C:\PHP on your Windows server then to configure PHP in IIS you can follow the below mentioned steps :-

Open up Internet Information Server(IIS) :-

Click on “Web Service Extensions”, on the left side you will find a green arrow near to “Add a new Web service extension…” click on it.

A pop up window will be appeared. Enter Extension name say .php and for the Required Files put “C:\PHP\php.exe”, enable the check box of “Set extension status to Allowed” at bottom :-

Now to add extension for the web site if its not there, right click on web site in question and select Properties >> Home Directory >> Configuration >> Add >> here you can add the extension shown as below :-

December 8th, 2008 by Gabriel

Basic SQL Statements :

SQL is used to query the database which are almost same for SQL Server, MS Access, Oracle and MySQL.
There are four types of basic queries :-

SELECT
INSERT
UPDATE
DELETE
ORDER BY

Different combination of parameters can be passed to a query.

1] SELECT :-

its the most common SQL statement using which data can be selected from database and the output is returned to user.The result is

stored in a result table, called the result-set.SQL is not case sensitive. SELECT is the same as select.
Here is a simple example -

select name, bdate from user;
this will return all names and bdates from the table user.

select * from user;
this will return all records of user table.

select * from user where name=’john’;
this will return all records in which name = john

select * from user where name=’john’ OR name=’paul’ OR bdate=01012007
this way you can add multiple filtering using “OR” , “AND” clause.

2] INSERT :-

it is used to take the data input from user and insert it into table of the database. Data can be taken from any form or it can be

directly inserted using query.It is used to insert a new row in a table.
Simple example-
Insert into Table1 (FirstName, LastName, Phone) Values (’Gabriel’, ‘R’, ‘1112222′);

3] UPDATE :-

Using Update, we edit / modify any exisiting table. Either all the rows can be updated, or a subset may be chosen using a condition.
Simple example -
Update Table1 Set name=@FirstName, LastName=@LastName, Phone=@Phone where id=@ID

WHERE clause us very important in Update query. If you don’t use WHERE then it will update all existing records in the table.

4] DELETE :-

It is used to delete rows in a table. It also uses WHERE claue. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted.
Here is an example of a Delete statement-

Delete From Table1 where ID=10

it will delete all records in which ID = 10

5] Order By Clauses :-

It is used to sort the output returned by a query. Using this clause, you can sort by any field in the table.
Example -
Select * from Table1 Order By name

This will list all returned records sorted by Name alphabetically.

‘ASC’ (ascending order) or ‘DESC’ (descending order) can be included in Orderby query to sort the output in ascending or descending order respectively.
Like -

Select * from Table1 Order By name DESC

December 6th, 2008 by Mithil

Hi

Their are lots of misunderstanding/confusion in Quorum Disk working and its size required.

I will try to sort out this Confusion in this discussion

This post will help, to understand those people who know what Cluster’s are. However, going in this discussion we must know how cluster work.

Cluster is a service which is used for Fault tolerance of an application, it is not for Load balancing as one server is in Active mode and others are in Passive mode. All resources are owned by one [Active] node in cluster. So when Active node is owner of resources it will serve all the request coming to it.

Now if this Active node goes down then all the services that this server is running will be transferred to other node [Passive], and then Passive node become Active  node.

Now how does the Passive node comes to know that Active node is down and I should start working as Active node.

Now here comes the involvement  of “Quorums Disk” .

When you configure Cluster for very first time, all Cluster configuration Database information are stored in this “Quorums Disk” in \MSCS\quolog.log. The quorum is also referred to as the quorum log. Quorums has to perform two most important jobs, those are, it lets the cluster service know which node should be active and be owner of resources. Node that is owner of the resources can only be in Active Mode. QUORUM is the main interpreter between all Nodes of cluster and help other node to take ownership when Active node goes down.

In some cases if internal communication of Cluster node fails, Say “Heart Beat” link goes down, Passive node will consider Active node has gown down, and start querying Quorum disk that Active node has gone down and request to transfer all the resources to him, but this is not the case as Active node is still functioning, so again Quorum disk play important role to reject Passive node request.

Disk size

Recommended Size is just 100mb, I would suggest to give 300-500mb.

Hope this post will help you

In my next post i will let know what pre-cluster node configuration to check before configuring Cluster.

November 26th, 2008 by Gabriel

Single User mode allows only one single user to connect to the database.
Even if SQL server is in Single User Mode, you can connect the SQL Query Analyzer with the SA user.

Single user mode specifies that only one user at a time can access the database. Basically it is used for maintenance purposes.

If any other users are connected to the database and you  switch the database to single user mode then their connections to the database will be closed without any warning message.

Following are the steps to start SQL server in Single User mode -

On your server :

Start >> Run >> type in CMD and hit Ok >> it will open up Command Prompt >> here execute the following command

net stop MSSqlServer

>> it will stop the SQL service >> now to start SQL in Single User mode execute following command

sqlservr -m

####

How to Set a single database into Single User Mode :-

You can set a single database into single user mode using an alternative procedure but this process cannot be used to set the MASTER database into single user mode.

# Connect to SQL Server using SQL Query Analyzer with SA user

# Execute the following command -

alter database database-name set SINGLE_USER

where “database-name” is the actual name of the database.

This cannot be used to place the databases MASTER, MSDB or TEMPDB in single user mode.

# To set the database back into normal multi-user mode use, execute the following command -

alter database db-name set MULTI_USER

November 24th, 2008 by Gabriel

A connection string is a string which contains information about a data source and its connectivity.
Connection string is always passed to a driver or provider which initiate the actual database connection.
It includes the attributes like name of the driver, server/host address, database name, security information like user name and password.
The format of a connection string is a semicolon-delimited list of key/value parameter pairs.

Following is a sample SQL database connection string :-

<add name=”SampleConnectionString” connectionString=”Data Source=AAAAAA;Initial Catalog=BBBBBB;User ID=CCCCCC;Password=DDDDDD” providerName=”System.Data.SqlClient” />

Where :
AAAAAA : Your server’s actual IP address.
BBBBBB : Your database’s actual Name.
CCCCCC : Your database’s actual Username.
DDDDDD : Your database’s actual Password.

November 19th, 2008 by Gabriel

System Databases in SQL Server :-

A Database Administrator shold be aware of system databases which is an integral part of the SQL Server.

System Databases are essential for the operation of a server instance.

Following are System Database in SQL Server 2005 & 2008.

Master Database :-

Master database is the heart of SQL Server, it records all system-level information of a SQL Server which includes instance-wide metadata such as logon accounts, endpoints, linked servers, system configuration settings, System Level Stored Procedures, System level Functions, all other existing databases, their MDF/LDF data file location etc.
Each SQL instance have its own Master database.
Master database consists of two physical files, namely master.mdf (data file) and mastlog.ldf (log file).
SQL Service can not be started if there is any problem with master database or its database files.
There are some restrictions on Master Database, you are not allowed to perform all the operations that you perform with normal database like, you can not add files or file groups, you can not change the owner, you can not drop the database, you can not change the collation, you can not remove the filegroup, primary data file, or log file, you can not take the database offline…

Model Database :-

The model database is used as the template for all databases created on an instance of SQL Server.
While creating a new database, SQL Server create it by getting a template from Model Database. Hence any change that you make in Model Database will reflect in newly created database as well for e.g. if a user creates any tables, stored procedures, user defined data types in Model database then those objects will be available in every newly created database as well.
Model database consists of two physical files namely Model.mdf (data file) and ModelLog.ldf (log file).
If the Model database is damaged or corrupted then SQL Server Service will not start up as it will not be able to create the tempdb database as TempDB database is recreated on every restart of SQL service.
Restrictions on Model Database are the same as that on Master Database.

MSDB Database :-

MSDB is the database used by SQL server Agent to store configuration information, Agent Jobs, Job schedules, Alerts, Operators, Service Broker, Log Shipping, database backups and restore information, Maintenance Plan Configuration, Configuration of Database Mail etc.
MSDB database consists of two physical files namely MSDBData.mdf (data file) and MSDBLog.ldf (log file).
The scheduling information used by SQL Server Agent will be lost in case of any problem occured with MSDB database.
Restrictions on MSDB Database are the same as that on Master Database.

TempDB Database :-

The TempDB is the only database which is recreated every time when SQL Server restarts.
It is besically used to store all the temporary objects like temporary tables, temporary stored procedures, cursors, table variables etc.
TempDB database consists of two physical files namely tempdb.mdf (data file) and templog.ldf (log file).
A clean/new copy copy of TempDB is created on each restart of SQL server, there is never anything stored in tempdb from one session of SQL Server to another.

November 12th, 2008 by Mithil

Step by Step Windows 2003 Cluster using VMware for testing Environment

It’s always good and must to have test environment rather than doing on live setup

Do I need to tell why?

Host System Installation

Windows 2003 SP2 Enterprise Edition with 4 GB RAM Dual Core 2 NIC [Minimum recommendation]

Do the OS installation as par the requirement, System drive 7 GB is enough

Update with SP2 and all latest patches

Install VMware server edition [Tested on version 5.x]

Installation and Configuration

Starting point is the preparation of a Windows 2003 cluster for Exchange 2003 with the following hardware specs.

ClusNode1 – System partition 4 Gb

ClusNode 2 – System partition 4 Gb

• Shared storage – Quorum – 500 Mb

• Shared storage – Databases – 4 Gb [Exchange Or SQL]

• Shared storage – Log files – 1 Gb [Exchange Or SQL ]

Two network interfaces (NICs) need to be configured per node, one for public cluster NIC and another for private NIC will be used for cluster heartbeat.

If you have AD/Domain installed on your test environment else install AD/Domain controller for testing environment then create cluster account or and create account with setting “Password never Expire” and “password can not be changed”.

Start Vmware Virtual machine creation

Create new virtual machine

Guest OS can be installed on Virtual IDE drive created in VMware

Open new Virtual machine Wizard

NEXT

Choose Custom >> click NEXT

Select Windows 2003 Ent >> Click NEXT

Give Friendly name to your Virtual Machine and its location [Store it on diff partition other that system]

Click Next.

On next page, allocate RAM memory to 1 GB [Recommended]

For Network type select Bridge Networking, click next

[This NIC will be used for public Access]

Create Virtual Machine Disk, Click NEXT.

Give Disk Capacity, I recommend 4-5 GB Click Next

Give the location where virtual disk information would be store

[This is the file that we will need to edit for sharing disk resource]

Click Advance

Select IDE 0.1, [This is the disk on which Virtual machine’s OS will be installed].

Click Finish.

Now additional component need to be added, like second NIC, and 2 SCSI HDD as shared disk resource.

Now click on “edit virtual machine setting”

Add >click “NEXT” on next page

Select Hard Disk click “NEXT”

Select option “Create New virtual disk”

Give disk space 500mb only

Specify this disk as Quorum disk

Click on “Advance”

Select SCSI 0:0 as Virtual Device Node and click on ‘Finish’.

Repeat the steps above for the remaining shared disks, those are needed.

Be Aware! The shared disks must be added as SCSI as this is necessary for the correct functioning of MSCS.

Now an extra NIC is needed.

Do same processes mention above, but select Ethernet Adapter on both VM’s

Select “Host-Only” click finish

This NIC will be used for “Hertbeat”

Complete configuration must look like this

Click on ‘OK’ to close the configuration editor.

Start Windows Explorer and navigate to the folder where the Virtual Machine is created.

Example it is Z:\VMware virtual machines\clusternodeA\name .vmx).

Open with Notepad the file <vm name>.vmx and add at the end the following line:

Disk.locking = FALSE

This makes sure that both nodes can access the same disks at the same time in case of cluster failover. MSCS is intelligent enough to prevent that both nodes actually do this at the same time.

Using the VMWare SCSI Driver in a New Virtual Machine

To use the driver when you are installing a Windows Server 2003 or Windows XP guest operating system in a newly created virtual machine, follow these steps. Download the driver from hxxp://www.vmware.com/download/downloadscsi.html

Save the downloaded file — vmscsi_<xxxx>.flp

Now the SCSI Hard-Disk those were added need to be configured

Edit the virtual machine configuration, click on added SCSI HDD and change the setting as shown below.

Make same changes to remaining SCSI hard-disk only. Virtual device node must me SCSI 0.1 as it would be another SCSI Device

Start the VM installation one by one [not simultaneously it will cause corrupt the hard-disk and shared data. Same precaution must be taken whenever Cluster node is rebooted.

Now you are ready to install cluster service on newly installed VM.

October 26th, 2008 by Gabriel

100% of CPU usage by Csrss.exe

Csrss stands for client/server run-time subsystem which is essential and must be running all the times.
It is responsible for console windows, creating and/or deleting threads etc.
The csrss.exe file is located in the folder C:\Windows\System32, if you find it at any other location then it may be a virus or spyware.
Csrss.exe process manages most graphical commands in Windows which is important for the stable and secure running of computer.

Whenever Csrss.exe utilizes 100% of the CPU on right clicking an item in Windows Explorer or on the desktop then it may be an issue with user profile, it may be corrupted.

Fix :-

First of all take the complete backup of your “My Documents” folder and all important data stored in your profile.
Log in with an account which has administrative privileges and open the user profiles list.
To retrieve the list of local user profiles right click on “My Computer” icon and select Properties,
click on Advanced tab,
click Settings under User Profiles,
select your profile from the list, and then click Delete.

Logoff, and then log back on as yourself. A new profile will be created when you log on.

October 19th, 2008 by Gabriel

ADSUTIL.VBS is the file that plays important role in creating and managing application pools.
It is a IIS administration utility that uses VBScript to manipulate the IIS configuration.

[NOTE - You must be a member of the Administrators group on the local computer to run scripts and executables ]

Following is the example to create a new application pool called “NewPool” and configure it to use a custom Application Pool identity of domain\username with a password of pass :-

CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\ADSUTIL.VBS CREATE w3svc/AppPools/NewPool IIsApplicationPool
CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\ADSUTIL.VBS SET w3svc/AppPools/MyAppPool/WamUserName “domain\username”
CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\ADSUTIL.VBS SET w3svc/AppPools/MyAppPool/WamUserPass “pass”
CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\ADSUTIL.VBS SET w3svc/AppPools/MyAppPool/AppPoolIdentityType 3

After executing above commands you will find a new application pool “NewPool” created under “Application Pools” in IIS.