Upgrade from SQL Backup v4 to v5: Server connection issue

• 
  Hi Tom,
  
  Can you check the SQL Server logs, which are available in the management container of either Management Studio or Enterprise Manager? When the connection attempt fails, the reason is probably contained in the logs of the SQL Server that you are connecting to. I think that this error indicates some sort of buffer error on the SQL connection.

  Brian Donahue November 20, 2007 12:53

  - 0 +
• 

  Brian Donahue wrote:

  Hi Tom,
  
  Can you check the SQL Server logs, which are available in the management container of either Management Studio or Enterprise Manager? When the connection attempt fails, the reason is probably contained in the logs of the SQL Server that you are connecting to. I think that this error indicates some sort of buffer error on the SQL connection.

  
  I have checked the logs and there aren't any messages pertaining to this issue.

  TomHodson November 21, 2007 06:27

  - 0 +
• 

  Brian Donahue wrote:

  Hi Tom,
  
  Can you check the SQL Server logs, which are available in the management container of either Management Studio or Enterprise Manager? When the connection attempt fails, the reason is probably contained in the logs of the SQL Server that you are connecting to. I think that this error indicates some sort of buffer error on the SQL connection.

  
  
  I have been able to successfully connect to a server that doesn't have the v4 server components installed.

  TomHodson November 21, 2007 06:48

  - 0 +
• 

  TomHodson wrote:

  Brian Donahue wrote:

  Hi Tom,
  
  Can you check the SQL Server logs, which are available in the management container of either Management Studio or Enterprise Manager? When the connection attempt fails, the reason is probably contained in the logs of the SQL Server that you are connecting to. I think that this error indicates some sort of buffer error on the SQL connection.

  
  
  I have been able to successfully connect to a server that doesn't have the v4 server components installed.

  
  but still can't connect to the servers that already have sql backup components on them, and these are the important ones.

  TomHodson November 21, 2007 07:18

  - 0 +
• 
  Are there no log entries generated when you attempt to connect? I'm concerned that you're only looking for log files that pertain to the error. I wouldn't know exactly what to look for, but they probably won't include any of the error text that you see in SQL Backup. They probably say something about a buffer overrun or something like that.

  Brian Donahue November 21, 2007 09:37

  - 0 +
• 

  Brian Donahue wrote:

  Are there no log entries generated when you attempt to connect? I'm concerned that you're only looking for log files that pertain to the error. I wouldn't know exactly what to look for, but they probably won't include any of the error text that you see in SQL Backup. They probably say something about a buffer overrun or something like that.

  
  I switched on logging for all connections, restarted one of sql servers and attempted another connection through sql backup. This generated 4 log entries, the messages were as follows:
  
  Using 'xp_sqlbackup.dll' version '0004.00.00' to execute extended stored procedure 'sqbutility'.
  Login succeeded for user '[DOMAIN]\[user]'. Connection: Trusted.
  Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
  Login succeeded for user '[DOMAIN]\[user]'. Connection: Trusted.

  TomHodson November 22, 2007 06:50

  - 0 +
• 
  Interesting... what happens if you open a query window and connect as the same user you've noted in the error log, and connect to master and run exec xp_msver?
  
  Are there null/no/error results?

  Brian Donahue November 22, 2007 07:50

  - 0 +
• 

  Brian Donahue wrote:

  Interesting... what happens if you open a query window and connect as the same user you've noted in the error log, and connect to master and run exec xp_msver?
  
  Are there null/no/error results?

  
  
  The only log entries are for the successful connection

  TomHodson November 22, 2007 07:59

  - 0 +
• 
  The problem has been solved (thanks to an email from red gate support). The solution is to manually install the v5 server components on each of the servers using the following executable:
  
  %PROGRAM FILES%\Red Gate\SQL Backup\SQBServerSetup.exe
  
  This needs to be run on each server, but the exe must be the v5 version. I ran mine using a network share.
  
  Once you have upgraded the components, you then need to re-activate the licences using the GUI, otherwise the components will expire after 14 days.

  TomHodson November 23, 2007 04:51

  - 0 +

Add comment

Please sign in to leave a comment.