KenBrey Posted July 18, 2013 Report Share Posted July 18, 2013 I have a new installation of SQL Server that I can't get retrospect to authenticate to. I have installed the latest version of Retrospect: 8.2.0(177) My SQL Server version is 11.0.3128. I have attempted all three authentication options, and have confirmed that I can connect to the DB using SQL Server Management Studio with either the domain or SQL users and passwords that I am using in Retrospect. Why won't it connect? 7 Quote Link to comment Share on other sites More sharing options...
Mayoff Posted July 18, 2013 Report Share Posted July 18, 2013 Did you install the SQL 2005 backwards compatibility modules required by Retrospect? You will find a link in the knowlegebase. 1 Quote Link to comment Share on other sites More sharing options...
KenBrey Posted July 19, 2013 Author Report Share Posted July 19, 2013 Mayoff, Thanks for your help. I found a link in the knowledgebase article, however it applies to SQL Server 2008. The KB link is here: http://retrospect.com/en/support/kb/sql-2008-databases-do-not-display-in-retrospect-7-6-and-later-windows and it links to this MS download: http://www.microsoft.com/en-us/download/details.aspx?id=6375 Within that download is the SQL server 2005 backward compatibility module: SQLServer2005_BC.msi However, this module does not want to install on Windows Server 2012. Can you point me to the correct link? Quote Link to comment Share on other sites More sharing options...
KenBrey Posted July 19, 2013 Author Report Share Posted July 19, 2013 I found a more recent link: http://www.microsoft.com/en-us/download/details.aspx?id=15748 It has the file SQLServer2005_BC_x64.msi which installs. Quote Link to comment Share on other sites More sharing options...
KenBrey Posted July 19, 2013 Author Report Share Posted July 19, 2013 I now get an error: R6034 An application has made an attempt to load the C runtime library incorrectly Another KB article, http://retrospect.com/en/support/kb/r6034, indicates this is due to the wrong version of 2005 compatibility. However, the article doesn't give any useful solution. I get this error on retrospect program load, and about 3 times when I attempt to set login info for the DB server in retrospect. If I unlicense the DB server, then I don't get the message. According to Programs and Features, I am running MS SQL Server 2005 Backward compatibility version 8.05.1054. Quote Link to comment Share on other sites More sharing options...
KenBrey Posted July 19, 2013 Author Report Share Posted July 19, 2013 I found a more recent version at microsoft. 8.05.2004 http://www.microsoft.com/en-us/download/details.aspx?id=24793 This allows me to connect. Quote Link to comment Share on other sites More sharing options...
365873f8-83c4-43ce-8635-15a65add20d3 Posted September 19, 2013 Report Share Posted September 19, 2013 Ken, you're a legend. This worked perfectly and saved me God knows how much time! Thanks for posting. Quote Link to comment Share on other sites More sharing options...
klibanoffit Posted January 23, 2014 Report Share Posted January 23, 2014 I have a new install of retrospect with the sql license. I am running MS Server 2008 r2, sql server 2012, retrospect 8.1 (266) and I cannot get SQL to authenticate. Tried all logins, sql domain Any ideas? Thanks in advance! Quote Link to comment Share on other sites More sharing options...
Mayoff Posted January 23, 2014 Report Share Posted January 23, 2014 Did you install the SQL 2005 backwards compatibility modules required by Retrospect? You will find a link in the knowlegebase? Do you have a reason for using Retrospect 8.1 and not 8.5? Quote Link to comment Share on other sites More sharing options...
klibanoffit Posted January 23, 2014 Report Share Posted January 23, 2014 I did not know 8.5 was out. I checked for updates and 8.1 was what it found. I did install SQL 2005 compatibility modules but still the same problem. Maybe I have the wrong link. There were a few to choose from. Quote Link to comment Share on other sites More sharing options...
KenBrey Posted January 24, 2014 Author Report Share Posted January 24, 2014 The correct version is posted above. It is 8.05.2004, The others don't work. http://www.microsoft...s.aspx?id=24793 Quote Link to comment Share on other sites More sharing options...
robwaybro Posted February 24, 2014 Report Share Posted February 24, 2014 Maybe a silly question but I just want to make sure I understand. The compatibility module should be installed on the Retrospect server or the MSSQL server? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.