Question

George Robertson Jr on Tue, 18 Apr 2017 20:24:32


I'm trying to get SQL Server Data Tools (Visual Studio 2010 (Shell)) to work with a TFS 2013 server.

TFS does not show up in the list of providers under Tools --> Options. 

I've tried installing the Visual Studio 2010 SP1 Team Foundation Server Compatibility GDR (https://www.microsoft.com/en-us/download/details.aspx?id=29082).  It didn't make a difference.

Has anyone had any success with this?


Sponsored



Replies

Teige Gao on Wed, 19 Apr 2017 03:54:52


Hi George,

 

You can try to install it by using Web Platform Installer, please refer to the following stesp:

 

  1. Install Microsoft Web Platform Installer, please download it from https://www.microsoft.com/web/downloads/platform.aspx
  2. Select All in the left pane and Products from the top. In the search box enter SSDT .
  3. Add  and install SSDT and then from the SQL  menu, select Add SQL Server.
  4. From the View menu, select SQL Sever Object Explorer, double click the (LocalDB) entry, then select the DB and the table you wish to examine.

 

For more information, please refer to this article: https://blogs.msdn.microsoft.com/rickandy/2012/08/02/installing-and-using-sql-server-data-tools-ssdt-on-visual-studio-2010-and-vwd/

 

Best Regards,

Teige

 

George Robertson Jr on Thu, 20 Apr 2017 13:23:33


Thank you for your suggestions. 

Unfortunately, they did not help.   When I downloaded Microsoft Web Platform installer, SSDT was not one of the available downloads.  I did find Visual Studio 2010 SP1 which I installed (images below).   The information about my Visual Studio 2010 (shell) are also included below.

I still do not see Team Foundation Server as an available source control provider (see image below).

I am also including the install log from Visual Studio 2010 SP1 Team Foundation Server Compatibility GDR.

Do you believe installing Visual Studio 2010 Ultimate on top of SSDT will help?


Visual Studio 2010 Help About

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.5.51209 SP1Rel

Installed Version: IDE Standard

Microsoft Office Developer Tools   01011-532-2002361-70780
Microsoft Office Developer Tools

Microsoft Visual Basic 2010   01011-532-2002361-70780
Microsoft Visual Basic 2010

Microsoft Visual C# 2010   01011-532-2002361-70780
Microsoft Visual C# 2010

Microsoft Visual Studio Tools for Applications 3.0   01011-532-2002361-70780
Microsoft Visual Studio Tools for Applications 3.0

Microsoft Visual Web Developer 2010   01011-532-2002361-70780
Microsoft Visual Web Developer 2010

Critical Update for Visual Studio 2010 Shell (Isolated) - ENU (KB2938807)   KB2938807
This critical update is for Visual Studio 2010 Shell (Isolated) - ENU.
If you later install a more recent service pack, this critical update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2938807.

Hotfix for Visual Studio 2010 Shell (Integrated) - ENU (KB2548139)   KB2548139
This hotfix is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2548139.

Hotfix for Visual Studio 2010 Shell (Integrated) - ENU (KB2549864)   KB2549864
This hotfix is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2549864.

Hotfix for Visual Studio 2010 Shell (Integrated) - ENU (KB2635973)   KB2635973
This hotfix is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2635973.

Hotfix for Visual Studio 2010 Shell (Isolated) - ENU (KB3002340)   KB3002340
This hotfix is for Visual Studio 2010 Shell (Isolated) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/3002340.

Microsoft Visual Studio 2010 SharePoint Developer Tools   10.0.40219
Microsoft Visual Studio 2010 SharePoint Developer Tools

Security Update for Visual Studio 2010 Shell (Integrated) - ENU (KB2645410)   KB2645410
This security update is for Visual Studio 2010 Shell (Integrated) - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2645410.

SQL Server Analysis Services   
Microsoft SQL Server Analysis Services Designer 
Version 11.0.6020.0

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 11.0.6020.0

SQL Server Reporting Services   
Microsoft SQL Server Reporting Services Designers 
Version 11.0.6020.0

Visual Studio 2010 Shell (Isolated) - ENU Service Pack 1 (KB983509)   KB983509
This service pack is for Visual Studio 2010 Shell (Isolated) - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.


Visual Studio 2010 SP1 Team Foundation Server Compatibility GDR Install Log

[4/19/2017, 13:17:47] OS Version Information: ...

[4/19/2017, 13:17:47]OS Version = 6.1.7601, Platform 2, Service Pack 1
[4/19/2017, 13:17:47]OS Description = Windows 7 - x64 Enterprise Edition Service Pack 1

[4/19/2017, 13:17:47] OS Version Information 
[4/19/2017, 13:17:47] Environment details: ...

[4/19/2017, 13:17:47]CommandLine = e:\9e6ebccfaf07a3806f87f82a1c8b88\Setup.exe 
[4/19/2017, 13:17:47]TimeZone = Eastern Daylight Time
[4/19/2017, 13:17:47]Initial LCID = 1033

[4/19/2017, 13:17:47] Environment details 
[4/19/2017, 13:17:47]Loading localized engine data for language 1033 from e:\9e6ebccfaf07a3806f87f82a1c8b88\1033\LocalizedData.xml
[4/19/2017, 13:17:47] Entering Function: LocalizedData::CreateLocalizedData...

[4/19/2017, 13:17:47] exiting function/method

[4/19/2017, 13:17:47] succeeded
[4/19/2017, 13:17:47] Entering Function: EngineData::CreateEngineData...

[4/19/2017, 13:17:47]Current SetupVersion = 1.0
[4/19/2017, 13:17:47]SetupVersion specified in ParameterInfo.xml is '1.0'
[4/19/2017, 13:17:47]patch VS10SP1-KB2662296.msp added
[4/19/2017, 13:17:47]Adding Item type "Patches", local path (not applicable)
[4/19/2017, 13:17:47]No ProcessBlock element
[4/19/2017, 13:17:47]No ServiceBlock element
[4/19/2017, 13:17:47]Using Simultaneous Download and Install mechanism
[4/19/2017, 13:17:47] exiting function/method

[4/19/2017, 13:17:47] succeeded
[4/19/2017, 13:17:47] MaintenanceMode determination: evaluating EnterMaintenanceModeIf...

[4/19/2017, 13:17:47]evaluating EnterMaintenanceModeIf:
[4/19/2017, 13:17:47]returning false

[4/19/2017, 13:17:47] MaintenanceMode determination evaluates to 'not in maintenance mode'
[4/19/2017, 13:17:47] Operation Type: ...

[4/19/2017, 13:17:47]Operation: Installing

[4/19/2017, 13:17:48] Operation Type 
[4/19/2017, 13:17:48] Package details: KB2662296...

[4/19/2017, 13:17:48]Package Name = KB2662296
[4/19/2017, 13:17:48]Package Version = 10.0.40219

[4/19/2017, 13:17:48] Package details 
[4/19/2017, 13:17:48] User Experience Data Collection Policy: ...

[4/19/2017, 13:17:48]User Experience Data Collection Policy: UserControlled

[4/19/2017, 13:17:48] User Experience Data Collection Policy 
[4/19/2017, 13:17:48] Entering Function: UiDataT::CreateUiDataT...

[4/19/2017, 13:17:48]Loading file - e:\9e6ebccfaf07a3806f87f82a1c8b88\UiInfo.xml
[4/19/2017, 13:17:48]Add to schema collection schema file - e:\9e6ebccfaf07a3806f87f82a1c8b88\SetupUi.xsd
[4/19/2017, 13:17:48]Successfuly found file e:\9e6ebccfaf07a3806f87f82a1c8b88\1033\SetupResources.DLL 
[4/19/2017, 13:17:48]Successfuly found file e:\9e6ebccfaf07a3806f87f82a1c8b88\Strings.xml 
[4/19/2017, 13:17:48] exiting function/method

[4/19/2017, 13:17:48] succeeded
[4/19/2017, 13:17:48] Global Block Checks: Checking for global blockers...

[4/19/2017, 13:17:48] Global Block Checks no blocking conditions found
[4/19/2017, 13:17:48]OpenFileMapping fails with last error: 6
[4/19/2017, 13:17:48]The handle to the section is Null
[4/19/2017, 13:17:48]OpenFileMapping fails with last error: 6
[4/19/2017, 13:17:48]The handle to the section is Null
[4/19/2017, 13:17:48] Applicability for Installing: evaluating each item...

[4/19/2017, 13:17:48] Determining state: of e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp...

[4/19/2017, 13:17:48]evaluating ApplicableIf:
[4/19/2017, 13:17:48] Exists: evaluating...

[4/19/2017, 13:17:48]MsiXmlBlob: this patch is applicable

[4/19/2017, 13:17:48] Exists evaluated to true
[4/19/2017, 13:17:48]evaluating IsPresent:
[4/19/2017, 13:17:48] Exists: evaluating...

[4/19/2017, 13:17:48]MsiGetCachedPatchPath with patch code {B09FDA05-D277-3ED9-B15C-5196875E2326}, returned: C:\Windows\Installer\41d78fe.msp

[4/19/2017, 13:17:48] Exists evaluated to true

[4/19/2017, 13:17:48] Determining state of e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp - available but not verified yet
[4/19/2017, 13:17:48]evaluating ApplicableIf:
[4/19/2017, 13:17:48] Exists: evaluating...

[4/19/2017, 13:17:48]MsiXmlBlob: this patch is applicable

[4/19/2017, 13:17:48] Exists evaluated to true
[4/19/2017, 13:17:48]evaluating IsPresent:
[4/19/2017, 13:17:48] Exists: evaluating...

[4/19/2017, 13:17:48]MsiGetCachedPatchPath with patch code {B09FDA05-D277-3ED9-B15C-5196875E2326}, returned: C:\Windows\Installer\41d78fe.msp

[4/19/2017, 13:17:48] Exists evaluated to true

[4/19/2017, 13:17:48] Applicability for Installing determination is complete
[4/19/2017, 13:17:48] Applicability Result Count: ...

[4/19/2017, 13:17:48]Number of applicable items: 1

[4/19/2017, 13:17:48] Applicability Result Count 
[4/19/2017, 13:17:48]evaluating ApplicableIf:
[4/19/2017, 13:17:48] Exists: evaluating...

[4/19/2017, 13:17:48]MsiXmlBlob: this patch is applicable

[4/19/2017, 13:17:48] Exists evaluated to true
[4/19/2017, 13:17:48]evaluating IsPresent:
[4/19/2017, 13:17:48] Exists: evaluating...

[4/19/2017, 13:17:48]MsiGetCachedPatchPath with patch code {B09FDA05-D277-3ED9-B15C-5196875E2326}, returned: C:\Windows\Installer\41d78fe.msp

[4/19/2017, 13:17:48] Exists evaluated to true
[4/19/2017, 13:17:48]
Summary Information:
Microsoft Team Foundation Server 2010 Object Model - ENU

[4/19/2017, 13:17:53]Successfuly found file e:\9e6ebccfaf07a3806f87f82a1c8b88\1033\EULA.rtf 
[4/19/2017, 13:17:56]
Summary Information:
Microsoft Team Foundation Server 2010 Object Model - ENU

[4/19/2017, 13:18:4] Action: System Requirement Checks...

[4/19/2017, 13:18:4] Action: Disk space check for items being downloaded...

[4/19/2017, 13:18:4]Drive:[C:\] Bytes Needed:[33493504] Bytes Available:[13017837568]

[4/19/2017, 13:18:4] Action complete
[4/19/2017, 13:18:4] Action: Enumerating incompatible processes...

[4/19/2017, 13:18:4]No Blocking Processes

[4/19/2017, 13:18:4] Action complete
[4/19/2017, 13:18:4] Action: Enumerating incompatible services...

[4/19/2017, 13:18:4]No Blocking Services

[4/19/2017, 13:18:4] Action complete

[4/19/2017, 13:18:4] Action complete
[4/19/2017, 13:18:4]Launching Download and Install operations simultaneously.
[4/19/2017, 13:18:4] Action: Downloading and/or Verifying Items...

[4/19/2017, 13:18:4]Verifying Digital Signatures: e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp
[4/19/2017, 13:18:4] e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp: Verifying signature for VS10SP1-KB2662296.msp...

[4/19/2017, 13:18:5]e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp - Signature verified successfully for VS10SP1-KB2662296.msp

[4/19/2017, 13:18:5] e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp Signature verified successfully for VS10SP1-KB2662296.msp
[4/19/2017, 13:18:5]Signature verification succeeded for VS10SP1-KB2662296.msp
[4/19/2017, 13:18:5]File e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp, locked for install. 
[4/19/2017, 13:18:5]Verifying Digital Signatures: e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp Success

[4/19/2017, 13:18:5] Action complete
[4/19/2017, 13:18:5]evaluating IsPresent:
[4/19/2017, 13:18:5] Exists: evaluating...

[4/19/2017, 13:18:5]MsiGetCachedPatchPath with patch code {B09FDA05-D277-3ED9-B15C-5196875E2326}, returned: C:\Windows\Installer\41d78fe.msp

[4/19/2017, 13:18:5] Exists evaluated to true
[4/19/2017, 13:18:5]Starting install of item 'VS10SP1-KB2662296' at tickCount = 17916122
[4/19/2017, 13:18:13]WM_ACTIVATEAPP: Focus stealer's windows WAS visible, NOT taking back focus
[4/19/2017, 13:18:4]calling PerformAction on an installing performer
[4/19/2017, 13:18:4] Action: Performing actions on all Items...

[4/19/2017, 13:18:4]Wait for Item (VS10SP1-KB2662296.msp) to be available
[4/19/2017, 13:18:5]VS10SP1-KB2662296.msp is now available to install
[4/19/2017, 13:18:5]Creating new Performer for Patches item
[4/19/2017, 13:18:5] Entering Function: BaseMspInstallerT >::PerformAction...

[4/19/2017, 13:18:5] Action: Performing Install on MSP: e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp targetting Product: Microsoft Team Foundation Server 2010 Object Model - ENU...

[4/19/2017, 13:18:5]Successfully called MsiEnableLog with log file set to C:\Users\gwr\AppData\Local\Temp\KB2662296_20170419_131748172-Microsoft Team Foundation Server 2010 Object Model - ENU-MSP0.txt
[4/19/2017, 13:18:5]Log File C:\Users\gwr\AppData\Local\Temp\KB2662296_20170419_131748172-Microsoft Team Foundation Server 2010 Object Model - ENU-MSP0.txt does not yet exist but may do at Watson upload time
[4/19/2017, 13:18:5]about to call MsiInstallProduct with PATCH="e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp" on product {1AB7EDC5-D891-34C5-9FF1-BE6A85ACC44B}(C:\Windows\Installer\c53434b.msi) to install patches.
[4/19/2017, 13:18:26]Patch (e:\9e6ebccfaf07a3806f87f82a1c8b88\VS10SP1-KB2662296.msp) Install succeeded on product (Microsoft Team Foundation Server 2010 Object Model - ENU). Msi Log: 
[4/19/2017, 13:18:26]MSI returned 0x0: no error

[4/19/2017, 13:18:26] Action 
[4/19/2017, 13:18:26]PerformMsiOperation returned 0x0
[4/19/2017, 13:18:26] exiting function/method

[4/19/2017, 13:18:26] PerformMsiOperation returned 0x0

[4/19/2017, 13:18:26] Action complete
[4/19/2017, 13:18:26]Final Result: Installation completed successfully with success code: (0x00000000), "The operation completed successfully. " (Elapsed time: 0 00:00:39).