RSS

Category Archives: Windows Server 2008 R2

Steps for Creating System Stored Procedure In SQL Server 2008 R2

In our previous discussion, we have discussed about transaction log corruption and backup in SQL Server. Now, in this article we will know the steps for creating system stored procedure in SQL Server 2008 R2.

Organizations where SQL Server system is used for database storage and maintenance, projects with 1000s of database tables and stored procedures are common to find. Adding even a single parameter to an existing stored procedure can straightaway put an impact on a large number of other stored procedures or database tables as they are called from them. Moreover, Read the rest of this entry »

 

Tags:

Cluster Firewall issue – An item with the same key has already been added

Problem :

When I Prepare the Test Environment to the SQL Server Clustering  Under Windows Server 2008R2 Clustering I get this issue :

Clutser validation Error

After I Create the Cluster must be make validate the Configuration when I check this Configuration I get this issue Validate Windows Firewall Configuration in the detail of the error An item with the same key has already been added

Reason of the problem :

This is typically because the NIC GUID is duplicated between cluster nodes. When I won’t to create 3 Virtual machine (Cluster-PC , Node 1 , Node 2 )

I Create the First Virtual machine and take it Twice copy this is the issue because when I make Copy the Node 1 and Node 2 Created with the same Physical Address (MAC IP) so the Conflict in this area

the first solution came to my brain it’s I will Format Node 1 and I will install it from the first (Windows) but I Check more time to another Solution and I defected good Solution by Asking my friend System Administrator Eng.Hamada Abdelkader

Solution :

1- open the Run

2- Write this Command (sysprep)

3- Enter

this Command is System preparation it will male  preparation to the network after this Command finish I Check the mac IP very good new Address and I run the Validate Configuration for the Windows Cluster again and it successful 100%

Thanks For Eng.Hamada Abdelkader

Regards,

Eng.Mostafa Elmasry

Database Administrator

 
Leave a comment

Posted by on March 15, 2013 in HA Clustering

 

BgInfo v4.16

If you manage multiple computers you probably need BGInfo. It automatically displays relevant information about a Windows computer on the desktop’s background

Download BgInfo software

http://technet.microsoft.com/en-us/sysinternals/bb897557

 

 

 
Leave a comment

Posted by on February 20, 2013 in Windows Server 2008 R2

 

Enable Network Discovery Server 2008 R2

Problem

When you try to Enable Network Discovery in Server 2008 R2 After you have enabled this it simple turns off again so you need to enable the following services

Services you must enabled it before enabled Network Discovery :

1- DNS Client

2- Function Discovery Resource Publication

3- SSDP Discovery

4- UPnP Discovery

The ways to Enable this Services :

Way No 1

Open Run then Write CMD then Write this Statment

  • net start “DNS Client”
  • net start “Function Discovery Resource Publication”
  • net start “SSDP Discovery”
  • net start “UPnP Discovery”

Way NO 2

Open Start Menue / Administrative Tools / Services / Then Select your Serives

 
Leave a comment

Posted by on August 17, 2012 in Network

 

Difference between MBR and GPT in hard disk

Difference between MBR and GPT in hard disk

MBR:Master Boot Recorded

  • This option found in all operating  System
  • This option found if your disk type is basic not dynamic
  • You can setup any operating system 64bit or 32bit
  • You can make Dual booting because you have option make partition as active so you can setup more than one operation system in this hard
  • In windows XP  you can create 4 primary partition
  • In windows vista,7,2003 you can create 3 partition (Mandatory) and 128 logical partition
  • In windows 2008 can create 3 partition (Mandatory) and unlimited  logical partition
  • Support 3 file system Fat 16 , Fat 32 ,  NTFS
  • Mix mum Size of the partition is 2TB

GPT :GUID Partition Table

  • This option found in All operating system expected XP so in xp all hard disks if it basic it will be MBR
  • This option found if your disk type is basic not dynamic
  • Any operating system can running in this partition but must be 64bit if it 32bit will not running
  • You can’t make Dual booting because you don’t have option make partition as active like in MPR so you can’t setup more than one operating system
  • In windows 7,2003,2008 you can create 128 primary partition
  • You can’t create logical partition
  • Support one file system NTFS only
  • Mix mum size of the partition is 256 TB

 
2 Comments

Posted by on February 17, 2012 in Introducation

 

Server Core in windows server 2008

What is Window Server core ?

Server Core is a minimal server installation option for computers running on the  Windows Server 2008 operating system or later. Server Core provides a low-maintenance server environment with limited functionality.

Server Core Requirements?

Windows server 2008 or later version .

Roles cans server core run .

Active Directory domain services (AD DS) (including Read only domain controllers RODS)

Active directory lightweight directory services (AD LDS)

DHCp Server

DNS Server

File Services

Print Services

Streaming Medias Services

Web Server (IIS)

 

 
Leave a comment

Posted by on January 28, 2012 in Introducation