Posts

TFS 2017 Upgrade issue

hello, we running on tfs 2015 update 3 rc1, while upgrading latest tfs 2017 received error stating tfs 2017 not support sql server 2012 database instance. in next step installed sql 2016.  now moving ahead during upgrade in server configuration wizard sql server instance should given input(sql 2012 or new sql 2016 instance). does tfs 2017 upgrade takes care of moving tfs databases new instance of sql 2016? if possible please provide upgrade steps in detail scenario: tfs 2015 update 3 rc 2 (with sql 2012 db instance) tfs 2017. regards, santhosh hi santhosh tfs upgrade wizard not copy databases sql instance. do want upgrade tfs 2015.3 rc1 tfs 2017 replacing existing intance (inplace upgrade) or createing new instance. if plan perform inplace upgrade should upgrade existing tfs 2015.3 rc1 installation sql 2012 sql 2014 or sql 2016 - both version supported tfs2015 update 3) , perform inline upgrade tfs 2015.3 tfs 2017. your initial posting bit confusing you're wri...

Expressions not working after exiting a Sequence Container

Image
i have ssis package pretty simple. an execute sql task returns 1 row 2 values correctly stored variables. based off 2 variables, sequence container chosen execute. that sequence container magic. last step of container has execute sql task runs , stores result in variable - let's call [user::result] type int32. based off value in [user::result] 1 of 2 final tasks run. non 0 value executes 1 task; 0 value executes another. basically, something runs after this. simple? thought so... except step 4 doesn't work. if set post-execute breakpoint on sequence container, variables populated expected, nothing else runs. if add task run (without conditional expression) run after sequence container completes, pre-execute breakpoint shows data looking expect. those script tasks messagebox.show calls , expression, can see, doesn't use variables @ all. dealing bug or really stupid? edit: attached screenshot show sample of going wrong. the p...

Installing and configuring SQL server 2012 network options

hello i'm hoping here can i'm investigating deploying on availability groups. i have 2 out standing questions. what network protocol used availability group synchronization (needed check our optimisation tools can work ) believe it's standard tcp/ip if not can 1 confirm. can sql 2012 share dark network exchange? i've been searching online can't find solution. thanks in advance sql service uses either port 80 or 8080 , underline transport layer tcp. data transfer done in xml. can either setup credentials using sql or use windows credential uses group policies don't have to use connection statement username , password. automatically done under hood remote windows connection. can setup database in sql using single windows credential password , add users windows group don't have add each user database credentials. jdweng SQL Server ...

How to add a field value with the copied over field value

in bug.xml, i've " completed work " field control dev uses log number of hours took resolve bug. if qa reopens bug, dev work on , log hours in " completed work " field. in case, logged hours lost.   now, i've created new " total work " field copies value " completed work ". this works fine. i want behave like: totalwork += completedwork . how accomplish this? from research, cannot done. way write custom task or program listens tfs workitem events , addition. thanks in advance. =========================================================== note: thread extension below thread: http://forums.microsoft.com/forums/showpost.aspx?postid=2290154&siteid=1 unfortunately, you're right - type definitions not support such rules.   alex. Archived Forums V  >  ...

Visual Studio 2003 and SQL Server Express

i'm attempting connect sql server express instance through visual studio 2003.  when go data connections, choose microsoft ole db provider sql server, fill in parameters server (server name, username, password, database).  when click "test connection" goes through successfully.  when click "ok" create data connection, fails saying username , password should checked.  changed username , password "sa" account created when installed sql server express, , got same successful connection test, failure when tries create connection.  suggestions?  thanks! i tried connect instance of sql server 2005 express on machine using visual studio 2003 , successful using both sql authentication windows authentication. when provided sa passoword (sql authentication) , clicked ok after testing connection using "test connection" button, prompted me again sa password. re-entered sa password , able successful connection. there no prompting password when tried co...

Create a new Silverlight enabled aspx page

 hi when create new silvelright application project, new page named testpage.aspx , testpage.html created, after making startup page these page.xaml page opens it, want create page newtestpage.aspx , open new xaml page it, steps have taken. sachin mukhija   create aspx page. add reference xap <asp:silverlight id="xaml1" runat="server" source=" ~/clientbin/hittestexample.xap " minimumversion="2.0.30523" width="100%" height="100%" />  now xap file contains silverlight application , default opens page.xaml. can chage other app.xaml.cs file  this.rootvisual = new page() ;   change other user control , open. Silverlight  >  Programming Silverlight with .NET – General ...

New idea for someone developing silverlight applications

since don't want redundant, i'll talked alot think microsoft planning surface on windows 8 pro in last post......the whole idea of being game changer, due way make people work , think better together, in shared work ( collaborative) environment....and nature of tablet drastically enhances shared work environment, optimizing connections between working together--keeping them more directly plugged in each other--less "removed" occurs when hiding behind laptops.... microsoft banking on this, leads me idea developer..... how silverlight app calls bing search word tablet owner has uttered mic on surface ( either mic built in, or 1 of jaw mikes) .... in group of 5 or 6 people, thinking/ discussing best way something........and instant advisable have more information on given word/concept, or idea, or researchable, application--on keying mic, runs search ( tablet owner not have beyond keying mic--maybe before meeting, set categories of search results , parameters, ...