Installation diagram:
Install. NET
There's something wrong, can't do that, then go to Server Manager to install
Open the Feature Setup Wizard and select. NET, which requires installation. Other roles required by net
Start installation
IIS role, default OK, and we don't want IIS
Start installation
Installation is complete.
Run the SQL Server 2008 installation again
Click Install-New SQL Server Standalone installation, if we have a failover cluster ready, then we can create a failover cluster SQL
General Check
Select version, or enter the key to automatically identify the version
Supporting file Installation
Installation complete starts checking itself
Two warnings, one is. NET warning, said no network delay, or need to download files
One number to open the port, ignore it, open it later.
Select installed features, SQL database and Administrative Tools
Select an instance
Drive Check
Select a service account and select a Local System account
Authentication mode: Both SQL and local mode, enter password, add Administrator, can add local group or current user
Select report Microsoft Options
Run check
Information Preview Confirmation
To start a formal installation.
Installation Complete
Click Close to finish
SQL2008 Open the Smse administration tool from the Start menu open the Administrative Tools
New database option actually has the boot PS option, integrated into the sql2008 the new database page has abandoned the sql7.0, only compatible with SQL Server 2000, the other is nothing big change
After starting PS
Create a new inbound rule in the firewall, port selection 1433
Setup is complete and can be done on the client.
SQL Server R2 installation illustrated tutorial
