locked
SQL Server Host Name Changed RRS feed

  • Question

  • Hi All,

    MS SQL 2008 R2 has hosted at OS Windows 2008 R2 ( VMWare Vitrual Machine )

    Migration team has migrated the VM from one EXSi to another EXSi and changed the IP and Host name without our knowledge 

    Issue : Unable to login the SQL


    Please advice how to resolve this issue with current new host name

    Thanks


    MICROSOFT

    Thursday, April 6, 2017 5:54 AM

All replies

  • Hello,

    First check if SQL Server Service is running and if you find any errors in SQL Server ErrorLog file.

    A local connection should work even after renaming the host, only remote connections can face issues; for this you have to follow the simple steps from Rename a Computer that Hosts a Stand-Alone Instance of SQL Server; but of cause you need to connect first to SQL Server


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, April 6, 2017 5:58 AM
  • Hello ,

    Are trying window authentication ? or SA ?

    you need to start SQL-Server in single-user mode in which any local administrator has access and you can fix your broken logins.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Thursday, April 6, 2017 6:03 AM
  • Hi RVK25,

    Based on your image, it sounds like either your SQL Server service is not running, or named pipes is not enabled in SQL Server configuration manager. Either way you would need to follow the instructions here to verify your configuration.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 6, 2017 8:14 AM