none
Can't login SQL after changing computer name RRS feed

  • Question

  • We have DPM and VMM running on a Windows 2008 R2. After we changed the computer, we can't logon to the SQL Server Management Studio. The login screen doesn't show the SQL Server name. It doesn't we enter the correct servername or localhost, we get Error 53 or error 2. However both DPM and VMM work fine.  How can we fix this login problem?


    Bob Lin, MCSE & CNE Networking, Internet, Routing, VPN Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net How to Install and Configure Windows, VMware, Virtualization and Cisco on http://www.HowToNetworking.com

    Tuesday, March 11, 2014 3:35 AM

Answers

    • You can use IP instead like

    ip_addr\instance_name

    as Server name above.

    • Please also ensure the relevant services have been started properly within services.msc

    Many Thanks & Best Regards, Hua Min

    • Edited by Ai Guo Tuesday, March 11, 2014 4:19 AM
    • Marked as answer by chicagotech Tuesday, March 11, 2014 5:49 PM
    Tuesday, March 11, 2014 3:43 AM
  • As suggested try to connect SQL Server using ip address, once logged in verify your server name using below query

    Select ServerProperty('ServerName'), @@ServerName

    both properties should return you same server name.


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

    • Marked as answer by chicagotech Tuesday, March 11, 2014 5:49 PM
    Tuesday, March 11, 2014 5:38 AM

All replies

    • You can use IP instead like

    ip_addr\instance_name

    as Server name above.

    • Please also ensure the relevant services have been started properly within services.msc

    Many Thanks & Best Regards, Hua Min

    • Edited by Ai Guo Tuesday, March 11, 2014 4:19 AM
    • Marked as answer by chicagotech Tuesday, March 11, 2014 5:49 PM
    Tuesday, March 11, 2014 3:43 AM
  • As suggested try to connect SQL Server using ip address, once logged in verify your server name using below query

    Select ServerProperty('ServerName'), @@ServerName

    both properties should return you same server name.


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

    • Marked as answer by chicagotech Tuesday, March 11, 2014 5:49 PM
    Tuesday, March 11, 2014 5:38 AM
  • Actually, using servername\instance_name (the problem I had is I didn't use the instance_name). Running S"elect ServerProperty('ServerName'), @@ServerName " shows current servername. Thank you very much.

    Bob Lin, MCSE & CNE Networking, Internet, Routing, VPN Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net How to Install and Configure Windows, VMware, Virtualization and Cisco on http://www.HowToNetworking.com

    Tuesday, March 11, 2014 5:49 PM