KenBrey 7 Report post 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 Share this post Link to post Share on other sites
Mayoff 124 Report post 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 Share this post Link to post Share on other sites
KenBrey 7 Report post 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? Share this post Link to post Share on other sites
KenBrey 7 Report post 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. Share this post Link to post Share on other sites
KenBrey 7 Report post 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. Share this post Link to post Share on other sites
KenBrey 7 Report post 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. Share this post Link to post Share on other sites
365873f8-83c4-43ce-8635-15a65add20d3 0 Report post Posted September 19, 2013 Ken, you're a legend. This worked perfectly and saved me God knows how much time! Thanks for posting. Share this post Link to post Share on other sites
klibanoffit 0 Report post 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! Share this post Link to post Share on other sites
Mayoff 124 Report post 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? Share this post Link to post Share on other sites
klibanoffit 0 Report post 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. Share this post Link to post Share on other sites
KenBrey 7 Report post 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 Share this post Link to post Share on other sites
robwaybro 0 Report post 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? Share this post Link to post Share on other sites