SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Visual Studio Data Tools 2017 - TFS lock icons missing and other issues


Visual Studio Data Tools 2017 - TFS lock icons missing and other issues

Author
Message
richardmgreen1
richardmgreen1
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4236 Visits: 1190
Hi all

We've just installed a test instance of Microsoft SQL Server Data Tools for Visual Studio 2017 (Version 15.3.5) and come across a few bugs.
I've had a Google and I can't see a solution as yet.

Hoping someone on here can shed some light on them.

Firstly, we've managed to attach the instance to TFS for source control but, when we open a project, we get the following errors:-
"The source control provider associated with this solution could not be found. The project will be treated as not under source control. Do you want to permanently remove source control bindings from the project?"
This gives Yes/No/Help buttons.

If we select No (we don't want to remove anything from source control), we get the following:-
"The project file xxx is not bound to source control, but the solution contains source control binding information for it. Do you want to open the project using source control binding information from the solution or open it as unbound and fix the solution file?"
This give the following options:-
Use solution binding
Remove solution binding
Help
(There's also a box for "Apply this selection to all project being opened now).

We select "Use solution binding" and the solution opens.

We've found this this is a false error as we can make changes, check them in and they apply to the solution if someone else does a Get Latest on the same solution.

Any help on sorting this would be appreciated.

Secondly, we are missing the blue padlock icons, red ticks, etc. for source control.
I'm assuming this is connected to the first issue, but if it's different, we'd appreciate any help on this one as well.
tapan.1010
tapan.1010
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 258
Facing same issue while using VS 2017 as a part of SSDT 2017. I am able to perform all source control actions and same is getting reflected in source control explorer too, but as seen in RED box, lock icon is not there in front of files.


Mark Schmidt
Mark Schmidt
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 52

I had this same issue, and I solved the problem by uninstalling SSDT 2017 (after first uninstalling the Integration Services Projects, Analysis Services Projects, and Reporting Services Projects extensions, which may have been overkill), and installing Visual Studio Community (free software) with only SQL Server Data Tools selected as the functional parts included, and then re-installing SSDT 2017 and selecting only Integration Services when asked which functionality I wanted it to provide. Now it works like a charm with TFS.​





richardmgreen1
richardmgreen1
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4236 Visits: 1190
Thanks Mark.
I'm not sure we can do that as it's for a business.
Mark Schmidt
Mark Schmidt
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 52
I know what you mean, and I was hesitant to use Community edition too, as I am working for a government entity, but after reading the license terms I was pretty sure that I was covered, at least under the conditions that I would use the software (merely to facilitate my being able to create and edit SSIS packages and store them on TFS). You may be able to use it within the bounds of the license too - check it out.



richardmgreen1
richardmgreen1
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4236 Visits: 1190
Hi Mark

I work for my local NHS Trust.
I'll dig out the licence terms (unless you have a handy link?) and have a look.
Mark Schmidt
Mark Schmidt
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 52
I just so happen to have a handy link, my good man! Here it is - https://www.visualstudio.com/license-terms/mlt553321/ .



richardmgreen1
richardmgreen1
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4236 Visits: 1190
Thanks Mark - I'll pass this to our licencing people and see what they say.
Mark Schmidt
Mark Schmidt
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 52
You're welcome!



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search