Seems Like you already have the database of that
particular site in the SQL Server.
If you are restoring any portal site , First check
manually whether the database of the site which you
are restoring is already there or not. If it is there
then delete it. Even renaming the databases will not
workout.
For Sharepoint site, Check IIS is installed or not and
then SPS site. If SPS Site is not loaded properly then
Better option is that Install the SPS in the
procedural way - Win2003, IIS, SQL Server, SPS2003,
Service Pack(3) if any , Office, etc..
Don't load Sharepoint databases manually to the new
server other than Restore option using Wizard or
command.