Recommended Blog :)

Here's a recommended blog for you who want to learn about SQL Server : klik here.

wmiptsd.exe (Win32:wmit-c) How to Remove

After a long-long time not updating my blog, now..throwing all my laziness.., i'm trying to update it again (lebaiii). Let's start with a worm attacking at my office. All of us can't do our job almost for 2-3 days..

This worm called W32.spybot.worm(Symantec) or Win32:wmit-c (Avast). It attacked our dns server by 22 February 2010, changing a host file become almost 5MB (normally, it only 1KB), so all client can't access our file sharing on the server.
Beside changed file host's size, this worm also running and copying processes on the system, made ur CPU really busy and working really slow.

Symptom :

• You can find wmiptsd.exe (hidden file), wmiptsn.exe (hidden file), wmiptqxzv0.exe-qxzv8.exe on WINDOWS/system32 or at ur registry
• A lot of qxzv.exe running on ur CPU process
  
• The host file size becoming 5 Mb with some random data
• You can't go to safe mode because of this worm made some file at ur OS corrupted

Resolving Problem:

• You have to clean it one by one, so.. don't connect to ur network, first. But before it, download avast AV installer + the update
  
• Install Avast AV, then update it..
• Do boot time scan
• After that, check ur computer manually. Look at WINDOWS/system32 and registry.., is there any wmiptsd.exe, qxzv.exe, wmiptsn.exe?? If they still, delete it manually..
  
• Look at ur host file, and correct it manually
• After you'r sure your computer is clean, try to use ur computer with safe mode, if you cant do it, then repair ur OS
• Make sure that all of the computer is cleaned before u are connect to the network
• Finish...

Haiyaaahhh.., kenapa maksa banget sih pake Inggrisss?????

How to Remove sdra64.exe

A few days ago,there was a trojan (new for me) spreading on our networks. Like another virus, that trojan makes the autoprotect from antivirus not stop running...another indication from this trojan infected is our computer keep on hibernating. This trojan attacked the network using an email--masks itself as a “Password Reset Confirmation Email,” appears to come from Facebook.

Wheww.., it's kinda hard to explain sumthing using english yahh..

Ketika komputer Anda terinfeksi trojan ini, terdapat sdra64.exe pada proses yang berjalan. Dan ketika Anda melihat pada sistem registry Anda:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon -- lalu cari Userinit, terdapat:
C:\Windows\System32\Userinit.exe,C:\Windows\System32\sdra64.exe,
yang seharusnya:
C:\Windows\System32\Userinit.exe,

Jika Anda menghapus C:\Windows\System32\sdra64.exe, ketika di refresh, si trojan akan muncul kembali, dan merubah Userinit kembali menjadi seperti sedia kala.

Berikut langkah2 yang saya gunakan untuk membersihkan sdra64.exe=
- Download SUPERAntiSpyware
- Install dan update SUPERAntiSpyware
- Setelah itu, restart komputer dan masuk ke SafeMode
- Scan komputer dengan SuperAntiSpyware, sebelum scan, matikan system restore anda
- Setelah scan selesai, reboot komputer Anda
- Selesai.., gampang yah? ...

Create a Trend Line at Cognos Report Studio

One day, I got an assignment to make a trendline at Cognos Report Studio, and after searching from Google, i found out how to make it from IBM site <http://www-01.ibm.com/support/docview.wss?uid=swg21340501>


From that site, u'll find how to resolve this problem, ..here is it..

You have to using N values of X and Y, and fitting the line to the expected Y' values for given X values we do the following

Y' = a + b*X

a = (Average(Y)*Total(X*X) - Average(X)*Total(X*Y))/(Total(X*X)-N*Average(X)*Average(X))

b = Total(X*Y) - N*Average(X)*Average(Y)/(Total(X*X)-N*Average(X)*Average(X))

Then it'll be:

Y'= ((total(minimum([X]*[Y] for [X]) for report)-total(minimum(1 for [X]) for report)*average(minimum([X] for [X]) for report)*average(total([Y] for [X]) for report))*[X] + (average(total([Y] for [X]) for report)*total(minimum([X]*[X] for [X]) for report)-average(minimum([X] for [X]) for report)*total(minimum([X]*[Y] for [X]) for report)))/(total(minimum([X]*[X] for [X]) for report)-total(minimum(1 for [X]) for report)*average( minimum([X] for [X]) for report )*average( minimum([X] for [X]) for report ))

Go to try it.. :p

Installing IIS (Internet Information Services)

ON Windows Server 2003:

1. Insert Windows Server 2003 Cd
2. Click Start, Control Panel, and chose Add or Remove Programs
3. Click Add/Remove Windows Components and in the Windows Components Wizard, select Application Server
4. Click Next and wait until the installation complete, click Finish
   

ON Windows XP:

1. Insert Windows XP Cd
2. Click Start, Control Panel, and chose Add or Remove Programs
3. Click Add/Remove Windows Components and in the Windows Components Wizard, select IIS
4. Click Next and wait until the installation complete, click Finish

How to Install Cognos BI Server 8

This is step by step how to install Cognos BI Server at Windows..
First of all, make sure that:
- U've already installed the IIS (Internet Information Services)
- U've already installed the database application (ex.SQL Server 2005)

This is how to install Cognos BI Server:
- Run issetup.exe
- Follow the command at the installation











- After the installation completed, open the Cognos Configuration, and open up the Content Manager.
- Fill up your Content Store-Resource Properties with the right information (Type, Database Server n Port Number (port number 1433 is the default), User ID and Password, Database Name). Before that, u have to make a new blank_database, then u can put the database name at this Resource Properties.

- After that, start the Cognos Service
- If the Service has run properly, open the IIS. (Control Panel-Administrative Tools-Internet Information Services)
- Make a new virtual directory on Default Website, named it Cognos and put the path to/C:\Program Files\cognos\c8\webcontent, this virtual directory has read access
- Make another new virtual directory inside Cognos virtual directory, named it cgi-bin, put the path on C:\Program Files\cognos\c8\cgi-bin , it has read an execute access.
- If all of that steps have done, then open up the Web Service Extensions, still inside the IIS, then set ALLOW the ‘All Unknown CGI Extensions’


- The last step, open ur browser, then type http:\\localhost\cognos, and the Cognos BI Server has been completed.