How can we help you today? How can we help you today?

SQL Prompt 10.14.21.9884 cannot connect to sql server

I am using SSMS 18.12.1 with Windows Login (Trust Certificate checked). SQL Prompt cannot connect to SQL server, I get below error when I check SQL Prompt Logs.

Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: HTTP Provider, error: 0 - )

No issue with my license. This was working fine until last week, just recently it is having issues to connect.

Bharat Patel
0

Comments

6 comments

Sort by
  • Bob1234
    I downgraded Prompt to 10.13.15.xxxx and now it works fine. Something broken in the lastest version,
    Bob1234
    0
  • chrisqtran
    Hi there,

    Can you confirm if you have also SQL Source Control installed? If so, can you specify the full version number?
    chrisqtran
    0
  • Bob1234
    Yes, I do have SQL source Control 7.4.6.16349 installed.

    Bob1234
    0
  • chrisqtran
    Thank you.

    If you are not using SQL Source Control, can you uninstall it? If you do use it, can you please upgrade to our latest version? https://download.red-gate.com/checkforupdates/SQLSourceControl/

    Once either of those tasks are done, can you check and see if the issue persists?
    chrisqtran
    0
  • gsrinivasarao
    I have SQL prompt version 10.14.21.9884 with this issue. "loading ..."
    gsrinivasarao
    0
  • gsrinivasarao
    SQL Source control upgrade helped resolve the sql prompt loading issue.
    gsrinivasarao
    0

Add comment

Please sign in to leave a comment.