BLOG: MS SQL Server 2005 Express Edition Requirement:

MS SQL Server 2005 Express Edition Requirement:

Installer SQLEXPR.exe 54M free space.

Require 600MB free space.

- We recommend against running SQL Server Express on a domain controller. it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service

- 2003 Server SP 1 (MSI-3.0)

- Frameworks .NET 2.0 (You could go to %WINDIR%\Microsoft.NET\Framework\ to verify your version).

- To enable the Windows CSP service on Windows Server 2003. (Cryptographic Service Provider)

- MSDTC Is Fully Enabled on Windows

In Control Panel, open Administrative Tools, and then double-click Component Services.

In the left pane of Console Root, click Component Services, and then expand Computers.

Right-click My Computer, and then click Properties.

On the MSDTC tab, click Security Configuration.

Under Security Settings, select all of the check boxes.

Verify that the DTC Logon Account name is set to NT AUTHORITY\NetworkService.

- It install the SQL Native Client and Setup Support Files, MSXML6, SQL VSS Writer, SQL Server Database Services;, Books online.

- Choose Named Instance “SQLExpress”

- Service Account “Local System” probably no network access.

Specifies a domain user account that uses Windows Authentication to set up and connect to SQL Server. Microsoft recommends using a domain user account with minimal rights for the SQL Server service, as the SQL Server service does not require administrator account privileges. The SQL Server Agent account must have administrator privileges if you create CmdExec and ActiveScript jobs that belong to someone other than a SQL Server administrator, or if you use the AutoRestart feature. If the above features are requirements in your environment, consider using separate service accounts for the SQL Server and SQL Server Agent services.

- sa has to be protected with strong password “Avocent456”

- You have to use SQL Server 2005 Surface Area Configuration to open the connection.
- You also need to go to the SQL Server Configuration Manager to set the TCP port to 1433 instead of other value.
-

After you install SQL Server Express, use the following command to connect to SQL Server Express by using the command prompt:

$sqlcmd -S Server\Instance (Kira\SQLExpress)

You could also upgrade from Microsoft SQL Server 2000 Desktop Edition to Express Edition.

Tony