DVD drives read the media and pass it to a player program, like WinDVD or PowerDVD. One of these programs should have come with the DVD drive, unless you bought OEM. Do you have one of these programs? Did you install it from the CD it more than likely came on?
If you do have one and did install it, and the DVD still won't auto-play, try invoking the program first, then putting the DVD in the drive, then using the program's open or play function.
If you put a DVD in the drive, and you open "My Computer", does it display (recognize) the DVD in there?
If you don't have a DVD player installed, you need to get one. WinDVD and PowerDVD can be downloaded from the 'net for around $50USD.
HTH
Nikki