SSMS hangs when connecting with SQL login

asked 2022-06-29T12:34:44.15+00:00
Mick 1 Reputation point

When I try to open a query window using a SQL login for the connection, the dialog hangs indefinitely. It never times out or shows an error. This is occurring on multiple server instances and in both SSMS 18.2 and 18.12.1. The DBA and my customer can connect without issue. This just started happening yesterday.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,457 questions
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2022-06-29T13:01:04.647+00:00
    Ronen Ariely 13,776 Reputation points Microsoft MVP

    Hi,

    Starting from the end: From your description My first guess is that you have local issue with the installation.

    If I understand you correctly then this issue is only from specific machine (as you mentioned that other "can connect without issue").

    (1) What do you mean "in both SSMS 18.2 and 18.12.1"? Do you have both version on the same machine? This is not supported. If in someway you got this scenario then you should uninstall all and have a clean installation of the latest version (hopefully the uninstallation will not leave something behind)

    (2) Your best option might be to uninstall it and re-install, but before you do so,

    (2.1) Try to use the Azure Data Studio (without installing anything). Check if this connect the server well

    (2.2) If this is not a production machine then you might want to tests SSMS 19, which can run side by side the SSMS 18. This is a huge advantage which let you test it and check if your issue continue on SSMS 19.


  2. answered 2022-06-30T08:41:08.06+00:00
    YufeiShao-msft 6,871 Reputation points

    Hi @Mick

    You can try to use SQL Server profiler and create a trace to capture starting event, for the moment you can try to use SQLCMD to see if you can login using the same authentication method

    https://www.sqlservercentral.com/forums/topic/sql-logins-do-not-work-when-connecting-using-ssms
    https://social.msdn.microsoft.com/forums/sqlserver/en-US/01796328-4fff-493d-86f6-1a1b756596eb/ssms-hangs-during-connection

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.