Feeds:
Posts
Comments

Archive for August, 2011

Problem

How can I find out which SQL product and version  is installed on my server?

Solution

  • If your database server is installed on windows 2003 , go to start > Programs > Microsoft SQL Server 2005/2008 > SQL Server Management Studio

             

  • If your database server is installed on windows 2008 , go to start > Microsoft SQL Server 2005/2008 > SQL Server Management Studio

             

  • If your database server is installed on windows 2008 R2 , go to start > Microsoft SQL Server 2005/2008 > SQL Server Management Studio

             

  • Stand on one of the databases > Right Click > New Query, and write the following syntax:

             SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

  • Run the query by pressing “Execute” .
  • I received for example the following output: 9.00.3042.00 | SP2 | Enterprise Edition

             

  • Afterwards , check in the table below  for your product version . for example I searched for “9.00.3042“ and I saw that I have “SQL Server 2005 Service Pack 2” – Enterprise Edition from the output above.
Release Product version
SQL Server 2008 R2 Service Pack 1 10.50.2500.0
SQL Server 2008 R2 RTM 10.50.1600.1
SQL Server 2008 Service Pack 2 10.00.4000.00
SQL Server 2008 Service Pack 1 10.00.2531.00
SQL Server 2008 RTM 10.00.1600.22
SQL Server 2005 Service Pack 4 9.00.5000.00
SQL Server 2005 Service Pack 3 9.00.4035
SQL Server 2005 Service Pack 2 9.00.3042
SQL Server 2005 Service Pack 1 9.00.2047
SQL Server 2005 RTM 9.00.1399

 

Fixed!

Idit 🙂

Read Full Post »

Problem

We’ve purchased Dell PowerEdge R710 which arrived build in with quad network adapter , and we’ve added to it additional quad port network adapter.

We’ve installed on the server ESX 4. The problem was that after connecting to the server from vSphere client , it recognized only 4 network adapters (the build in quad port network adapter) and not the additional quad port network adapter.

How can we install drivers for the second quad port network adapter?

Solution

  • Check on your server’s quote what is the type and model of the quad port network adapter.
  • We’ve found out that our quad port network adapter was Intel’s  model 82576.
  • I’ve opened http://www.google.com and typed the following: VMware ESX 4 Driver CD for Intel ,and the first link was a perfect match: http://downloads.vmware.com/d/details/esx40_intel_82580_v4002198_dt/ZHcqYmRwakBiZCVodw==
  • I’ve downloaded the ISO to my computer.
  • Download and install the software: Tunnelier (SSH Client) from the following path:  http://www.bitvise.com/download-area
  • Using Tunnelier (SSH Client) connect to your ESX host on which you would like to install the quad port network adapter. (Make sure you connect as Administrator)
  • After connecting through Tunnelier (SSH Client) to your ESX host , two windows will open: 1. Bitvise SFTP (the windows window) 2. Bitvise xterm (the SSH window)
  • Using Bitvise SFTP ,(from the left side of the window) navigate on your computer to the path which you saved the ISO (Intel’s Driver CD for VMware ESX 4).
  • From the right side of the window – navigate to:  /usr/lib/vmware/isoimages (you will notice that after double clicking “isoimages” you will be transferred automatically to /vmimages/tools-isoimages – it is OK, you are on the right track :)), drag the ISO file from the left side of the window to the right side of the window, and wait until the transfer will finish.
  • From the SSH window (Bitvise xterm) write the following: mount -o loop -t iso9660 /usr/lib/vmware/isoimages/ISONAME.iso /mnt/cdrom , for example: mount -o loop -t iso9660 /usr/lib/vmware/isoimages/vmware-esx-drivers-net-igb_400.1.3.19.12.1-1.0.4.164009.185976.iso /mnt/cdrom

            

  • From the SSH window (Bitvise xterm) write the following: mount

            

  • From the SSH window (Bitvise xterm) write the following: cd /mnt/cdrom/offline-bundle
  • From the SSH window (Bitvise xterm) write the following: esxupdate –bundle=INT-intel-lad-ddk-igb-1.3.19.12.1-offline_bundle-185976.zip update

                             

  • Wait until receiving successful message.

             

  • Restart the ESX server.
  • After the restart, connect to Tunnelier (SSH Client), from the SSH window (Bitvise xterm) write the following: esxcfg-nics –l , you will be able to see the additional 4 ports which you have just installed the drivers to.

            

  • And from the vSphere client you will be able to see it as well by going to : Stand on the host > Configuration > Networl Adapters

             

 

Fixed!

Yaron & Idit 🙂

Read Full Post »

Problem

We created a datastore that contain ISO files, and we wanted to grant permissions to users in order to attach these ISO files into their virtual machine’s CD-Rom. (in addition to the regular operations as power on/off and managing snapshots).

Solution

In order to do that I created a special Role , below you can find the content of that role.

  • Connect to the vSphere client
  • Go to Home > Role > Add new Role > Snapshots & Connect ISO
  • Check the following permissions:
    • Datastore > Browse datastore
    • Virtual Machine > Configuration > Modify device settings
    • Virtual Machine > Interaction > Configure CD media
    • Virtual Machine > Interaction > Console interaction
    • Virtual Machine > Interaction > Device Connection
    • Virtual Machine > Interaction > Power on
    • Virtual Machine > Interaction > Power off
    • Virtual Machine > State > Create snapshot
    • Virtual Machine > State > Remove snapshot
    • Virtual Machine > State > Rename snapshot
    • Virtual Machine > State > Revert to snapshot
  • Go to Home > VMs and Templates and > Stand on a certain folder > Permissions,  and add this role (Snapshots & Connect ISO) to a user on that path, for example :

            

  • Go to Home > Datastores > Stand on a certain datastore which contains the ISO files (in my example Emcvm-Images2) > Permissions > and add this role to the same user as you added on the folder (Snapshots & Connect ISO) ,for example :

              

  • The user will see as follow (Right click on the virtual Machine > Edit Settings) :

             

Fixed!

Idit.

Read Full Post »