Selasa, 31 Agustus 2010

Problem insttaling Adobe Reader Update on Windows Server 2008 R2, maybe Windows 7 too

This is Scurity settings of Windows server 2008, to not allowed all program accesing  system. So, to install Adobe update (for online user) follow these steps:
1. open C:\Program Files (x86)\Common Files\Adobe\ARM\1.0
2. Run AdobeARM.exe as Administrator
3. After pop up dispalyed, Like Adobe Reader Update. run it as usual

Jumat, 11 Juni 2010

Picture not present in MS Word

How to fix images not displaying in Microsoft Word 2007

Recently I've been hit by a bug (or what I thought was a bug) in Microsoft Word 2007: images embedded in the document did not display in any mode other than "Full Screen Reading". And since the editing ribbons are not available in that mode, it's hard to get work done. This all started when Word crashed on me one time; ever since then, images simply haven't been displaying correctly. I get a border where the image should be and white space inside. But when I send the file to other people and they open it, they can view the images just fine. I can even add images to documents; I just can't see them.

So I performed a Google search on this issue, but the only relevant "solution" was behind a paywall over at ExpertSexchange. After a few minutes of trying to figure it out on my own, I stumbled upon the solution, and to save everyone from the hell that is ExpertSexchange, here it is:

Click the Office Button (it's in the upper left corner of Word), select "Word Options", select "Advanced" in the left pane, scroll down to the "Show document content" subsection, and uncheck the "Show picture placeholders" option. Yes, it's that simple. Somehow, when Word crashes, this option can get turned on all by itself. It's really annoying because there's no clue that Word is intentionally hiding images from you; it just feels like a bug. And the reason for this insane option?

Word 2007 Options dialog

That's right, it's for performance. And it improves performance only at the expense of severely crippling usability. You'd think this option should never be able to get turned on accidentally, yet there it is. At least you know the solution now.


Jumat, 07 Mei 2010

Split Character di SQL Server

Contoh pemisahan karakter (seperti LEFT, RIght,Mid di Visual Studio):


/****** Object:  StoredProcedure [Reports].[Usp_RetrieveRPTDetailARAPB2B]    Script Date: 05/07/2010 15:39:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================


ALTER PROCEDURE [Reports].[Usp_RetrieveRPTDetailARAPB2B]
    -- Add the parameters for the stored procedure here   
--declare
@Company     varchar(6) ,
@InterDistrib varchar(6),
@CdJournalType  varchar(3),
@Channel varchar(30),
@Directorate varchar(6),
@Intermediary varchar(11)

--set
--@company     ='z'
--set
--@InterDistrib ='ALL'
--set
--@CdJournalType  ='ALL'
--set
--@Channel ='AGEN'
--set
--@Directorate ='ALL'
--set
--@Intermediary ='84938800'

as
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
     
 DECLARE @TmpTABLE TABLE    
(   
 company varchar(6) ,
 InterDistrib varchar(6), 
 Channel varchar(40)
)        

DECLARE 
@company1 varchar(6),
@InterDistrib1 varchar(6),
@Channel1 varchar(40)
         
INSERT INTO @TmpTABLE (company,InterDistrib,Channel)
SELECT  @company1, @InterDistrib1 ,@Channel1
       
SELECT @company1 = company ,@InterDistrib1 =InterDistrib , @Channel1 = Channel FROM @TmpTABLE
 
SELECT @company1 = CASE WHEN @company = 'ALL' THEN  '' ELSE @company END;
SELECT @InterDistrib1 = CASE WHEN @InterDistrib = 'ALL' THEN  '' ELSE @InterDistrib END;
SELECT @Channel1 = CASE WHEN @Channel = 'ALL' THEN  '' ELSE @Channel END;

 --IF @IsReady = 1
    -- Insert statements for procedure here
    SELECT
        ROW_NUMBER() OVER (ORDER BY [Company]) AS NO
        , Reports.Company.CompanyDescription AS Company
        , Reports.RPTDetailNoteData.CdJournalType AS CdJournalType
        , Reports.RPTDetailNoteData.CdSubJournalType AS CdSubJournalType
        , Reports.RPTDetailNoteData.NoteNumber AS NoteNumber
        , Reports.RPTDetailNoteData.PolicyNo AS PolicyNo
        , RPTDetailNoteData.OurRefNo AS [OurRefNo]
        , RPTDetailNoteData.[ClaimNo] AS [ClaimNo]
        , Reports.RPTDetailNoteData.ENDNo AS ENDNo
        , Reports.RPTDetailNoteData.Currency AS Currency
        , Reports.RPTDetailNoteData.InternalDistribution AS InterDistrib
        , Reports.Channel.ChannelDescription AS Channel
        , Reports.RPTDetailNoteData.CdProduct AS CdProduct
        , Reports.RPTDetailNoteData.MOUID AS MOUID
        , Reports.RPTDetailNoteData.Cd2W4W AS Cd2W4W
        , Reports.RPTDetailNoteData.CdSalesman AS CdSalesman
        , Reports.RPTDetailNoteData.ChassisNo AS ChassisNo
        , Reports.RPTDetailNoteData.EngineNo AS EngineNo
        , Reports.RPTDetailNoteData.CdPayer AS CdPayer
        , PayerName.CustomerDescription  AS PayerName
        , Reports.RPTDetailNoteData.CdCustomer AS CdCustomer
        , Reports.Customer.CustomerDescription AS CustomerName
        --, Reports.CustomerGroup.CustomerGroupCode + '-' + Reports.CustomerGroup.CustomerGroupDescription   AS CustomerGroup   
        --, Reports.IntermediaryGroup.IntermediaryGroupCode + '-' +Reports.IntermediaryGroup.IntermediaryGroupDescription AS IntermediaryGroup  
        --, Reports.RPTDetailNoteData.CustStatus + '-' +  CustomerStatus.CustomerStatusDescription AS CustomerStatus   
        , Reports.RPTDetailNoteData.DtStart AS DtStart
        , Reports.RPTDetailNoteData.DtEND AS DtEND
        , Reports.RPTDetailNoteData.DtDue AS DtDue
        , Reports.RPTDetailNoteData.CdCOB AS CdCOB
        , Reports.RPTARAPData.NYDAmount AS NYDAmount
        , Reports.RPTDetailNoteData.NoteAmount AS NoteAmount
        , CASE Reports.RPTARAPData.CdAging 
            WHEN 0 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_1_30'
        , CASE RPTARAPData.CdAging
            WHEN 1 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_31_60'

        ,CASE RPTARAPData.CdAging
            WHEN 2 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_61_90'

        ,CASE RPTARAPData.CdAging
            WHEN 3 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_91_120'

        ,CASE RPTARAPData.CdAging
            WHEN 4 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_121_150'

        ,CASE RPTARAPData.CdAging
            WHEN 5 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_151_180'

        ,CASE RPTARAPData.CdAging
            WHEN 6 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_181_210'

        ,CASE RPTARAPData.CdAging
            WHEN 7 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_211_240'

        ,CASE RPTARAPData.CdAging
            WHEN 8 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_241_270'

        ,CASE RPTARAPData.CdAging
            WHEN 9 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_271_300'

        ,CASE RPTARAPData.CdAging
            WHEN 10 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_301_330'

        ,CASE RPTARAPData.CdAging
            WHEN 11 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_331_360'

        ,CASE RPTARAPData.CdAging
            WHEN 12 THEN RPTARAPData.ARAmount
            ELSE 0
        END AS 'Amount_360'
        , Reports.RPTARAPData.ARAmount AS ARAmount
        , Reports.RPTARAPData.AmountGT30 AS AmountGT30
        , Reports.RPTARAPData.AmountGT60 AS AmountGT60
        , Reports.RPTARAPData.AmountGT120 AS AmountGT120
        , Reports.RPTARAPData.AmountGT180 AS AmountGT180
        , Reports.RPTDetailNoteData.GroupingNo AS GroupingNo
        , Reports.RPTDetailNoteData.ContractNo AS ContractNo
        , Reports.RPTDetailNoteData.ClientNo AS ClientNo
        , Reports.RPTDetailNoteData.PHolder AS PHolder
        , Reports.RPTDetailNoteData.DtProduction AS DtProduction
        , Reports.RPTDetailNoteData.UserEntry AS UserEntry
        , Reports.RPTDetailNoteData.ENDRmk AS ENDRmk
        , RPTLastSOANumberData.SOANo AS SOANo
        , RPTlastResultCategoryData.Modul AS Modul
        , Reports.OrderType.OrderTypeDescription AS OrderTypeName
        , Reports.RPTDetailNoteData.CdDealer AS CdDealer
        , ResultCategory.ResultCategoryDescription AS ResultCat
        , Reports.RPTDetailNoteData.DtDOL AS DtDOL
        , Reports.RPTDetailNoteData.CdIntermediary  AS CdIntermediary
        , Reports.RPTDetailNoteData.CdDirectorate AS CdDirectorate
        , Reports.RPTDetailNoteData.CdUnit + '-' + Unit.UnitDescription    AS CdUnit
        , Reports.RPTDetailNoteData.Partner AS Partners 
        , Reports.RPTARAPData.DtAsAt AS DtAsAt 
       

    FROM        
        Reports.RPTDetailNoteData
        INNER JOIN
             Reports.Company 
        ON Reports.RPTDetailNoteData.Company = Reports.Company.CompanyCode
        INNER JOIN
             Reports.RPTARAPData
        ON Reports.RPTDetailNoteData.FinanceNoteID = Reports.RPTARAPData.FinanceNoteID
        INNER JOIN
             Reports.Unit
        ON Reports.RPTDetailNoteData.CdUnit= Reports.Unit.UnitCode
        INNER JOIN
             Reports.Channel
        ON (SUBSTRING(Reports.RPTDetailNoteData.Channel,1,4)) = Reports.Channel.ChannelCode
        INNER JOIN
             Reports.Customer
        ON Reports.RPTDetailNoteData.CdCustomer = Reports.Customer.CustomerCode
        INNER JOIN
             Reports.Customer AS PayerName
        ON Reports.RPTDetailNoteData.CdPayer = PayerName.CustomerCode
        INNER JOIN
             Reports.OrderType
        ON Reports.RPTDetailNoteData.OrderType = Reports.OrderType.OrderTypeCode
        INNER JOIN
             Reports.Customer AS Intermediary
        ON Reports.RPTDetailNoteData.CdIntermediary = Intermediary.CustomerCode
        INNER JOIN
             Reports.RPTlastResultCategoryData AS RPTlastResultCategoryData
        ON RPTlastResultCategoryData.FinanceNoteID = RPTDetailNoteData.FinanceNoteID
        INNER JOIN
            Reports.RPTLastSOANumberData AS RPTLastSOANumberData
        ON RPTLastSOANumberData.FinanceNoteID = RPTDetailNoteData.FinanceNoteID
        INNER JOIN
            Reports.ResultCategory
        ON  ResultCategory.ResultCategoryCode  = RPTlastResultCategoryData.ResultCategory
        INNER JOIN
            Reports.RPTSettlementData RPTSettlementData
         ON RPTDetailNoteData.FinanceNoteID = RPTSettlementData.FinanceNoteID   
                 INNER JOIN
            Reports.CustomerStatus
         ON RPTDetailNoteData.CustStatus = CustomerStatus.CustomerStatusCode 

    WHERE

        --Reports.RPTDetailNoteData.Company LIKE '%' + @Company + '%' AND   
    (CASE WHEN ISNULL(@Company1, '')= '' THEN '' ELSE Company END)=ISNULL(@Company1, '') AND   
        --Reports.RPTDetailNoteData.InternalDistribution LIKE '%' + @InterDistrib + '%' AND Not(
    (CASE WHEN ISNULL(@InterDistrib1, '')= '' THEN '' ELSE RPTDetailNoteData.InternalDistribution END)=ISNULL(@InterDistrib1, '') AND NOT(
            RPTDetailNoteData.Channel='LEAS' AND
            RPTDetailNoteData.Partner IN ('ACC','TAF','FIF','SAF')) AND
        --Reports.RPTDetailNoteData.CdJournalType LIKE '%' + @CdJournalType + '%' AND  
    (CASE WHEN ISNULL(@CdJournalType, '')= '' THEN '' ELSE RPTDetailNoteData.CdJournalType END)=ISNULL(@CdJournalType, '') AND   
        --Reports.RPTDetailNoteData.Channel LIKE '%' + @Channel + '%'  AND
    (CASE WHEN ISNULL(@Channel1, '')= '' THEN '' ELSE Channel END)=ISNULL(@Channel1, '') AND       
        --Reports.RPTDetailNoteData.CdIntermediary  LIKE '%' + @CdInetermediary + '%' AND
    (CASE WHEN ISNULL(@Intermediary, '')= '' THEN '' ELSE CdIntermediary END)=ISNULL(@Intermediary, '') AND       
        --Reports.RPTDetailNoteData.CdDirectorate LIKE '%' + @CdDirectorate + '%'
    (CASE WHEN ISNULL(@Directorate, '')= '' THEN '' ELSE CdDirectorate END)=ISNULL(@Directorate, '')
    AND RPTDetailNoteData.TpNote = 'B2B' 
   
END





Kamis, 06 Mei 2010

How Do i Create Attachment from Stream Data


System.Net.Mail FAQ


3.4.2 How do I create an attachment from a stream? Printer Friendly

Something that is new in System.Net.Mail, is the capability to create attachments from streams. With this capability we can create an attachment from text, binary data, or from basically anything in memory. We simply need to make sure it is written to a stream.

The following example creates an attachment from some simple text, but it could have just as easily have come from Sql Server.

[ C# ]

static void AttachmentFromStream()
{

//create the mail message
MailMessage mail = new MailMessage();

//set the addresses
mail.From = new MailAddress("me@mycompany.com");
mail.To.Add("you@yourcompany.com");

//set the content
mail.Subject = "This is an email";
mail.Body = "this content is in the body";

//Get some binary data
byte[] data = GetData();

//save the data to a memory stream
MemoryStream ms = new MemoryStream(data);

//create the attachment from a stream. Be sure to name the data with a file and
//media type that is respective of the data
mail.Attachments.Add( new Attachment( ms, "example.txt", "text/plain" ));

//send the message
SmtpClient smtp = new SmtpClient("127.0.0.1");
smtp.Send(mail);
}
static byte[] GetData()
{
//this method just returns some binary data.
//it could come from anywhere, such as Sql Server
string s = "this is some text";
byte[] data = Encoding.ASCII.GetBytes(s);
return data;
}



[ VB.NET ]
Sub AttachmentFromStream()

'create the mail message
Dim mail As New MailMessage()

'set the addresses
mail.From = New MailAddress("me@mycompany.com")
mail.To.Add("you@yourcompany.com")

'set the content
mail.Subject = "This is an email"
mail.Body = "this content is in the body"

'Get some binary data
Dim data As Byte() = GetData()

'save the data to a memory stream
Dim ms As New MemoryStream(data)

'create the attachment from a stream. Be sure to name the data with a file and
'media type that is respective of the data
mail.Attachments.Add(New Attachment(ms, "example.txt", "text/plain"))

'send the message
Dim smtp As New SmtpClient("127.0.0.1")
smtp.Send(mail)
End Sub 'AttachmentFromStream

Function GetData() As Byte()
'this method just returns some binary data.
'it could come from anywhere, such as Sql Server
Dim s As String = "this is some text"
Dim data As Byte() = Encoding.ASCII.GetBytes(s)
Return data
End Function 'GetData


Kamis, 22 April 2010

Get Aero in Vista Home Basic

Start Menu > Click in the "Start Search" box > Type in "run" > Click on "Run" under the list of Programs found > Type "regedit" in the text box and click "Open" or press "Enter" key.

When the "Registry Editor" opens up, click and open the following folders:

"HKEY_CURRENT_USER" then "Software" then "Microsoft" then "Windows" and then "DWM".

Double click on "Composition" type "1" in the "Value data" field and click on the "OK" button.

Double click on "CompositionPolicy" type "2" in the "Value data" field and click on the "OK" button.

Exit out of the Registry Editor.

Start Menu > Click in the "Start Search" box > Type in "command prompt" > Click on "Command Prompt" under the list of Programs found > type in "net stop uxsms" press the "Enter" key > Wait for it to do its thing, then type in "net start uxsms" press "Enter" key.

Screen may flicker to set it up. Then right-click on your desktop and click on "Personalize" > Click on "Window Color and Appearance". You should be able to handle it from here.

Microsoft Windows Vista adalah sebuah sistem operasi yang unik

Microsoft Windows Vista adalah sebuah sistem operasi yang unik. Hal ini baru dapat kita rasakan apabila kita telah menggunakan sistem operasi ini. Banyak hal-hal baru yang akan kita dapatkan dari fitur-fitur terbaru yang terdapat di Windows Vista. Mungkin banyak opini orang yang mengakatakan bahwa windows vista adalah sistem operasi yang buruk. Tetapi setelah saya menggunakannya, ternyata yang saya rasakan tidak demikian. Dalam tugas sistem operasi ini akan saya bahas mengapa saya mengatakan windows vista adalah sistem operasi yang cukup bagus.
Windows Vista yang saya gunakan dirumah adalah Windows Vista Ultimate version. Mengapa saya memilih menggunakan Windows Vista Ultimate version, hal ini disebabkan karena versi inilah yang memiliki fitur paling komplit dari seluruh versi Windows Vista. Saya akan mulai dari penginstalan, pada Windows Vista pada saat penginstalan anda dapat langsung melakukan pempartisian hardisk sesuai yang anda inginkan. Waktu yang dibutuhkan untuk menginstal Windows Vista tidak terlalu lama, tidak lebih dari 30 menit. Setelah saya menginstal Wndows Vista, saya menginstal driver yang dibutuhkan motherboard dan kartu grafis dan hal yang saya temukan adalah hal yang sangat mengejutkan. Tidak seperti Sistem Operasi yang lain, Windows Vista dapat memilih driver yang mana saja dibutuhkan dan tidak (mungkin hal ini dikarenakan ada beberapa driver yang apabila dipakasakan akan menyebabkan crash pada sistem). Setelah penginstalan penuh maka kita akan merasakan banyak hal yang membuat sistem operasi ini berbeda dengan sistem operasi yang lain. Hal pertama yang akan muncul adalah welcome screen, disini kita dapat melihat score komputer kita (terlebih dahulu harus di update). Ketika saya melihat score yang diperoleh komputer saya, saya sangat terkejut karena hanya bernilai 5.0 (padahal spesifikasi komputer saya lumayan loh…). Ternyata ketika saya membaca keterangannya ternyata nilai 5.0 adalah nilai minimum untuk merasakan seluruh fitur Windows Vista (T.T). Saya akan menyertakan daftar spesifikasi saya agar anda bisa membayangkannya. Processor Intel Core 2 Duo E6320 1.86 Ghz (Score 5.0), Kartu Grafis ATI Radeon X1950 256 Mb GDDR3 (Score 5.9), Memory Patriot Extreme Dual Slot 2 x 1 Ghz (Score 5.8), dan Harddisk Western Digital 250 Gb SataII 8000 Rpm (Score 5.8). Setelah anda melihat spesifikasi komputer saya dapatkah anda bayangkan spesifikasi yang dibutuhkan untuk mencapai score 7.0 atau 8.0 ? (Bingung kan…).
Setelah saya melihat score komputer saya, hal yang saya lakukan adalah melihat performa komputer saya. Dan lagi-lagi saya dibuat terkejut oleh sistem operasi ini, hal yang saya temukan adalah Free Physical Memory yang terdapat didalam komputer saya adalah 0 (nol) padahal saya tidak sedang membuka aplikasi apapun. Kemudian saya bertanya-tanya “Kemana perginya physical memory saya sebanyak 2042 Mb ?”. Setelah saya selidiki, ternyata windows vista mengoptimalkan penggunaan physical memory untuk kartu grafis (Kartu grafis saya yang tadinya hanya memiliki memory sebesar 256 Mb sekarang menjadi 1024 Mb) dan proses yang dibutuhkan sehingga tidak akan ada memory yang terbuang percuma. Tetapi hal yang dilakukan oleh Windows Vista ini cukup aneh, hal ini dikarenakan kartu grafis yang saya gunakan tidak memiliki teknologi Hypermemory lalu bagai mana caranya Windows Vista dapat meningkatkan Memory pada kartu grafis saya ? (Cukup mencurigakan ya…). Sebenarnya kita dapat mengambil kesimpulan bahwa Windows Vista sangat mensuport HDT (High Definition Technology).
Sekarang saya akan membahas fitur-fitur yang telah saya coba gunakan pada Windows Vista Ultimate Version ini. Fitur yang pertama kali saya coba adalah Windows Media Center dan… Wow !!! Media center yang ditawarkan oleh Vista ternyata memiliki sangat banyak fungsi dimulai dari extended utility untuk home entertainment, burning, sampai maintenance (lho kok aneh ya, ada maintenance komputer di media center ??). Kemudian Fitur Lainnya adalah Windows Media Player 11, Windows DVD Maker, Internet Explorer 7, Windows Aero, dan masih banyak lagi. Sedangkan untuk keamanan Windows Vista memberikan Windows Defender, BitLocker dan Local Security Policy. Ada satu hal yang unik dari Windows Vista Ultimate, yaitu Windows Vista versi ini dapat menghandle beberapa Antivirus sekaligus melalui Windows Defender. Sedangkan BitLocker adalah Fitur yang digunakan untuk mengencrypt data pada hardisk, yang sayangnya saya sendiri tidak dapat menggunakannya karena harddisk yang dapat di encrypt hanya harddisk yang support dengan teknologi tersebut. Sekian mengenai fitur yang terdapat didalam Windows Vista yang saya bahas dalam karya tulis ini. Terima Kasih.

Join Milist Kami


style="border: 0px;"
alt="Click untuk join ke milisIT_07"/>

Click to join milisIT_07


Selasa, 13 April 2010

Menghentikan Kegiatan Facebook

Mungkin awal ketertarikan Anda terhadap Facebook dimulai dengan sesuatu yang simpel, yaitu agar tetap terhubung dengan teman-teman Anda, atau menambah jumlah teman Anda di dunia maya. Atau mungkin untuk mengisi waktu luang Anda agar tak bosan. Namun sekarang Facebook sudah menjadi sebuah duri dalam daging Anda, dan mungkin sudah menjadi hal yang bersifat candu. Jika Anda merasa sangat sukar untuk menghabiskan satu jam dari waktu Anda tanpa memikirkan tentang Facebook, mungkin Anda menginginkan sebauh jalan keluar. Maka Inilah jawabannya.

Langkah 1

Akui bahwa Anda memiliki permasalahan dan ingatlah apa-apa yang Anda lakukan dengan Facebook. Setelah semua sesi Facebook yang Anda lakukan, tanyakan pada diri Anda: "Apa yang telah Saya hasilkan dengan melihat Facebook?" Bukankah janggal, mungkin Anda log in hanya untuk melihat apakah Anda telah di poke, atau melihat update profil image teman Anda, menulis note baru, menambahkan daftar lagu baru pada favorite music, dan mengerjakan hal-hal kecil lain yang sebenarnya Anda bisa hidup tanpa melakukannya atau mengetahuinya. Namun semua itu mungkin hal-hal kecil yang membuat Anda terikat. Awalnya Anda mengkonfirmasi teman baru, kemudian Anda menghabiskan sejam waktu Anda untuk melihat semua profil orang-orang yang baru yang terhubung dengan Anda. Mencatat semua aktivitas Facebook Anda dapat membantu Anda untuk menyadari berapa banyak waktu yang Anda habiskan untuk melakukan hal-hal yang tidak bersifat konstruktif.

Langkah 2

Tentukan tujuan Anda ber-Facebook. Membuat sebuah daftar dari apa yang benar-benar Anda inginkan. Apa alasan Anda sign up di Facebook? Mungkin supaya Anda bisa mengingat hari ulang tahun teman Anda? Menemukan teman lama? Menemukan orang yang memiliki hobby sama? Apapun tujuan Anda, Anda perlu memastikan bahwa Anda mencurahkan waktu Anda di sana untuk menyelesaikan atau mengerjakan tujuan-tujuan tersebut, daripada keluar dari jalur yang tidak membawa Anda kepada hasil apapun. Jika Anda tidak memiliki tujuan apapun (contohnya: Jika Anda sign up hanya karena Anda tidak memiliki kerjaan lain), lewati saja langkah berikutnya.

Langkah 3

Buat dan ikuti jadwal kegiatan Facebook. Setelah tujuan-tujuan facebook tercapai, catatlah, berapa banyak waktu dan frekuensi yang Anda perlukan untuk mencapai tujuan-tujuan tersebut. Kemudian catatlah jumlah jam per minggu yang seharusnya Anda habiskan di Facebook. Jika kelihatannya terlalu banyak, sesuaikan aktivitas Anda. Mengikuti jadwal mungkin akan bisa mengatasi kecanduan Facebook Anda tanpa mengharuskan Anda berhenti.

Contohnya:

  • Tetap terhubung dengan teman kuliah – cek setiap hari, habiskan tidak lebih dari 15 menit untuk merespon pesan hanya dari teman kuliah (1 jam per minggu).
  • Mengurus Group – Cek setiap pagi dan malam masing-masing selama 10 menit, hanya untuk menghapus spam atau junk. Ingatkan diri Anda: jangan merespon postingan-postingan yang ada, memberi komentar atau mengirim pesan selama sesi ini (2 jam, 20 menit per minggu).
  • Menjaga agar group tetap menarik – Habiskan 30 menit setiap hari membaca semua komentar dan repon. (2 jam per minggu).
  • Mencari teman baru – Lihat-lihat profil 30 menit, dua kali seminggu ( 1 jam per minggu).
  • Total waktu maksimum yang Saya rencanakan untuk kegiatan Facebook: 6 jam, 20 menit.

Langkah 4

Pikirkan hal lain yang dapat Anda lakukan jika Anda menghabiskan waktu di Facebook. Jika Anda menghabiskan, katakanlah 10 jam per minggu di Facebook, maka buatlah sebuah daftar hal-hal lain yang dapat Anda lakukan dengan waktu tersebut. Anda dapat:

  • Mengambil pekerjaan part time dan menginvestasikan hasilnya pada stock.
  • Mengajari anak Anda bagaimana bermain bola.
  • Melakukan fitness.
  • Mencari pacar.
  • Membaca buku.
  • Belajar bahasa Inggris.
  • dll.

Langkah 5

Tinggalkan Facebook. Jika Anda sudah membuat jadwal dan tidak dapat mematuhinya, atau Anda telah memutuskan bahwa waktu yang dihabiskan di Facebook itu percuma, mungkin Anda perlu meninggalkan dan stop dari Faceboo

Rabu, 07 April 2010

Tips memikat wanita

23 best tips to get a girlfriend!
1. When she asks how she looks, shrug and say "could be better." This will keep her on her toes, and girls love that.

2. Never hold her hand. This can be interpreted as a sign of weakness. If she grabs your hand, squeeze hers really, really hard until she cries. This will impress her by showing her what a strong man you are.

3. Once a month sneak up on her from behind and knock her over. Girls are like dogs. They love to be roughed up.

4. Call her in the middle of the night to ask if she's sleeping. If she is, say "you better be." Repeat this 4 or 5 times until morning. This will show her you care.

5. When she is upset about something, suggest to her that it might be her fault. This will pave the way for her own personal improvement, and every girl needs some improvement.

6. Recognize the small things; they usually mean the most. Then when she's sleeping, steal all her small things and break them. Because jewelry is for ~Censored~.

7. If you're talking to another girl, make sure she's looking. When she is, stare into her eyes, mouth the words '~censored~ you, ' and grab the other girl's ass. Girls love competition.

8. Tell her you're taking her out to dinner. Drive for miles so she thinks it's going to be really special. Then take her to a burning tire yard. When she starts to get upset tell her you were just kidding and now you're really going to take her to dinner. Then drive her home. When she starts crying and asks why you would do something like that lean over and whisper very quietly into her ear "...because I can."

9. Introduce her to your friends as "some chick". Women love those special nicknames.

10. Play with her hair. Play with it HARD.

11. Warm her up when she's cold... but not by giving her your jacket, because then you might get cold. Rather, look her in the eye and say, "If you don't stop ~censored~ about the cold right now, you're going to be ~censored~ about a black eye." The best way to get warm is with fear.

12. Take her to a party. When you get there she'll have to go to the bathroom (they always do). Leave immediately. Come back right when the party's dying and yell at her the whole way home for ditching you at the party.

13. Make her laugh. A good way to do this is if she has a small pet. Kick the pet. I always find stuff like that funny. Why shouldn't girls?

14. Let her fall asleep in your arms. When she's fast asleep, wait 10 minutes then JUMP UP AND SCREAM IN HER EAR! Repeat until she goes home and you can use your arms for more important things. Like basketball.

15. Spit often. I hear girls like guys that spit.

16. If you care about her, never ever tell her. This will only give her self confidence. Then you can never turn her into the object she deep down desires to be.

17. Every time you're in her house steal one of the following: shoes, earrings, or anything else that comes in pairs. Only take one of the pair. This way she'll go crazy.

18. Take her out to dinner. Right when she's about to order interrupt and say "No, she's not hungry". Make her watch you eat. Girls love a guy that speaks for her.

19. Look her in the eyes and smile. Then punch her. Girls love a spontaneous guy.

20. Give her one of your t-shirts... and make sure it has your smell on it. But not a sexy cologne smell. A bad smell. You know what I'm talking about.

22. If you're listening to music, and she asks to hear it, tell her no. This way she'll think you're mysterious.

23. Remember her birthday, but don't get her anything. Teach her material objects aren't important. The only thing that's important is that she keeps you happy. And your happiness is the greatest present she can ever get

Copas dari forum bule

Kamis, 01 April 2010

Configure Remote desktop di Windows Server 2008

Windows Server 2008 is, as the name suggests, a server operating system. In the real world this means that systems running Windows Server 2008 will most likely be located in large rack systems in a server room. As such, it is highly unlikely that system administrators are going to want to have to physically visit each of these servers to perform routine administrative tasks such as system configuration and monitoring. A far preferable scenario involves these administrators remotely logging into the servers from their own desktop systems to perform administrative tasks. Fortunately Windows Server 2008 provides precisely this functionality through Remote Desktop and the remote administration features of the Machine Management Console (MMC). In this chapter we will look at the steps necessary to remotely administer Windows Server 2008 systems using Remote Desktop.

Contents

[hide]



[edit] What is Remote Desktop?

Remote Desktop allows the graphical interface of a remote Windows system to be displayed over a network onto a local system. In addition, keyboard and mouse events on the local system are transmitted to the remote system enabling the local user to perform tasks on the remote system as if they were physically sitting at the remote system. Conversely, resources (such as printers and disk drives) on the local system can be made available to the remote system for the duration of the connection. This remote control can be established in a number of ways, including over wide area networks (WAN), local area networks (LAN) or over the internet.

In the case of Windows Server 2008, this service is provided by Terminal Services running on the remote systems and the Remote Desktop Connection (RDC) client on the local system.

Terminal Services run in two different modes, Administration and Virtual Session. Remote Desktop for Administration provides full administration functionality to the remote administrator (including access to the console session and visibility of notification messages). Remote Desktop for Administration is the equivalent to working directly at the remote system's console. In virtual session mode the user is subject to some limitations such as the ability to install applications and view console notification messages.

Windows Server 2008 imposes some administrator logon restrictions. Specifically, a maximum of two administrators may be logged on at any one time, either two logged on remotely, or one local and one remote administrator. This assumes, however, that different accounts are being used to log on. In other words, the same user may not log on locally and remotely simultaneously.

[edit] Enabling Remote Desktop Administration on the Remote Server

As mentioned previously, remote desktop functionality on the server is provided by Terminal Services. It is important to note, however, that Terminal Services do not have to be explicitly enabled on the server in order to support Remote Desktop Administration. In fact, all that needs to be done is to enable Remote Desktop Administration. This is configured by opening the Control Panel from the Start menu and selecting the System icon (if the Control Panel is in Control Panel Home mode this is located under System and Maintenance). In the Task section in the top left hand corner of the System page select Remote settings to display the following properties window:


The Windows Server 2008 Remote Desktop Properties Dialog


The Remote properties dialog provides a number of options. The default setting is to disallow remote connections to the computer system. The second option allows remote desktop connections from any version of the Remote Desktop client. The third, and most secure option, will only allow connections from Remote Desktop clients with Network Level Authentication support. This typically will only allow access to systems providing secure network authentication such as Windows Vista and Windows Server 2008.

If the Windows Firewall is active, the act of enabling Remote Desktop administration also results in the creation of a firewall exception allowing Remote Desktop Protocol (RDP) traffic to pass through on TCP port 3389. This default port can be changed by changing this setting in the Registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TerminalServer\WinStations\RDP-tcp\PortNumber. The easiest way to locate this registry key value is to execute regedit from the Run window or a command prompt, select Edit - > Find and enter RDP-tcp.

[edit] Controlling Remote Desktop Access

The default configuration for Remote Desktop is to allow all members of the Administration group to connect remotely. Active Directory also contains a Remote Desktop Users group to which users may be added to provide Remote Desktop access privileges. To provide users with remote desktop access, open the Control Panel -> System and Maintenance -> System -> Remote settings and click on the Select Users button to invoke the Remote Desktop Users dialog illustrated in the following figure:


Selecting Windows Server 2008 Remote Desktop Users


Note that users with administrative privileges do not need to be added to this list; by default they already have Remote Desktop access. To add additional users click on the Add... button to display the Select Users dialog. Enter the name of the user in the text box entitled Enter object names to select and click on Check names to list names that match the name entered. Select the appropriate name from the list. The following example shows user Bill on server winserver-2:


Selecting a user for remote access


Click on OK to apply the change. The new user will now appear in the list of users with Remote Desktop access on the Remote Users screen. Click OK to close this screen and click on Apply in the System Settings screen. The specified user will now have remote desktop access to the system.

[edit] Remote Desktop Group Policy

A vast array of configuration options for Terminal Services is available through the Group Policy settings. To access these values start the Group Policy Object Editor (open the Start menu and enter gpedit.msc into the Search box). In the Group Object Policy Editor navigate to Computer Configuration\Administrative Templates\Windows Components\Terminal Services or User Configuration\Administrative Templates\Windows Components\Terminal Services to access the range of policy settings available.

Policy options include, amongst other options, items such as control over resource redirection (printers, audio etc), setting session time limits and security settings. A complete overview of all the settings is beyond the scope of this book but almost without exception the various settings are largely self-explanatory.

[edit] Starting the Remote Desktop Client

With the appropriate configuration tasks completed on the remote system the next step is to launch the Remote Desktop Client on the local system. The client can be run in either administration mode which provides full integration with the console of the remote server, or virtual session mode which provides some administrative privileges but does not provide console access or allow applications to be installed.

To invoke the Remote Desktop Client in virtual session mode either select Start -> All Programs -> Accessories -> Remote Desktop Connection or enter the following in the Run dialog or at a command prompt:

mstsc

To start the Remote Desktop Client in administrator mode run the following command:

mstsc /admin

In either case the following initial screen will appear requesting details of computer to which the client is to connect:


Specifying the Remote Computer


This can either be an IP address or a computer name. If previous connections have been established the User name field will be populated with the user name used in the preceding session. If you need to log in as a different user this option will be provided on the next screen which appears after the Connect button is pressed:


Windows Serevr 2008 Remote Desktop Security Screen


In this screen enter the password for the selected user (note that remote desktop access is only available for user accounts which are password protected). If a user other than the one displayed is required, simply click on the Use another account link and enter the necessary details. Click on OK to establish the connection. After a short delay the remote desktop will appear on the local computer screen.

[edit] Remote Desktop Client Configuration Options

The Options>> button displayed on the initial screen of the Remote Desktop Client provides six tabs, each containing a range of configuration options:

  • General - Allows login credentials to be configured and session information to be saved.
  • Display - Configures the resolution and color settings to be used when displaying the remote desktop on the local system.
  • Local Resources - Specifies which local resources (sound, disk drives, printers etc) are to be made accessible to the remote system during the Remote Desktop session. This page also provides options to control the situations under which special key combinations such as Ctrl-Alt-Del are interpreted by the local or remote systems.
  • Programs - Allows specified programs to be automatically invoked each time a remote sessions is established.
  • Experience - Controls which desktop features are enabled or disabled for the Remote Desktop session. For example, over a slow dial-up connection it is unwise to have the desktop background displayed and font smoothing enabled. Either select the connection type and speed to see recommended settings, or use Custom to configure your own settings. This particular screen also provides the option to have the connection automatically re-established in the event that a session is dropped.
  • Advanced - Enables and disables remote server verification. This ensures that the remote server to which you are connected is indeed the server you wanted. Also available are TS Gateway settings. By default the Remote Desktop Client is configured to automatically detect TS Gateway settings.

[edit] Remote Session Tracking

With Remote Desktop access implemented it is often useful to find out at times who is logged into a system. This can be achieved using the quser command-line tool. To obtain details of logged in users on a local system simply run quser at a command prompt or in a Run dialog:

C:Users\Administrator> quser
USERNAME SESSIONNAME ID STATE IDLE TIME LOGON TIME
administrator 1 Disc 3:18 7/11/2008 12:36 PM
bill rdp-tcp#0 2 Active . 7/14/2008 9:11 AM
nas console 3 Active none 7/11/2008 12:58 PM

To obtain information for a remote system simply run quser with the /server:<hostname> command-line option. For example:

C:\Users\Administrator> quser /server:winserver-2
USERNAME SESSIONNAME ID STATE IDLE TIME LOGON TIME
administrator 1 Disc 3:22 7/11/2008 12:36 PM
bill rdp-tcp#0 2 Active . 7/14/2008 9:11 AM
nas console 3 Active none 7/11/2008 12:58 PM

[edit] Logging out from a Remote Desktop Session

When the Remote Desktop Client is exited by pressing the 'X' on the control panel the remote session continues to run on the server even though no client is connected. Next time the user connects the desktop session will appear exactly as it was left before.

To end the session select Start in the remote desktop session, click on the right arrow button in the bottom right hand corner of the menu and select Log Off. This will close down the remote desktop session and close the remote desktop client.

[edit] Running Multiple Remote Desktops

Multiple concurrent remote desktops can be run and managed within a single window using the MMC Remote Desktops snap-in. This may either be snapped into the MMC or launched from the command-line or a Run dialog by typing:

tsmmc.msc

Once launched, right click on the Remote desktops item in the tree in the left hand panel and select Add a new connection from the menu. Once selected the Add New Connection dialog will appear as follows:


Adding a new connection to the Remote Desktops snap-in


In this dialog enter the IP address or computer name of the remote system together with the User name and the name to be assigned to this connection (this is essentially the name by which this connection will be listed and administered inside the Remote Desktops snap-in). For an administrative session (as opposed to a virtual session) set the Connect with /admin box. Click OK to add the session to the snap-in. Once added, the session will appear in the left hand panel under Remote Desktops. Repeat these steps to add connections to any additional remote systems required.

To establish a remote desktop connection, right click on the name of the session from the left hand panel and select Connect from the menu. The remote session will appear in the window. To start another session simply right click on the session name and once again select Connect. To switch between sessions simply click on the name of the session in the left hand panel and the corresponding desktop will be displayed. The following figure illustrates two sessions running in Remote Desktops:


Multiple remote desktops running in the Windows Server 2008 Remote Desktops Snap-in


To change configuration options for each session right click on the desired session in the left hand panel and select Properties. This panel has a number of tabs which enable credentials, screen size and program start properties to be defined.

Rabu, 31 Maret 2010

Error yg kualami di XAMPP

Offline louis_coetzeeTopic starter

  • Enthusiast

    • View Profile
Hi, I had to re-install my wampserver, probably a new version, now I get this new error:
Deprecated: Function eregi() is deprecated in C:\wamp\www\age_art\new\models\products.php on line 8

Code: [Select]
This is: products.php

<?php
   function 
image_list($image_dir)
   {
      $fileCount 1
      $dir opendir($image_dir);
      while ($file readdir($dir)) 
      { 
  
         if (eregi("\.jpg",$file)) 
         {
    
         $image_array[$fileCount] = $file;
    
         $fileCount++;
  
         }
      }
      return $image_array;
   }
?>


Offline TeNDoLLA

  • Enthusiast

    • View Profile
It means the function is old and not supposed to use anymore. I don't remember the versions where this still was or where it was removed but thats probably the case. You should use preg_match. And instead of all ereg* functions there is usually preg_* function that you can use. You can use the i -modifier to get it work incase sensitive.

Code: [Select]
<?php
if (preg_match('/.jpg/i'$file))
« Last Edit: September 08, 2009, 01:14:06 PM by TeNDoLLA »

Offline louis_coetzeeTopic starter

  • Enthusiast

    • View Profile
It means the function is old and not supposed to use anymore. I don't remember the versions where this still was or where it was removed but thats probably the case. You should use preg_match. And instead of all ereg* functions there is usually preg_* function that you can use. You can use the i -modifier to get it work incase sensitive.

Code: [Select]
<?php
if (preg_match('/.jpg/i'$file))

Thanks a lot. Solved!

Exporting and Importing WordPress

In the last two chapters, I talked about Installing WordPress Locally and Building Custom WordPress Theme. This chapter will cover exporting your local WordPress to a web host. Assume you are done with the local WordPress development, it is time to learn how to export and import WordPress. Then you can keep the local version for backup purpose and future development (ie. testing new themes, plugins, and upgrades).

1. Export Local Database

Login to your local phpMyAdmin, select the database from the dropdown. Click on the Export tab:

  • Under the Export field, make sure all tables are selected
  • Under the Structure field, tick "Add DROP TABLE / DROP VIEW"
  • Tick "Save as File"
  • Then click Go and it will prompt you to download a SQL file

export database

2. Find & Replace All Local URLs

Open the database SQL file with a text editor. Find and replace all local URLs with your domain URL (eg. replace all "http://localhost:8888/mysite" with "http://www.yourdomain.com").

export database

3. Import The Database

Login to your server cPanel, go to MySQL Databases, create a new database and assign a user. Now go to phpMyAdmin, select the database (the one that was just created) from the dropdown, click on the Import tab, browse the SQL file and click Go.

export database

4. Upload WordPress

Upload the entire WordPress folder to your server.

5. Change The wp-config.php Setting

On your server, open the wp-config.php file. Change the database details to reflect your server settings.

export database

6. Done

Go to your website and everything should work perfect.

Adding Themes on Windows Server 2008

 

If you are tired of using the Windows Classic theme on your Server 2008, you can install Desktop Experience so that you can enjoy the eye candy goodness of the Vista theme. Desktop Experience will also install Windows Media Player, Windows Sidebar and photo gallery. Follow these steps to install Desktop Experience and liven up your server:


1. Click Start and select Server Manager

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_servermgr2.png

2. When the Server Manager window appears, go to the left pane and select Features.

http://blogs.tech-recipes.com/shamanstears/files/2007/07/winsrv2k8_features.png

3. On the right, click the Add Features link.

http://blogs.tech-recipes.com/shamanstears/files/2007/07/winsrv2k8_powershll2.png

4. Check the Desktop Experience checkbox

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_desktopexp.png

5. Click Next.

6. Click Install

7. When the installation is complete, Windows will notify you that you must restart your server to complete the process.

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_desktoprestart.png

After you have rebooted, go to Services and make sure that the Themes service is started and set to Automatically Start (thanks DTron!). After that, you are ready to change the theme on your server.

1. Right-click the desktop and select Personalize.

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_selectpersonalize.png

2. Select Theme.

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_personalize.png

3. From the Theme Settings window, use the Theme dropdown and select the Windows Vista theme.

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_selecttheme.png

4. Click OK.

So you go from a boring look like this:

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_classic.png

To a much better visual experience:

http://blogs.tech-recipes.com/shamanstears/files/2007/08/tr_win2008_vista.png

 

Jumat, 26 Maret 2010

PDF PC Media Download

PDF PC MEDIA yg tahun 2009

buruan download sebelum hangus!!





http://rapidshare.com/files/361877873/PCMedia.Jan.2009.PDF.eBook.rar
http://rapidshare.com/files/361913764/PCMedia.Feb.2009.PDF.eBook.rar
http://rapidshare.com/files/361926254/PCMedia.Mar.2009.PDF.eBook.rar
http://rapidshare.com/files/361944596/PCMedia.Apr.2009.PDF.eBook.rar
http://rapidshare.com/files/361952592/PCMedia.May.2009.PDF.eBook.rar
http://rapidshare.com/files/361961472/PCMedia.Jun.2009.PDF.eBook.rar
http://rapidshare.com/files/361970663/PCMedia.Jul.2009.PDF.eBook.rar
http://rapidshare.com/files/361982218/PCMedia.Aug.2009.PDF.eBook.rar
http://rapidshare.com/files/361992580/PCMedia.Sep.2009.PDF.eBook.rar
http://rapidshare.com/files/362003281/PCMedia.Oct.2009.PDF.eBook.rar
http://rapidshare.com/files/362017322/PCMedia.Nov.2009.PDF.eBook.rar
http://rapidshare.com/files/362028068/PCMedia.Dec.2009.PDF.eBook.rar

Install Joomla on IIS

Joomla is an open-source content management system (CMS) that lets you build Web sites and powerful online applications, such as:

  • Corporate Web sites or portals
  • Corporate intranets and extranets
  • Online magazines, newspapers, and publications
  • E-commerce and online reservations
  • Government applications
  • Small business Web sites
  • Non-profit and organizational Web sites
  • Community-based portals
  • School and church Web sites
  • Personal or family home pages

For more information about Joomla, visit the Joomla Web site.

This article describes how to install and configure Joomla for use with the FastCGI extension on Internet Information Services 7 (IIS 7) on Windows® Web Server 2008. The instructions assume that you have set up and configured the FastCGI extension and the PHP libraries. The instructions have been tested and found to work with the following software versions:

  • PHP 5.2.9
  • MySQL 5.1.34
  • Joomla 1.5.14

Prerequisites

From the base default configuration file provided by PHP, modify the following lines in your Php.ini configuration:

  • Define extension_dir as c:\php\ext (for example, the location of your php extensions directory).
  • Uncomment extension=php_mysql.dll in the extensions list to enable MySQL support.

In order for Joomla to work correctly with IIS 7, it is necessary to install an update for IIS FastCGI module for IIS 7.

Download and Unpack the Application

First, download the latest stable release of Joomla. For this article, Joomla version 1.5.14 was used (future versions are likely to be similar to install). Uncompress the Joomla files and copy them to C:\Inetpub\wwwroot\joomla (or another directory of your choosing).

Before running the Joomla installer, create the configuration file Configuration.php, which Joomla uses to store key configuration settings. Assign write permissions to it with the command (from the installation directory):

C:\inetpub\wwwroot\joomla>icacls configuration.php /grant BUILTIN\IIS_IUSRS:W

The installer will modify the Configuration.php file with information provided during the installation process.

Joomla uses the Administrator\Cache folder Tmp and therefore needs to be able to write and modify files in this folder. Grant "modify" permissions to the folder:

C:\inetpub\wwwroot\Joomla>icacls administrator\cache /grant BUILTIN\IIS_IUSRS:(OI)(CI)(M)

Joomla uses the temporary folder Tmp to store temporary files and therefore needs to be able to write and modify files in this folder. Grant "modify" permissions to the folder:

C:\inetpub\wwwroot\Joomla>icacls tmp /grant BUILTIN\IIS_IUSRS:(OI)(CI)(M)

Set Up the Database

Before starting the installation procedure for Joomla, you must create a database on your server. Also create a user and grant this user "db ownership" permission to the database. This article uses the following database information:

  • Database name: joomla
  • Database user: joomla
  • Account password: joomla

Run the Installation Script

1. Start the configuration procedure in a Web browser. Go to http://localhost/joomla/. (If the Index.php file is not in the browser default document, then add it.)

2. Select the language, and then click Next.

Figure 1: Choose Language page

3. Verify that all pre-installation checks are successful, and then click Next.

Figure 2: Pre-installation Check page

4. Review the GNU General Public License, and then click Next.

 

Figure 3: License page

5. On this page enter the following information, and then click Next.

      a. Host Name: localhost
      b. Username: joomla
      c. Password: joomla
      d. Database: joomla

Figure 4: Database Configuration page

6. On the FTP Configuration page, select the No option button (not to enable FTP file system layer), and then click Next.

Figure 5: FTP Configuration page

7. Specify the site name and the administrator password. Click Next to complete the installation.


Note: You may scroll down and install sample data if you prefer.


Figure 6: Main Configuration page

8. The Finish page appears, and you are instructed to delete the C:\inetpub\wwwroot\joomla\installation directory.

Figure 7: Finish page

9. You can now go to the Joomla site.

Figure 8: Joomla site

Enable Search Engine Friendly URLs

By default, Joomla uses query string parameters for all the URLs it generates for your Web site. You change this by by enabling search engine friendly URLs, a feature which relies on the URL rewriting functionality.

IIS 6.0 does not include URL rewriting capabilities; you can use a third-party URL rewriting product such as ISAPI_Rewrite or Ionics ISAPI Rewrite Filter.

IIS 7 includes URL rewriting support, which can be enabled by installing Microsoft URL Rewrite Module for IIS 7.

1. Download and install the Microsoft URL Rewrite Module.

2. If it does not already exist; create and open a Web.config file located in the C:\inetpub\wwwroot\joomla directory.

3. Paste the following XML code into this file.

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
  <system.webServer>
    <rewrite>
      <rules>
        <rule name="Security Rule" stopProcessing="true">
          <match url="^(.*)$" ignoreCase="false" />
          <conditions logicalGrouping="MatchAny">
            <add input="{QUERY_STRING}" pattern="mosConfig_[a-zA-Z_]{1,21}(=|\%3D)" ignoreCase="false" />
            <add input="{QUERY_STRING}" pattern="base64_encode.*\(.*\)" ignoreCase="false" />
            <add input="{QUERY_STRING}" pattern="(\&lt;|%3C).*script.*(\>|%3E)" />
            <add input="{QUERY_STRING}" pattern="GLOBALS(=|\[|\%[0-9A-Z]{0,2})" ignoreCase="false" />
            <add input="{QUERY_STRING}" pattern="_REQUEST(=|\[|\%[0-9A-Z]{0,2})" ignoreCase="false" />
          </conditions>
          <action type="CustomResponse" url="index.php" statusCode="403" statusReason="Forbidden" statusDescription="Forbidden" />
        </rule>
        <rule name="SEO Rule">
          <match url="(.*)" ignoreCase="false" />
          <conditions logicalGrouping="MatchAll">
            <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" pattern="" ignoreCase="false" />
            <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" pattern="" ignoreCase="false" />
            <add input="{URL}" negate="true" pattern="^/index.php" ignoreCase="false" />
            <add input="{URL}" pattern="(/|\.php|\.html|\.htm|\.feed|\.pdf|\.raw|/[^.]*)$" />
          </conditions>
          <action type="Rewrite" url="index.php" />
        </rule>
      </rules>
    </rewrite>
 </system.webServer>
</configuration>

4. Save the web.config file.

5. Open a Web browser, and log on to the Joomla administrator console at http://localhost/joomla/administrator/.

6. Click on Site --> Global Configuration menu to configure SEO Settings:

1. Search Engine Friendly URLs - Yes

2. Add suffix to URLs - No

Figure 9: Global Configuration page

3. Click Apply to save the configuration.

4. Restart Windows® Internet Explorer®.

5. Go to http://localhost/joomla/. All links in Joomla pages now have URLs without query string parameters. If you click on any of these links, the server returns a correct response:

Figure 10: Links in Joomla page

 

Note: This article updates "Joomla! on IIS" by Ruslan Yakushev, published on December 12, 2008.

Links for Further Information 

Setting up FastCGI for PHP.

Using FastCGI to Host PHP Applications on IIS 7.0.

Installing PHP on Windows Vista with FastCGI.

Installing FastCGI Support On Server Core.

FastCGI forum.

PHP community forum.