Cannot Authenticate to SQL server

[KenBrey 7]

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?

[Mayoff 123]

Did you install the SQL 2005 backwards compatibility modules required by Retrospect? You will find a link in the knowlegebase. 

[KenBrey 7]

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?

 

[KenBrey 7]

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.
 

[KenBrey 7]

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.

[KenBrey 7]

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.

[365873f8-83c4-43ce-8635-15a65add20d3 0]

Ken, you're a legend.  This worked perfectly and saved me God knows how much time!  Thanks for posting.

[klibanoffit 0]

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!

[Mayoff 123]

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?

[klibanoffit 0]

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.

[KenBrey 7]

The correct version is posted above.  It is 8.05.2004,  The others don't work.

http://www.microsoft...s.aspx?id=24793

[robwaybro 0]

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?