If you see the server is IIS then you can take an educated guess that the DB is microsoft SQL server.
Another way of doing it is searching for the name of the website and the name of various popular database engines, with a bit of luck you might find a blog posting by a technie or a question in some support forum by someone working for company X.
SQL injection cheatsheet: http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/
Please don't try this unless you have permission, or it's your own site.
You can divine a bit of information from the site that way, but it is only guessing. Some sites expose information when they encounter an error, so if there's a method to trigger one, that could be useful.
Many WordPress blogs, for instance, show MySQL connection errors under high load, etc.