Connection to this SQL Server failed
DanAvni
Posts: 72 Bronze 2
2 servers I have in the database distribution list show a red icon with a tooltip that says the connection to the SQL server failed and I should right click to fix the connection. I am using Windows Authentication and my account is sysadmin so there are no connection issues. Moreover, I can connect using SSMS without any issues using Windows Authentication.
Any ideas what is the reason?
Any ideas what is the reason?
Dan Avni
Tagged:
Answers
If you enable the verbose logging as per this help document. Repeat steps you took previously, does the log file provide any further information as to why SQL Multi-Script is failing to connect to the two servers in your distribution list?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com