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?
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:
- Install Microsoft Web Platform Installer, please download it from https://www.microsoft.com/web/downloads/platform.aspx
- Select All in the left pane and Products from the top. In the search box enter SSDT .
- Add and install SSDT and then from the SQL menu, select Add SQL Server.
- 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).