SQL Source Control: Unauthorized to access resource

Andrew_Orion

Hi folks. 

I've installed the SQL Source control evaluation. I'm unfortunately falling at the first hurdle of linking to a repo. I'm trying to link to a VSTS repositoty hosted in Azure Devops. 

I input the URL of the organisation (https://MyOrganisation.VisualStudio.com) and hit browse to find the folder I made in the repo, and the following error is shown:

Team Foundation services are not available from server https://MyOrganisation.visualstudio.com/.

Technical information (for administrator):

  TF400813: The user '' is not authorized to access this resource.

Is there something I need to do with the Azure Devops project/organisation to sort this?

Thanks.

DanC

Hi @Andrew_Orion

Sorry to hear this didn't help your issue, perhaps you could try the following article, particularly the last part: https://documentation.red-gate.com/soc7/troubleshooting/error-messages/the-team-foundation-server-for-this-workspace-does-not-support-one-or-more-of-the-checkin-options-you-have-selected

Victoria W

Hi @Andrew_Orion

Please follow the steps in this article to link to a VSTS repository:
https://productsupport.red-gate.com/hc/en-us/articles/360022997313-How-to-Link-SQL-Source-Control-to-TFS 

Andrew_Orion

Victoria, thank you for your response but this is not helpful. I have both read the linked article and viewed the Redgate University videos. Neither cover the error I am seeing. 

Andrew_Orion

Dan- that's solved the issue. Many thanks. 

Victoria W

Hi @Andrew_Orion

Just posting the solution for the community:

Sorry to hear this didn't help your issue, perhaps you could try the following article, particularly the last part: https://documentation.red-gate.com/soc7/troubleshooting/error-messages/the-team-foundation-server-for-this-workspace-does-not-support-one-or-more-of-the-checkin-options-you-have-selected

timberzen

When TFS in Azure Devops and this old bug pops up,
edit in notepad
%localappdata%\Red Gate\SQL Source Control 7\RedGate_SQLSourceControl_Engine_EngineOptions.xml

<EngineOptions version="3" type="EngineOptions">

  <TeamFoundationServerDllOverride>TfsExtendedClient</TeamFoundationServerDllOverride>

</EngineOptions>

Restart SSM then you are good to go