SQL Prompt 10.14.21.9884 cannot connect to sql server
Bob1234
Posts: 3 New member
in SQL Prompt
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.
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.
Tagged:
Answers
Can you confirm if you have also SQL Source Control installed? If so, can you specify the full version number?
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?