How to install SQL Server 2005 under Windows 7

This article will introduce you how to install SQL Server 2005 under Windows 7, I believe that through this article, you can let us know the installation process.

First, configure IIS

Go to the Control Panel, open IIS Features, click the plus sign on the left, open the details, we hook the following components:

1: Web Managerment Tools\\IIS 6 Management Compatibility\\IIS6 WMI Compatibility

2: Web Managerment Tools\\IIS 6 Management Compatibility\\IIS6 Metabase and IIS 6 Configuration Compatibility

3: World Wide Web Services\\Application Development Features \\Asp.net

4: World Wide Web Services\\Common Http Features\\Http Redirection

5: World Wide Web Services\\Security\\Windows Authentication

Second, installation standards Version of SQL Server 2005

Follow the prompts to install

Third, install SQL Server 2005 SP3

The last step to set system account permissions, you need to first close the sqlserver in the task manager The process, then to the step before opening the dos window, you need to manually start the sqlserver service.

IV. Enable SQL Server Browser Service

Click “Start”, then point to “Programs>,“Microsoft SQL Server 2005” and “Configuration Tools”, Then click “SQL Server Peripheral Application Configurator”.

On the "SQL Server 2005 Perimeter App Configurator" page, click "Services and Connected Perimeter App Configurator".

On the "Services and Connected Peripheral Application Configurator" page, click “SQL Server Browser", in “Startup Type", click “Auto” Options, then Single Click "Apply".

To open the Windows Firewall, click “Start”, click “Run", type firewall.cpl, and then click “OK”.

V. Creating Exceptions for SQL Server 2005 in Windows Firewall

To create exceptions for SQL Server 2005 in Windows Firewall, perform the following steps:

Creating an Exception for the SQL Server Browser Service in Windows Firewall

To create an exception for the SQL Server Browser service in Windows Firewall, perform the following steps:

1. In the Windows Firewall, single Click the "Exceptions" tab, then click “Add Programs”.

2. In the "Add Programs" window, click “Browse”.

3. Click the C:\\Program Files\\Microsoft SQL Server\\90\\Shared\\sqlbrowser.exe executable, click “Open”, then click “OK”.

VII. Configuring SQLServer2005 Remote Connection

Step 1: SQL Server Configuration Manager -> SQL Server 2005 Services Set SQL Server Browser to running,

If there is no Enable Right-click Properties -> Service -> StartMode = Auotomatic

Note that you must also open the SQL Server Browser service. Step 2: SQL Server 2005 Network Configuration -> TCPs/IP under Protocols for SQLXPRESS And named pipes Step 3: Use TCP/IP and named pipes under SQL Native Client Configuration 2. Log in to mixed mode:

Open manage manager-> Connect to windows and enter database-> Right click on your data server -> Properties -> Security> Select Sql server and windows Authentication

3. Create a new SQL server username and password:

manage manager-> ; security -> Right click on logins->new login...-> Check sql server authentication -> set login name and password (confirm password) and default data

best to remove the & ldquo; enforce password expiration & rdquo; in front of a small hook, otherwise each landing to change the password.

Note: Be sure to select the database corresponding to the user in the User Mapping page (even if the default database has been selected before), otherwise it will not be logged in.

Need to modify the database, you must assign the db_Owner role

4, restart the server

Although many articles on the Internet say that only need to restart the SQL service, but verified, You have to restart the machine.

In order to get things to work. You might need to completely reboot the server machine after making the changes. There have been reports (thanks PC) that starting and stopping the SQL Server and Browser software is not enough.

5. Test with SQL Server Configuration Manager

Note: Server Name must be Serever\\SQLEXPRESS

Also in Options -> Network Select TCP/IP in protocol to log in successfully

In the Windows Firewall, click the "Exceptions" tab, then click “Add Programs”.

In the "Add Programs" window, click “Browse”.

Click the C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Binn\\sqlservr.exe executable, click “Open”, and then click “OK”.

Note: The above path may vary depending on where SQL Server 2005 is installed. MSSQL.1 This placeholder represents the instance ID you obtained in step 3 of the previous procedure.

Repeat steps 1 through 3 for each instance of SQL Server 2005 for which you need to create an exception.