- Windows Server 2008 R2 Enterprise
- Service Pack 1
- 64-bit operating system
- Different download address according to service PAKC version
- Make sure the disk has more than 10GB of free space
1) Download SQL Server 2008 R2 sp1–express Edition
1-1. Visit the following download address.
- SP1 Download Address: http://www.microsoft.com/zh-tw/download/details.aspx?id=26729
- SP2 Download Address: http://www.microsoft.com/zh-tw/download/details.aspx?id=30438
1-3. After choosing "sqlexpradv_x64_chs.exe", click "next".
1-4. Tick "No, thank You", click "next".
1-5. Click "Save" and save to any directory.
2 Install SQL Server 2008 R2 sp1–express Edition
2-1. After double-clicking the "sqlexpradv_x64_chs.exe", click "Run".
2-2. Extract the file (extracting file) takes a long time, after the extraction of the following page display, click "OK".
2-3. Click the "Plan"->"System Configuration Checker" in the left-hand column in turn.
2-4. Click the "Install"->"New Installation or existing installation add function" in the left column.
2-5. After selecting "I accept the License terms", click "Next".
2-7. MSSQL instance Compose page Use default, click Next.
2-9. After selecting mixed mode (SQL Server authentication and Windows authentication), enter the password 2 times and click Next.
2-12. Show installation progress.
2-13. Verify that the "sql Server 2008 R2 installation has completed successfully. "After that, click" Close ".
The installation to this SQL Server 2008 has completed successfully, and the "sql Server Installation center can be closed.
1) Start SQL Server 2008
Click "Start"->"Management tools"->"Service" and confirm that "sql Server (SQLEXPRESS) status is" to start. "
If SQL Server 2008 is not in the startup state, after selecting the "sql Server (SQLEXPRESS) service, right-click" Start ".
2) Connect SQL Server 2008
Use the Command connection tool sqlcmd to connect to SQL Server 2008, so after you start the command prompt, enter the command in the following format.
SQLCMD-E-s computer name \ Instance Name
This time it is local to connect SQL Server 2008 so the computer name uses "localhost", and the instance name specifies the "sqlexpress" named at installation time.
After starting the command prompt with the above information, execute the following command.
SQLCMD-E-S Localhost\sqlexpress
Displays "1>" when SQL Server 2008 is connected successfully.
Successfully connected to SQL Server 2008. Enter "exit" when you exit sqlcmd.
The following error occurred while conducting a connection test.
HResult 0x35, Level 16, State 1
Named pipe provider: Unable to open connection to SQL Server [53].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0: Established with SQL Server, a network-related or instance-specific error occurred. The server could not be found or could not be accessed.
Verify that the instance is correct and that SQL Server is configured to allow remote connections. For more information, see SQL Online books ...
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0: The logon timeout has expired.
Solutions
The client and SQL Server 2008 are on the same server so localhost is absolutely correct, and it is also correct to compare the instance name to the instance name configured when you installed SQL Server.
The connection to the computer name and instance was found to be incorrect.
The command to execute when an error occurs.
SQLCMD-E-S Localhost¥sqlexpress
The correct commands should be as follows.
SQLCMD-E-S Localhost\sqlexpress
After modifying the connector for the computer name and instance, the connection to SQL Server was successful.