SQL Server Tidak Dapat Connect Ke Server : Error 26

Saat mencoba connect pada Microsoft SQL Server Management Studio Express, pernah ketemu dengan error 26 gak guys???

“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)”

Kalau iya, gak usah panik. Let’s try this steps :)

1. Masuk ke configuration tools pada Microsoft SQL Server 2005

2. Pilih  “SQL Server Configuration Manager”.
3. SQL Server Configuration Manager (local) .
4. Klik SQL Server 2005 Services maka disebelah kanan muncul seperti gambar berikut :

5.  Klik kanan SQL Server (SQLEXPRESS) dan klik start
6.  Tunggu sampai konfigurasinya selesai.
7.  Restart Server SQL Server Management Studio.

Selamat mencoba dan semoga berhasil guys….