Installation does not detect MSSQL

sderrico

Hello!

We are in evaluation of SQL Source Control.

This product is great. I tested and I am ready to buy.

I tried to install SQL Source Control on the workstation of the IT director of the company and the installation does not detect the MSSQL installation.

The first difference between my computer and his computer is that mine is in english and his is in french.

Does the system language affect the installation?

Thank you,
Have a great day!
Sébastien

csmith

Hi

We believe SQL Source Control should work on a French version of Windows (although the UI is not localized). I've asked a few questions below to help us diagnose the problem:

1. Did you only have one instance of SSMS open? Because SQL Source Control will only appear in the first instance of SSMS opened.
2. Which version of SQL Source Control and SQL Server SSMS are installed on the IT director's computer?
3. Can you confirm that there is an registry entry at the following location on the director's computer:
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\Downloads\SQL Source Control\3

Best regards,
Chris

sderrico

Hello Chris,

We cannot install SQL Source Control 3 because we cannot check this component during the installation.
The checkbox is disabled and there is a message like "SSMS MUST BE INSTALLED".

There is two versions of SSMS installed. Here the related information of each:

SQL SERVER MANAGEMENT STDIO 2008 R2

Microsoft SQL Server Management Studio 10.50.1617.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5456
Système d'exploitation 6.1.7601

SQL SERVER MANAGEMENT STDIO 2012

Microsoft SQL Server Management Studio 11.0.2100.60
Outils clients Microsoft Analysis Services 11.0.2100.60
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 4.0.30319.269
Système d'exploitation 6.1.7601

Thank you,
Have a great day!
Sébastien

Brian Donahue

The SQL Source Control installer checks these keys to determine whether or not SSMS is installed. Maybe you do not have access to these keys or the appropriate one does not exist...

HKEY_CLASSES_ROOT\ssmsee.sql.10.0\shell\Open\Command\(Default)
HKEY_CLASSES_ROOT\sqlwb.sql.9.0\shell\Open\Command\(Default)
HKEY_CLASSES_ROOT\ssmsee.sql.9.0\shell\Open\Command\(Default)
HKEY_CLASSES_ROOT\sqlwb.sql.10.0\shell\Open\Command\(Default)
HKEY_CLASSES_ROOT\ssmsee.sql.10.0\shell\Open\Command\(Default)