What are the challenges you face when working across database platforms? Take the survey

SQL Backup wont connect to server

phatmikephatmike Posts: 4
edited May 22, 2009 12:38PM in SQL Backup Previous Versions
Hey all, I have a group of 15 servers, however I can't get SQL backup to connect with two of them (when going to "add server")

I can connect to the servers fine from SSMS on the same machine that SQL Backup is installed on.

In properties, it says "connection error" and has a huge string that I can't copy and paste here. It starts with
System.InvalidCastException: Object cannot be cast from DBNull to other types at System.DBNull.System.IConvertible.ToInt32(IFOrmateProvider provider) at System.CVOnvert.ToInt32(Object value) at _16._1(SqlConnection, _17, Int32 &..........etc etc)

RUnning version


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Thank you for your post into the forum.

    Can you please check that your Logged In Windows Account has permissions to the SQL Server you are attempting to register into the SQL Backup GUI?

    The reported fault symptoms can occur when the logged in user account does not have the correct permissions to the SQL Server.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.