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

After some friends install SQL Server 2008, most of the problems encountered connection errors such as: SQL Server 2008 Logon error: Unable to connect to (local) and so on related issues, this article will detail the solution, the need for friends can refer to the following

After some friends install SQL Server 2008, most of them encounter connection errors. Especially for us such a novice is simply depressed to die, and finally play the game and there are problems. This article is intended to resolve problems with installation steps, but cannot log on after installation.

Before solving the problem, ask your friends to open the service window and see if the "SQL Server" primary service is open, as in.

If the service is open or SQL Server authentication and Windows authentication cannot log in, see the steps below.

Often at this point, the server type when we select the "Database Engine", look for the inside of the login user name is not, the bottom of the server name 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 take a look at the steps below.

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

2. Open "SQL Server 2008",

Server type selection: Database engine.

Server name write on: computer name \ Instance name that you created when you installed SQL Server.

Authentication selection: SQL Server authentication.

Fill in the login name and password that you set.

Such as:

3. Click "Connect" to log in, as.

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

Summary: The server name for the SQL Server 2008 version database software has changed from the version of SQL Server 2005, which is now used: computer name \ instance name. This causes a "Cannot connect to (local)" issue.

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