SQL Server 2008 Logon error: Unable to connect to (local) solution _mssql2008

After some friends have installed SQL Server 2008, most of them will encounter problems with connection errors. Especially for us such a novice is simply depressed to death, and finally pretended to play a problem. This article is intended to address the problem of not having a problem with installation steps, but not being able to log on after installation.

Before you solve the problem, ask your friends to open the service window and see if the SQL Server main service is open, as shown in the following illustration.

If the service is already open or you cannot log on with SQL Server authentication and Windows authentication, see the steps below.

Often at this time, the server type we select the "Database Engine", look for the user name inside the login is not, the server name below only display as "(local)", even "Windows authentication" can not log on.

The window that pops up after the error is:

Error Number: 2.

If my friends and I have the same problem, please see the following steps.

1. Also click "My Computer (Windows XP)" or "Computer (Windows 7)" To view the computer name of this machine.

2. Open "SQL Server 2008",

Server type selection: Database engine.

Server name write: computer name \ The instance name that you created when you installed SQL Server.

Authentication selection: SQL Server authentication.

Fill in the login name and password you have set up.

The following figure:

3. Click "Connect" to login, as shown below.

At this point, the problem with SQL Server 2008 logon errors is resolved.

Summary: The server name of the SQL Server 2008 version database software has changed from the version of SQL Server 2005 and is now using the computer name \ Instance name. This results in a "Cannot connect to (local)" issue.