Installation does not detect MSSQL

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Installation does not detect MSSQL

Postby sderrico » Mon May 14, 2012 1:03 pm

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
Sébastien D'Errico
IT Development
sebastien@hollox.net
(438-882-8687
sderrico
 
Posts: 3
Joined: Mon May 14, 2012 12:32 pm
Location: Montreal

Postby csmith » Wed May 16, 2012 6:10 pm

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
Chris Smith
Project Manager
Deployment Manager
csmith
 
Posts: 117
Joined: Thu Jun 30, 2011 2:15 pm
Location: Cambridge

Postby sderrico » Wed May 16, 2012 8:08 pm

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
Sébastien D'Errico
IT Development
sebastien@hollox.net
(438-882-8687
sderrico
 
Posts: 3
Joined: Mon May 14, 2012 12:32 pm
Location: Montreal

Postby Brian Donahue » Thu May 17, 2012 11:35 am

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)
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests