SSMS hangs when connecting with SQL login

Mick-3237 21 Reputation points
2022-06-29T12:34:44.15+00:00

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.
12,620 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Ronen Ariely 15,096 Reputation points
    2022-06-29T13:01:04.647+00:00

    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. YufeiShao-msft 7,051 Reputation points
    2022-06-30T08:41:08.06+00:00

    Hi @Mick-3237

    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.