none
(Sumber: milist SQL Server) Koneksi database gagal

    Question

  •  

    saya lg baru belajar sql::

    ketemu sama masalah kaya gini :

    Koneksi database gagal.
    periksa konfigurasi database
    error = An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    solusinya gmn ya???


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, March 09, 2012 7:59 AM
    Moderator

Answers

  •  

    Apakah anda menggunakan SQLServer 2005 express? kalo iya, error ini biasanya terjadi saat kita ingin meremote database dari client dikarenakan setting default SQL Server Express tidak membolehkan remote database via client

    solusinya:

    - buka SQL Server 2005 Surface Area Configuration

    - klik Surface Area Configuration for sevices and connections

    - klik Remote connections lalu pilih Local and remote connections

    Dijawab oleh: Eri


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, March 09, 2012 8:00 AM
    Moderator