Instalasi SQL Server 2000

Sebelum menginstall SQL server 2000, berikut ini spesifikasi minimum untuk komputer yang akan diinstall SQL server 2000

Processor 166-megahertz (MHz) or higher processor

Operating System

•SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:

• Windows Server 2003 R2
• Windows Server 2003, Standard Edition1
• Windows Server 2003, Enterprise Edition2
• Windows Server 2003, Datacenter Edition3
• Windows® 2000 Server
• Windows 2000 Advanced Server
• Windows 2000 Datacenter Server

SQL Server 2000 Evaluation Edition and Developer Edition and Workgroup Edition can run on the following operating systems:

• Operating systems listed above for Enterprise and Standard Editions
• Windows XP Professional
• Windows XP Home Edition
• Windows 2000 Professional

SQL Server 2000 Personal Edition4 and SQL Server 2000 Desktop Engine (MSDE) can run on the following operating systems:

• Operating systems listed above for Enterprise, Standard, Evaluation, and Developer Editions
• Windows Server 2003, Web Edition5 (MSDE only)
• Windows 98
• Windows Millennium Edition (Windows Me)

Memory Enterprise Edition: 64 megabytes (MB) of RAM; 128 MB recommended
•Standard Edition: 64 MB
•Workgroup Edition: 64 MB
•Evaluation Edition: 64 MB; 128 MB recommended
•Developer Edition: 64 MB
•Personal Edition: 128 MB for Windows XP; 64 MB for Windows 2000; 32 MB for other operating systems
•MSDE: 128 MB for Windows XP; 64 MB for Windows 2000; 32 MB for other operating systems

Harddisk

Enterprise, Standard, Workgroup, Evaluation, Developer, and Personal Editions require:

• 95–270 MB of available hard disk space for the server; 250 MB for a typical installation.
• 50 MB of available hard disk space for a minimum installation of Analysis Services; 130 MB for a typical installation.
• 80 MB of available hard disk space for English Query.
MSDE requires 44 MB of available hard disk space.
Drive CD-ROM drive
Display VGA or higher-resolution monitor
Other Device • Microsoft Internet Explorer version 5.0 or later
• Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000, and Windows XP have built-in network software. Additional network software is required if you are using Banyan VINES or AppleTalk ADSP. Novell NetWare IPX/SPX client support is provided by the NWLink protocol of Windows-based networking.
Client Support:
• Windows 958, Windows 98, Windows Me, Windows NT Workstation 4.0, Windows 2000 Professional, Windows XP Professional, and Windows XP Home Edition are supported.
• UNIX, Apple Macintosh, and OS/2 require Open Database Connectivity (ODBC) client software from a non-Microsoft vendor.

menginstall SQL server pertama-tama masukkan dulu CD master SQL atau buka file master SQL dari flash disk.
1. Klik dua kali Autorun atau klik kanan >> Open

Autorun
2.Setelah autorun dijalankan maka akan muncul tampilan seperti dibawah ini


Pilih SQL server 2000 Component
3.Maka akan muncul tampilan seperti dibawah ini



Pilih Install database server
4.Setelah Install database server di klik akan munsul SQL server Installation wizard


Klik Next > pada Instalation wizard
5.Selanjutnya akan muncul pilihan seperti berikut


Pilih Local komputer untuk menginstall SQL server di komputer anda
6.Akan ada pilihan
> “Create a new instant of sql server, or install client tools”
> “Upgrade, remove, or add component to an exciting intance of SQL server”
> “Advanced option”

Pilih “Create a new instant of sql server, or install client tools” untuk mengintall SQl server yang baru
Lalu klik next >
7. Masukkan Nama dan nama perusahaan anda

Lalu klik Next >
8. Lalu akan muncul software license aggrement

Klik Yes
9.Selanjutnya akan muncul Definition Instalation

Pilih sesuai kebutuhan anda
jika anda ingin menginstall server sekaligus client SQL server 2000 silahkan pilih “Server and Client tools”,
namun jika saat instalasi SQL server mengalami Error seperti gambar di bawah ini

jika terjadi error seperti gambar di atas sebaiknya anda memilih client tools only, dan menginstall MSDE ( ) melalui command promt caranya :
Jalankan file setup MSDE melalui Command promt
KLik start >> Run lalu ketikkan Cmd
Sebagai contoh bila file master SQL server anda berada di directory D:\master\SQL2ksp4\MSDE

Maka di command promt Tuliskan seperti ini
1. ketikkan D: lalu tekan enter

2. ketikkan cd master lalu tekan enter

3.selanjutnya ketikan cd sql2ksp4
maksudnya adalah membuka File folder bernama sql2ksp4 yang merupakan nama folder master sql saya
4. setelah masuk ke folder master sql anda ketikan cd MSDE untuk membuka folder MSDE dimana terdapat setup MSDE
5. Dan untuk menjalankan setup MSDE ketikkan perintah seperti berikut :
setup sapwd=”(passwordnya terserah anda)” securitymode=sql disablednetworkprotocols=0
lalu tekan enter, sebagai contoh saya ingin passwordnya Krizz maka perintah yang anda ketikkan adalah sebagai berikut
setup sapwd=”Krizz” securitymode=sql disablednetworkprotocols=0
Setelah berhasil menginstall desktop engine maka anda telah mempunyai server sendiri.
Dan setelah SQL server selesai di Install jangan Lupa untuk merestart komputer anda.

Install XP ke HardDisk External

Creating the Windows XP Boot Image
1.
Step 1

Set your BIOS so that USB booting is enabled. (Your BIOS must support boot from USB.) Connect the USB external hard drive directly to your computer.
2.
Step 2

Make an ISO image (an .iso file is an archive disk image of an optical disk) from the Windows XP CD-ROM using your preferred software. Save to your hard drive.
3.
Step 3

Open the ISO file you just created. Navigate to the I386 folder, and select the following files:
TXTSETUP.SIF, DOSNET.INF, USB.IN_, USBPORT.IN_, and USBSTOR.IN_.
Extract the files and put them into a folder to work with.
4.
Step 4

Open a command prompt and use Cab SDK to extract the contents of the .IN_ files; Cab SDK is a Microsoft compression and decompression program available as an .exe file in your Windows directory. Each of the .IN_ files contains exactly one .inf file. An example command line would be: "cabarc x USBSTOR.IN_" . You should end up with three new files in the folder, called usb.inf, usbport.inf and usbstor.inf. Delete the .IN_ files.
5.
Step 5

Open the files using a simple text editor such as Notepad. Edit them according to the section below titled "Editing Files."
6.
Step 6

Open the previously created ISO file and delete the files you extracted earlier. Replace them with the newly modified files.
7.
Step 7

Save the ISO files and burn them to a CD using the burning software of your choice.
8.
Step 8

Insert the CD you created and restart the computer. Make sure it is set to boot from CD. Most computers will do this automatically, but if not, hit F8 on startup to choose boot options. When asked, choose the external USB hard drive to install WIndows XP.
Editing Files
9.
Step 1

Open TXTSETUP.SIF and move the following entries from [InputDevicesSupport.Load] to the [BootBusExtenders.Load]:
usbehci = usbehci.sys
usbohci = usbohci.sys
usbuhci = usbuhci.sys
usbhub = usbhub.sys
usbstor = usbstor.sys
10.
Step 2

Move the following entries from [InputDevicesSupport] to [BootBusExtenders]:
usbehci = "Erweiterter Hostcontroller",files.usbehci,usbehci
usbohci = "Open Hostcontroller",files.usbohci,usbohci
usbuhci = "Universeller Hostcontroller",files.usbuhci,usbuhci
usbhub = "Standard-USB-Hubtreiber",files.usbhub,usbhub
usbstor = "USB-Speicherklassentreiber",files.usbstor,usbstor
11.
Step 3

Insert the following in the [HiveInfs.Fresh] section:
AddReg = hivedef.inf,AddReg
AddReg = hivesys.inf,AddReg
AddReg = hivesft.inf,AddReg
AddReg = hivecls.inf,AddReg
AddReg = hiveusd.inf,AddReg
AddReg = dmreg.inf,DM.AddReg
AddReg = usbboot.inf,usbservices

Insert the following commands into the [SourceDisksFiles] section:

[SourceDisksFiles]
usbboot.inf = 1,,,,,,_x,3,,3
bootvid.dll = 1,,,,,,3_,2,0,0,,1,2
kdcom.dll = 1,,,,,,3_,2,0,0,,1,2
12.
Step 4

Open DOSNET.INF and change the second [Files] section to look like this:
[Files]
d1,usbboot.inf
d1,_default.pif
d1,12520437.cpx
d1,12520850.cpx
13.
Step 5

Open USB.INF and change lines in the [StandardHub.AddService] and [CommonClassParent.AddService] sections to look like this:

[StandardHub.AddService]
DisplayName = %StandardHub.SvcDesc%
ServiceType = 1 ; SERVICE_KERNEL_DRIVER
StartType = 0 ; SERVICE_DEMAND_START
ErrorControl = 1 ; SERVICE_ERROR_NORMAL
ServiceBinary = %12%\usbhub.sys
LoadOrderGroup = Boot Bus Extender

[CommonClassParent.AddService]
DisplayName = %GenericParent.SvcDesc%
ServiceType = 1 ; SERVICE_KERNEL_DRIVER
StartType = 0 ; SERVICE_DEMAND_START
ErrorControl = 1 ; SERVICE_ERROR_NORMAL
ServiceBinary = %12%\usbccgp.sys
LoadOrderGroup = Boot Bus Extender
14.
Step 6

Open usbport.inf and change lines in the [EHCI.AddService], [OHCI.AddService] , [UHCI.AddService] and [ROOTHUB.AddService] sections to look like this:

[EHCI.AddService]
DisplayName = %EHCIMP.SvcDesc%
ServiceType = 1 ; SERVICE_KERNEL_DRIVER
StartType = 0 ; SERVICE_DEMAND_START
ErrorControl = 1 ; SERVICE_ERROR_NORMAL
ServiceBinary = %12%\usbehci.sys
LoadOrderGroup = Boot Bus Extender

[OHCI.AddService]
DisplayName = %OHCIMP.SvcDesc%
ServiceType = 1 ; SERVICE_KERNEL_DRIVER
StartType = 0 ; SERVICE_DEMAND_START
ErrorControl = 1 ; SERVICE_ERROR_NORMAL
ServiceBinary = %12%\usbohci.sys
LoadOrderGroup = Boot Bus Extender

[UHCI.AddService]
DisplayName = %UHCIMP.SvcDesc%
ServiceType = 1 ; SERVICE_KERNEL_DRIVER
StartType = 0 ; SERVICE_DEMAND_START
ErrorControl = 1 ; SERVICE_ERROR_NORMAL
ServiceBinary = %12%\usbuhci.sys
LoadOrderGroup = Boot Bus Extender

[ROOTHUB.AddService]
DisplayName = %ROOTHUB.SvcDesc%
ServiceType = 1 ; SERVICE_KERNEL_DRIVER
StartType = 0 ; SERVICE_DEMAND_START
ErrorControl = 1 ; SERVICE_ERROR_NORMAL
ServiceBinary = %12%\usbhub.sys
LoadOrderGroup = Boot Bus Extender
15.
Step 7

Open usbstore.inf and change lines in the [USBSTOR.AddService] section to look like this:

[USBSTOR.AddService]
DisplayName = %USBSTOR.SvcDesc%
ServiceType = 1
StartType = 0
Tag = 3
ErrorControl = 1
ServiceBinary = %12%\USBSTOR.SYS
LoadOrderGroup = Boot Bus Extender
16.
Step 8

Create a new file called USBBOOT.INF in the same directory as the other modified files, and paste the following content into it:
[usbservices]

HKLM,"SYSTEM\CurrentControlSet\Services\USBSTOR","DisplayName",0x00000000,"USB Mass Storage Driver"
HKLM,"SYSTEM\CurrentControlSet\Services\USBSTOR","ErrorControl",0x00010001,1
HKLM,"SYSTEM\CurrentControlSet\Services\USBSTOR","Group",0x00000000,"System Reserved"
HKLM,"SYSTEM\CurrentControlSet\Services\USBSTOR","ImagePath",0x00020000,"system32\DRIVERS\USBSTOR.SYS"
HKLM,"SYSTEM\CurrentControlSet\Services\USBSTOR","Start",0x00010001,0
HKLM,"SYSTEM\CurrentControlSet\Services\USBSTOR","Type",0x00010001,1

HKLM,"SYSTEM\CurrentControlSet\Services\usbehci","DisplayName",0x00000000,"USB 2.0 Enhanced Host Controller Miniport Driver"
HKLM,"SYSTEM\CurrentControlSet\Services\usbehci","ErrorControl",0x00010001,1
HKLM,"SYSTEM\CurrentControlSet\Services\usbehci","Group",0x00000000,"System Reserved"
HKLM,"SYSTEM\CurrentControlSet\Services\usbehci","ImagePath",0x00020000,"system32\DRIVERS\usbehci.sys"
HKLM,"SYSTEM\CurrentControlSet\Services\usbehci","Start",0x00010001,0
HKLM,"SYSTEM\CurrentControlSet\Services\usbehci","Type",0x00010001,1

HKLM,"SYSTEM\CurrentControlSet\Services\usbhub","DisplayName",0x00000000,"USB2 Enabled Hub"
HKLM,"SYSTEM\CurrentControlSet\Services\usbhub","ErrorControl",0x00010001,1
HKLM,"SYSTEM\CurrentControlSet\Services\usbhub","Group",0x00000000,"System Reserved"
HKLM,"SYSTEM\CurrentControlSet\Services\usbhub","ImagePath",0x00020000,"system32\DRIVERS\usbhub.sys"
HKLM,"SYSTEM\CurrentControlSet\Services\usbhub","Start",0x00010001,0
HKLM,"SYSTEM\CurrentControlSet\Services\usbhub","Type",0x00010001,1

HKLM,"SYSTEM\CurrentControlSet\Services\usbuhci","DisplayName",0x00000000,"Microsoft USB Universal Host Controller Miniport Driver"
HKLM,"SYSTEM\CurrentControlSet\Services\usbuhci","ErrorControl",0x00010001,1
HKLM,"SYSTEM\CurrentControlSet\Services\usbuhci","Group",0x00000000,"System Reserved"
HKLM,"SYSTEM\CurrentControlSet\Services\usbuhci","ImagePath",0x00020000,"system32\DRIVERS\usbuhci.sys"
HKLM,"SYSTEM\CurrentControlSet\Services\usbuhci","Start",0x00010001,0
HKLM,"SYSTEM\CurrentControlSet\Services\usbuhci","Type",0x00010001,1

HKLM,"SYSTEM\CurrentControlSet\Services\usbohci","DisplayName",0x00000000,"Microsoft USB Open Host Controller Miniport Driver"
HKLM,"SYSTEM\CurrentControlSet\Services\usbohci","ErrorControl",0x00010001,1
HKLM,"SYSTEM\CurrentControlSet\Services\usbohci","Group",0x00000000,"System Reserved"
HKLM,"SYSTEM\CurrentControlSet\Services\usbohci","ImagePath",0x00020000,"system32\DRIVERS\usbohci.sys"
HKLM,"SYSTEM\CurrentControlSet\Services\usbohci","Start",0x00010001,0
HKLM,"SYSTEM\CurrentControlSet\Services\usbohci","Type",0x00010001,1
17.
Step 9

Delete your original extracted .IN_ files. Open the command prompt and navigate to the folder with your changed files. Execute these commands to repack the files:
cabarc n USB.IN_ usb.inf
cabarc n USBPORT.IN_ usbport.inf
cabarc n USBSTOR.IN_ usbstor.inf

The three IN_ files should now exist again. Return to Step 6 above to complete.

Ads by Google
Media Center Guide
Build your own home theater media center quickly and easily!
www.media-center-guide.com

Top External Hard Drives
Compare Prices & Save - Shop Smart! Compare 100's of External Drives.
PCWorld.com

Online Hard Drive
1GB Free - Secure Online Storage. Consumer Guide 'Best Buy' Web Site!
FilesAnywhere.com

USB Disk On Module
Hi-Speed Solid State Hard Disk USB for Embedded Systems. USB DOM
www.MemoryDepot.com/USBDisk

Kuliah Pengganti Aplikom Sistem Informasi

Tempat : T001
Pukul :08.00
Hari : Selasa
Tanggal : 05 - 01 - 2010

Tema : Persentasi tugas akhir (Membuat Tutorial)