1°Vc nao aplicou as querys necessarias.Provalvelmente dentro do website baixado tem as query para vc executar.
2ºO problema de apenas vc ver o site e os outros nao,e pq seu firewall esta inpedindo.Libere as porta 80 TCP e UDP,8090 TCP e UDP no firewall e veja se funcionou.

Queys necessarias para serem aplicadas:
Ticket

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[site_ticket_res]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[site_ticket_res]


CREATE TABLE [dbo].[site_ticket_res] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[titulo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[site_ticket]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[site_ticket]


CREATE TABLE [dbo].[site_ticket] (
[titulo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[assunto] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[login] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Noticias

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[noticias]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[noticias]


CREATE TABLE [dbo].[Noticias] (
[Titulo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Por] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Tipo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Noticia] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Faq

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[faq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[faq]


CREATE TABLE [faq] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[titulo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[conteudo] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
[faq] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_faq_votos] DEFAULT (N'(0'),
[por] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO