HOW TO: Install SQL Server 2000 - Basic Local Installation

HOW TO: Install SQL Server 2000 - Basic Local Installation

APPLIES TO

    * Microsoft SQL Server 2000 Standard Edition

SUMMARY
This step-by-step guide describes how to install a SQL Server 2000 basic local installation.

Note SQL Server 2000 64-bit uses Windows Installer to completely integrate the installation of SQL Server features in a single feature tree. Minimum and typical installation modes are no longer implemented. For more details, see the SQL Server 2000 64-bit documentation.
Back to the top
Installing SQL Server 2000
To Install SQL Server 2000 Basic Local Installation

   1. Insert the Microsoft SQL Server 2000 compact disc in your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), select SQL Server 2000 Components, and then select Install Database Server. Setup prepares the SQL Server Installation Wizard. At the Welcome page, click Next.
   2. In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the text box. Click Next.
   3. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next. Follow directions on the User Information, Software License Agreement and related pages. In the Installation Definition dialog box, click Server and Client Tools, and then click Next.
   4. In the Instance Name dialog box, if the Default check box is available, you can install either the default or a named instance. If the Default check box is not available, a default instance has already been installed, and you can install only a named instance.
          * To install the default instance, click to select the Default check box, and then click Next.
          * To install a named instance, click to clear the Default check box, type a new named instance in the Instance Name box, and then click Next.
   5. In the Setup Type dialog box, click Typical or Minimum, and then click Next.
   6. In the Service Accounts dialog box, accept the default settings, type your domain password, and then click Next. In the Authentication Mode dialog box, accept the default setting, and then click Next. When you finish specifying options, click Next in the Start Copying Files dialog box.
   7. In the Choose Licensing Mode dialog box, make selections according to your license agreement, and then click Continue to begin the installation. In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish.

To Install Client Tools Only for SQL Server 2000

   1. Insert the Microsoft SQL Server 2000 compact disc in your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), select SQL Server 2000 Components, select Install Database Server, and then click Next at the Welcome page of the SQL Server Installation Wizard.
   2. In Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the edit box. Click Next.
   3. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.
   4. Follow the directions on the User Information, Software License Agreement, and related pages.
   5. In the Installation Definition dialog box, click Client tools only, and then click Next.
   6. In the Select Components dialog box, accept the defaults or select the components you want, and then click Next. You can select an item in the Components list, such as Management Tools, and then select items from the related Sub-Components list, such as Enterprise Manager. Click to select items that you want to install, and click to clear the check box for the items you do not want to install. For information about each component, select the item, and view the Description box.
   7. In the Start Copying Files dialog box, click Next to complete the installation of the client tools.

To Install Connectivity Only for SQL Server 2000

   1. Insert the Microsoft SQL Server 2000 compact disc into your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), and then select SQL Server 2000 Components.
   2. Select Install Database Server. Setup prepares the SQL Server Installation Wizard. At the Welcome page, click Next.
   3. In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the text box. Click Next.
   4. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.
   5. Follow the directions on the User Information, Software License Agreement and related pages.
   6. In the Installation Definition dialog box, click Connectivity Only, and then click Next.
   7. In the Start Copying Files dialog box, click Next to complete the installation.

"Basic Installation Options"

Registry Category

     Hardware
Hardware and Peripheral Enhancements
   
    Network
Network and Connectivity Enhancements
   
    Security
Security Restrictions and System Policies
    Software
Enhancements for Windows Applications
   
    Tips and Tricks
Windows Tips, Tricks and Shortcuts
   
    Windows
Windows Operating System Enhancements

Backup Registry

Without any backup utilities, tools, software.

Fat 32

Step 1. set any diskette. in explorer , format diskette,

select "Create an MS-DOS startup disk"

Step 2. create folder with any name in C:\Windows for backup
Step 3. create 2 file type batch with any text editor.

save as backup.bat and restore.bat.

content of backup.bat :
Copy C:\Windows\System32\Config\Software
C:\Windows\xx\Software
Copy C:\Windows\System32\Config\Security
C:\Windows\xx\Security
Copy C:\Windows\System32\Config\System
C:\Windows\xx\System
Copy C:\Windows\System32\Config\Default
C:\Windows\xx\Default
Copy C:\Windows\System32\Config\Scan
C:\Windows\xx\Scan
Copy C:\Windows\System32\Config\Sam
C:\Windows\xx\Sam
Copy C:\Windows\System32\Config\Userdiff
C:\Windows\xx\Userdiff


Content of restore.bat :
C:\Windows\xx\Software
Copy C:\Windows\System32\Config\Software
C:\Windows\xx\Security
Copy C:\Windows\System32\Config\Security
C:\Windows\xx\System
Copy C:\Windows\System32\Config\System
C:\Windows\xx\Default
Copy C:\Windows\System32\Config\Default
C:\Windows\xx\Sam
Copy C:\Windows\System32\Config\Sam
C:\Windows\xx\Userdiff
Copy C:\Windows\System32\Config\Userdiff

Step 4. xx = folder that you create.

Restart PC with diskette startup, at command prompt A,
move to drive C (where you install windows)
running backup.bat or restore.bat .

NTFS

Step 1. Install Recovery Console. This program at CD Windows.

klik start > Run,
ketik "X:\I386\Winnt32.exe/cmdcon" x = drive cd/dvd rom

Step 2. Running Recovery Console

masukkan your password administrator.
type any command in backup.bat or restore.bat like step in fat 32
press enter in end of every command.
type exit to out from Recovery Console.

Step 5. (Fat32) / Step 3. (NTFS)

backup NTUser.dat
in
NT = C:\Winnt\profiles\(user name login)
2000 or XP = C:\Documents and settings\(user name login)
Before backup this data, login with another user name.
backup in your create folder in diskette.

Step 6. Restore Registry with same date as NTUser.dat
Step 7. Restore NTUser.dat from diskette and use login another user name.

How to Get MORE content from Mozilla Firefox

How to change user agents so that you can view “Members Only” areas and get access to extra content this is only meant for other browsers (such as Internet Explorer)

There are two ways to change user agents for Firefox
The first way is to download the User Agent switcher and switch your the user agent. Just download this extension. Then to change your user agents all you do is
1. Tools
2. User Agent Switcher
3. Pick the user agent you want
By default it has only 3 different options (Internet Explorer 6, Netscape and Opera), however you can always add more.
For example you might want to add the Googlebot 2.1 user agent… (when you use this user agent you can get into “member only areas” of quite a few sites) You can do this by
1. Tools
2. User Agent Switcher
3. Options
4. Options…
5. Then click on User Agents in the right column
6. Click on Add
Now type in Googlebot 2.1
where it says “Description” and “User Agent“.
The rest can be left empty. Then just click on OK. After that all you need to do is change your user agent and get access to “Member only” stuff on various sites on the net.
If you don’t want to download user agent switcher then you can also do this:
In the adderss bar type in
about:config
Then scroll down till you find (you can also use the filter feature)
“general.useragent.extra.firefox”
Double click on it and type in “Googlebot 2.1“. Now this will change your user agent to the google bot. To change the user agent back to the original one just right click and click Reset.

Rapid share Link Checker Program Software

RapidShare checkers available is Rapidshare Free Account Check, which has been upgrade to version 0.3.0, which is also its final version due limited usage of the tool in future. In the changelog, author has frankly said “this version is only useful for tools, Premium Account Info and Links Check.The availability of free accounts is stopped a year now .. so .. keep w8ing or use this tool for the functions that work. Many automated old functions dont work because there are no free accounts and the .de went to .com
Features of RapidShare Free Account Check

• Timer (in minutes).
• Feature to run in the system tray.
• When the Free accounts registration is open, an alarm with sound or popup or both will warn you.
• Tool to register from inside the program.
• Semi-Automatic Feature to get many accounts at once.
• Tool to get details for your free premium account, such as pass-login-valid until, details.
• Tool to get details for your premium account, such as expiration date, bandwidth remaining and other.

Improvements and enhancements made to RapidShare Free Account Check [ViR-Q] v0.3.0 Finale

• Fixed bug in the main form – that causes program to not respond and terminate.
• Fixed tool premium account info.
• Kernel changes in tool Links Check.
• Some interface changes.

Download RapidShare Free Account Check v0.3.0 Final

Addons Firefox to Hack Timer Rapidshare

1. get a list of available public proxy server easily by searching “proxy server” in search engine such as Google for free proxies or Yahoo!. Choose a proxy server and note down its IP address and port number.
2. Set Your Browser
In Mozilla Firefox, go to Tools -> Options -> Connection Settings. Then select (click) Manual proxy configuration and key in proxy server information. Click OK to continue.
3. Use SwitchProxy extension. 
4. to ensure that all files are still available and hosted on RapidShare servers, and can be free downloaded for free. Check Link Rapid Share (official),
5. SkipScreen is a free Firefox add-on that skips the clicking and waiting on sites like RapidShare, Megaupload, Mediafire, zShare, and more! Never download music without it.
Download :
Addon Skip Screen (Official)
Skip Screen (Firefox Site)
6.  Use Java Script Code of Grease Mongkey.
Right Click of  the following site :
Grease Mongkey (Firefox site)
Rapid Share Link Checker (Grease Mongkey Script Code)

Cleaning Your Harddisk

>>Clean when you double click ( semi-automatic ) :
1. create file *.bat (batch ).
- open notepad ( click start > run, type notepad ),
- save file, type any file name, type " .bat " in end of file name.
- then select file types [ All files ].

2. edit the file (right click, click edit ) that was created,
type this :
set temp=c:\windows\temp
set tmp=c:\windows\temp
echo Deleting All Temporary Files
deltree/y c:\windows\cookies\*.*
deltree/y c:\windows\history\*.*
deltree/y c:\windows\recent\*.*
deltree/y c:\windows\tempor~1\*.*
deltree/y c:\windows\temp\*.*

3. Save the file, double click.

>>Clean when windows start
1. edit autoexec.bat or win.ini
2. Add this line :
set temp=c:\windows\temp
set tmp=c:\windows\temp
echo Deleting All Temporary Files
deltree/y c:\windows\cookies\*.*
deltree/y c:\windows\history\*.*
deltree/y c:\windows\recent\*.*
deltree/y c:\windows\tempor~1\*.*
deltree/y c:\windows\temp\*.*
3. to look the result, rebooting your windows.

Create File List at Command Prompt

1. Click Start > Run , Type cmd Press Enter or Click OK.
2. Change Directory for save file, example :
cd atau chdir /d E:\myfolder\ ,
3. Then add " > file-name.txt " at the end of dir or tree command.
example : tree x:/f/a > file_list.txt, x: is drive to save your file list.

One YM ( Yahoo! Messenger ) Multiple Log In

Wanna sign in at YM with many Yahoo! ID, follow this trick :

1. Click Start > Run, or Press Windows

2. go to : HKEY_CURRENT_USER\Software\Yahoo\pager

3. Right Click , select New > DWORD Value, type " Plural ", Click OK.

4. Double Click this new value, type 1 in Value data, Press Enter or Click OK.

5. Sign in at Yahoo Messenger.

other trick :
- Remove Advert in Yahoo Messenger
- Change Your Yahoo Messenger (YM) Skin
- Yahoo Multiple Login

Change YM ( Yahoo Messenger ) Skin

Yahoo Messenger 8 has three (3) standard color skin : Indigo ( purple ), Maverick ( blue ), Classic ( Windows based ).

Wanna change your yahoo skin, try some of this trick :
1. go to http://messenger.yahoo.com/feat_skins.php
or http://www.skinbase.org/ or http://www.customize.org/
or http://www.lotofskins.com/
2. download any skin that you want to use,
commonly the file in zip or exe extensions.
3. open Yahoo! Messenger, sign in,
click Messenger > Change Skin ...

other trick :
- Remove Advert in Yahoo Messenger
- Yahoo Multiple Login
- Change Your Yahoo Messenger (YM) Skin