none
(Sumber: milist SQL Server) Tidak bisa akses Management studio/connect SQL Server 2005 setelah server di disjoint RRS feed

  • Pertanyaan

  • Dear All,

    Butuh bantuan banget.

    Tadi pagi server database di disjoint karena ada sesuatu lain hal, namun setelah itu sql servernya tidak bisa di akses/connect. dan di server ketika akan akses ke management studio tidak bisa juga masuk baik pakai sa ataupun pakai windows authentication.

    Adakah yg bisa memberikan solusi??

    terimakasih


    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.
    Rabu, 26 Oktober 2011 07.42
    Moderator

Jawaban

  • Backup file mdf n ldf n filegroup yg adaa

    Coba disjoint kèmbali kemudian logon kedlm sèrvèr menggunakan login admin local.

    Stlah itu ganti log on as utk sérvices Sqlservèr tsb dgn account LocalSystèm

    Kèmudian coba lagi restart sérvicêsnya.


    Dijawab oleh: Suherman


    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.
    Rabu, 26 Oktober 2011 07.43
    Moderator

Semua Balasan

  • Backup file mdf n ldf n filegroup yg adaa

    Coba disjoint kèmbali kemudian logon kedlm sèrvèr menggunakan login admin local.

    Stlah itu ganti log on as utk sérvices Sqlservèr tsb dgn account LocalSystèm

    Kèmudian coba lagi restart sérvicêsnya.


    Dijawab oleh: Suherman


    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.
    Rabu, 26 Oktober 2011 07.43
    Moderator
  • Udah bisa mas,

    Saya login local admin, 

    administrative tools->services->di MSSQLSERVER klik kanan->properties->logon->dirubah ke local system.

    Alhamdulillah servicesnya bisa di running lagi.

    Namun setelah ini apa logonnya dirubah lagi ke semula atau biarkan saja?

    trims


    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.
    Rabu, 26 Oktober 2011 07.44
    Moderator
  • Sukurlah kalo udah bisa.

    Langkah selanjutnya terserah anda. Namun akan lebih baik langkah2 pengamanan dilakukan spt backup full dan hardening

    Dijawab oleh: Suherman


    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.
    Rabu, 26 Oktober 2011 07.45
    Moderator