Options

Connection to this SQL Server failed

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?
Dan Avni
Tagged:

Answers

  • Options
    Eddie DEddie D Posts: 1,781 Rose Gold 5
    Hi DanAvni,
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.