HOWTO: Installing SQL 2008 Express x64 on Windows 2008 x64 for use with Provisioning Server 5.1
Not wanting to install SQL 2005 Express x32 on my Windows 2008 x64 server, I documented the steps I took to get everything up and running. Hope you find them useful :)
SQL 2008 Express Install
- Download and install Windows Installer 4.5: http://tinyurl.com/4z4uvt. A reboot will be required.
- Download and install ‘Microsoft® SQL Server 2008 Express Edition with Service Pack 1’ x64: http://tinyurl.com/r2xhxl
- Once the install launches, run the System Configuration Checker. Ensure there are no errors.
- Click on the ‘Installation’ link in the left column.
- Select “New SQL Server stand-alone installation or add features to an existing installation”
- Following the default support files installation, the ‘Feature Selection’ portion of the install will appear. Check the “Database Engine Services” under the “Instance Features”.
- Within the Server Configuration, select the “Use the same account for all SQL Server services”, select the Local System account.
- Set the SQL Server Browser service startup type to ‘Automatic’
- Within the Database Engine Configuration, use Windows Authentication, add whatever users/groups you want to be SQL admins
- If you run into any issues, make sure you check the configuration checkers that occur during the install for any warnings or error messages.
- Reboot the server when installation completes.
- Run the SQL Server Configuration Manager
- Under the ‘SQL Server Network Configuration’ Node, expand the tree and double click on the ‘Protocols for SQLEXPRESS’
- Enable the TCP/IP protocol
- *If you are going to connect to this SQL server from different server, double click on the TCP/IP protocol to view the properties. Under the ‘IP Addresses’ folder tab, enable each IP you want to allow a connection from on the network.
- Under the ‘SQL Server Services’ node, restart the SQL Server and SQL Server Browser service.
PVS 5.1 x64 Install
- From a command prompt that has Administrator privileges, enter: servermanagercmd -install NET-Framework
- Run the PVS_Server_x64 install program and select custom install
- Select the components that are required. Keep in mind that if a component is installed, doesn’t mean it’s set to run as a service (DHCP, TFTP, PXE, etc.). I usually install all components and configure what I need during the configuration process.
- Once the install in complete, the Configuration Wizard will launch
