Incorrect repository URL

dlaws2

I've linked my database to my TFS repository but I'm unable to pull or push from/to the remote repository.

When I attempt to do either I'm asked to enter my credentials in the 'Source control credentials required' dialog, when I do that it returns an error 'Incorrect details'. I know the issue is not due to my username/password but down to the URL of the repository Redgate believes it should be.

The correct repository URL is [url]http://servername:port/tfs[/url] but on the credentials dialog shows [url]http://servername:port/[/url]. If I browse [url]http://servername:port/[/url] I get access denied.

Where does Redgate set the repository URL and can I change it?

dlaws2

Can someone please help me with this problem?

RyanJLind

Did you ever solve this? I am having the same problem.

RedGate always wants to pull from http://server-name:port/ when really my git repository is at http://server-name:port/tfs/DefaultCollection/blah/_git/Data

way0utwest

If you are using the git interface, that should be the URL you include. For example, I have the local path for my git repo.

For TFS, you should have entered the entire TFS url to your repo. This can include the /tfs item in your setup. Check that tab when your database is selected.

way0utwest

Also, which SQL Source Control version?

RyanJLind

I figured out it is because RedGate does not support git embedded within TFS, which is incredibly frustrating and renders the source control component mostly useless for our needs.

I have voted for it here: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/14596167-support-git-hosted-under-tfs

way0utwest

I'm not sure what you mean here. If you are using git, then you connect to your git repository. The TFS part doesn't matter. If you are trying to connect to the TFS git repository on the server, you're incorrectly setting this up. I use TFS online and the git interface with SQL Source Control. You should have a cloned repository on your local system that you setup as a git cloned repo from TFS. When linking to the database, choose Git, not TFS.

RyanJLind

Did you click on my link? The TFS part clearly does matter. I am well aware how git works and how to clone repositories. The problem is when PUSHING or PULLING to/from the remote repository, it does not work because the URL for the remote repository ignores the virtual directories and tries to connect directly to "servername:port," as specified in the original comment.

Please read this thread and the comment by Sergio: https://forum.red-gate.com/discussion/80296/sql-source-control-connecting-to-team-services-with-git

"2 - SQL Source Control does not support "git within TFS" currently, precisely due to authentication issues."

way0utwest

I wasn't sure what you were doing. Is there a reason you can't set a git repository on your machine that points to a remote in TFS? I haven't tried the git in TFS. I've used TFS or I've used git that points to the repo in TFS.

RyanJLind

I have a git repository on my machine. It points to a remote in TFS. I can push/pull from a command prompt no problem. It is only in Management Studio, within SQL source control, where the big button marked "pull from remote repository" does not function.

Tianjiao_Li

I'm afraid using Git inside TFS isn't supported by SQL Source Control, however Git via Visual Studio
Team Services (TFS online) is supported.
https://documentation.red-gate.com/soc6/linking-to-source-control/link-to-git

If you use Git via VSTS, you need to create a Personal access token, then go to SQL Source Control --Link to my source control system -- Git, paste the path of the local repository that you've cloned. Then cick 'Link', and choose access token and put in your Personal access token.