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

1. Server type When we select the database engine, the login username is not found, the server name below is only displayed as "(local)", and even "Windows Authentication" cannot log on.

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.         There is an instance name in the Permissions: Control Panel-Administrative Tools-Services-Find SQL Server (MSSQLSERVER)-right-click to start, and set to automatically start the authentication selection: SQL Server Authentication. Fill in the login name and password that you set. Summary: The server name for the SQL Server 2008 version database software has changed from the SQL Server 2005 version and is now using the computer name \ Instance name. This causes a "Cannot connect to (local)" issue.

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