SQL Express = for DCS Softwares

Install=20 Microsoft SQL Server 2005 Express Edition (SQL Server=20 Express):

This topic describes how to install Microsoft = SQL Server=20 2005 Express Edition (SQL Server Express). It also identifies the = setup=20 options that differ from Microsoft SQL Server 2005. For local=20 installations, you must run Setup as an administrator.

Click here to=20 Installation Procedure.

How to=20 setup server system?

Downloads<= /DIV>

Before you=20 install Microsoft SQL Server 2005 Express Edition (SQL Server = Express),=20 make sure that you install the .NET Framework-2 (or higher), = associated=20 with SQL Server Express..=20

Hardware & Software = Requirements=20 :

Prerequesite Operating=20 System: (System must be installed any one of the OS listed)=20

Windows Server 2003 SP1
Windows Server 2003 Enterprise Edition = SP1
Windows Server 2003 Datacenter Edition = SP1
Windows Small Business Server 2003 Standard = Edition=20 SP1
Windows Small Business Server 2003 Premium = Edition=20 SP1
Windows XP Professional SP2
Windows XP Home Edition SP2
Windows XP Tablet Edition SP2
Windows XP Media Edition SP2
Windows 2000 Professional Edition SP4
Windows 2000 Server Edition SP4
Windows 2000 Advanced Edition SP4
Windows 2000 Datacenter Server Edition = SP4
Virtual PC
Virtual Server
Windows Vista Home Basic=B2
Windows Vista Home Premium=B2
Windows Vista Business=B2
Windows Vista Enterprise=B2
Windows Vista = Ultimate=B2

Prerequesite Application=20 Softwares:

Microsoft .NET Framework 2.0 or above=20
Windows Installer 3.1 or above =

Prerequesite = Hardware:

RAM Minimum: 192 MB. Recommended: 512 MB or higher
Hard Disk space 600 MB free space
Processor Pentium III Compatible or higher. CPU Speed 500 = MHz=20 (Minimum). Recommended: 1 GHz or higher =

Installation = Procedure

Step 1:

To begin installation, click = SQL Express button from Soft Biz = Installer.

Note: SQL Server=20 Express is available as a self-extracting executable file = (sqlexpr.exe)=20 along with the Inventory Biz CD.

Step 2:

The End User License Agreement appears in th = Microsoft=20 SQL Server 2005 Setup Wizard. Check the 'I accept=20 the licensing terms and conditions'. Then Click Next.

Step 3:

The Installing = Prerequesites page=20 appears in the setup wizard. Click Install.

It will Install the = software=20 components required for SQL Server Setup. After the Installation = Click=20 the Next Button,=20 which will appear in the Same Window.

Step 4:

Welcome to SQL Sever = 2005 appears=20 in the setup wizard. Click the Next = button.=20

Step 5:

The System Configuration Check page appears, = which will=20 check the system configuration. After the successful completion of = checking process, Click the Next = button.=20

Step = 6:

The Registration Information = appears in the=20 setup wizard.

Fill the Name field with your=20 Name.=20
Fill the Company field with your=20 company name.=20
Uncheck the Hide Advanced=20 configuration options.=20
Then Click = Next button.

Step 7:

Feture Selection page = appears in the=20 setup wizard. Select Next = button to continue installation in default = location.=20 (Advanced user can select the desired Installation path)=20

Step 8:

Instance = Name Page=20 appears in the wizard.

Select Named = instance (it=20 will be already selected in default condition) and there will = also the=20 text 'SQLExpress' in the text box.=20
Click Next = button.=20

Step 9:

Service Account Page appears in the wizard.

Select the Local system from pull down menu. =
Check both the SQL = Server=20 and SQL Browser in the Start services at the end of setup area.=20
Click Next = button.=20

Step = 10:

Authentication Mode Page = appears in the=20 wizard.

Select the 'Mixed = Mode=20 (Windows Authentication and SQL Server = Authentication)'=20
Set the password as 'changeme' (in small letter) in = the 'Enter Password' area.=20
Enter the password 'changeme' in the (in small = letter) in the=20 'Confirm Password' area.=20
Click Next = Button.=20

Step = 11:

Collation Setting Page appears = in the=20 wizard.

The SQL=20 Collations (used for compatiblity with previous versions of SQL=20 Server) selected in default condition.=20
'The Dictionery order,=20 case-insensitive, for use with 1252 Charecter Set.' also = selected=20 defaultly.=20
Click Next = button.=20

Step = 12:

Configuration Options Page = appears in the=20 wizard.

Check 'Enable User=20 Instances'.=20
Click Next = button.=20

Step = 13:

Error and Usage Report Settings = appears in=20 the setup wizard.

Leave both the checkboxes blank. (Advanced = user can=20 check the fields, if they need it).=20
Click Next = Button.

Step = 14:

Ready to Install Page = appears in the=20 wizard. Click Install Button. It will Install SQL Server 2005 in your = system.=20

Step = 15:

The Setup Progress page appears in the = wizard, and=20 it shows the components configuration . After=20 complete the configuration, click the = Next button.=20

Step=20 16:

Completing Microsoft SQL = Server 2005=20 Setup page appears in the wizard. Click the=20 Finish button = to complete=20 the installation and close the wizard.

It is now ready to use = the SQL Server=20 as a Client System.

Note: To use your system as a Server system, please = follow the=20 following steps.

Go To=20 Top

Setup a Server System after Installing SQL=20 Express:

Step 1:

After = Installing SQL=20 Express in server System. Load SQL Server Configuration Manager. = (By=20 Clicking Start>>Programs>>Microsoft SQL = Server=20 2005>>Configuration Tools>>SQL Server = Configuration=20 Manager.)

Step 2:

There appears = SQL Server Configuration Manager Window.

From the tree line stucture Double=20 Click SQL Server 2005 Network=20 Configuration.=20
Then Click the Protocols for SQL EXPRESS. In = the Right Side of the window we can see the = Protocols and respective Status.=20
Set the Status = of Shared Memory, Named=20 Pipes, TCP/IP are Enabled by Right = Click=20 on the respective Prtotocol type and click 'Enabled'. Then close the window.=20

Windows=20 Installer	.Net=20 Framework	MSDE=20 2000	SQ= L=20 EXPRESS
Go To=20 = Top