Install and configure SQL Server WIN7 Express Edition (compact version) under the _mssql2005

After a long afternoon, I finally put the SQL Server, the Express Edition installed, in view of the various problems, so write down the process.

First, download two files:

①sql Server Edition Express

Download Address: http://files.jb51.net/file_images/article/201501/2015010313472645.aspx

②sqlserver2005_ssmsee.msi

Download Address: http://files.jb51.net/file_images/article/201501/2015010313472746.aspx

Before installing, configure IIS first before installing Win7 users:

① Open the Control Panel and select "Programs"

Check the Internet service information in the box and expand the option by selecting:

The final point is OK.

Start the Setup program, turn on your computer, and locate the SQL Server Express Edition installation package that you just downloaded to select the installation. installation prompts for compatibility issues, regardless of whether he is directly ignored.

(Installation process slightly)

And then find just download the Sqlserver2005_ssmsee.msi, this time to pay attention to, double-click the program to install, will be reported halfway to the error of 29508, installation is not.

But it doesn't matter, it's just a matter of authority.

WORKAROUND: 1: Create a new Notepad, enter "msiexec/i installation file path" and save As. cmd format. For example: msiexec/i G:\SQLServer 2005\sqlserver2005_ssmsee_x64.msi
2: Right click to create a good. cmd file, select "Run as Administrator" to start performing sqlserver2005_ssmsee installation.

OK, here, the installation process is over.

Configuration:

Start-All Programs-Microsoft SQL server 2005-sql server Management Studio Express

The first entry must be entered with Windows authentication.

Click "New Query" in the upper right corner of the software, then enter the statement to create the database, click "Execute",

Error found: CREATE database permission was denied in db ' master '.

And in many operations, you are prompted for information that does not have permission.

Solution: On the internet to see a variety of ways, and then think of a simple one, is running SQL Server Management Studio Express when the mouse right click "Run as Administrator", the error disappears.

To configure the SQL Server browser connection again:

Start-All Programs-Microsoft SQL Server 2005-Configuration tool-sql Server perimeter configurator (same right button "Run as Administrator")

-Service and connection Perimeter configurator-sql Server Browser, change the startup type to Automatic. Click Apply.

The following starts configuring how to log on using the SA name

To verify the sa login:

We create a new text file on the desktop, the file name is testsql.udl, double-click the file to open the Data Link Properties dialog box, click the Provider tab, as shown below:

(data source, that is, machine name \ Instance name, should be modified in personal circumstances!) ）

You can then log on with SA when you start SQL Server Management Studio Express, and you can use this username and password when connecting to the database with JDBC.

To configure SQLServer2005 remote connections:

Step one: Start-All Programs-Microsoft SQL Server 2005-Configuration Tool-sql Server Configuration Manager

-> SQL Server Browser to set SQL Server running

Step two: SQL Server network Configuration-> protocols for sqlxpress using both TCP/IP and Named pipes

Step three: SQL Native Client Configuration uses both TCP/IP and Named pipes