TFS upgrade ERROR: TF400255: The SQL instance MSSQLSERVER does not exist on the local machine

0
votes

I'm new to TFS, can anyone help with this? I upgraded TFS from 2013 update 3 to update 5. The error says it can't find MSSQLSERVER instance but MSSQLSERVER services is running.

Log output:

+-+-+-+-+-| Running SqlIsRunning: Verifying that SQL instance is running if local |+-+-+-+-+-
[Info @00:51:59.719]
[Info @00:51:59.719] +-+-+-+-+-| Verifying that SQL instance is running if local |+-+-+-+-+-
[Info @00:51:59.719] Starting Node: VSQLISRUNNING
[Info @00:51:59.719] NodePath : VINPUTS/Conditional/Progress/VRSINSTANCEVRSION/VSQLISRUNNING
[Info @00:51:59.720] Node returned: Error
[Error @00:51:59.720] TF400255: The SQL instance MSSQLSERVER does not exist on the local machine.
[Info @00:51:59.720] Completed SqlIsRunning: Error

enter image description here

1
sqlwindowstfstfsbuild
You write MSSQLSEVER services is running, which is not the same as MSSQLSERVER. Count the number of letters in each, and then see if you can figure out which one is missing. – Ken White
definitely a spelling error, it should be "MSSQLSERVER service running" – Tim Vo
It's your responsibility to provide accurate information when asking us for help. Instead of retyping, copy/paste the error message. If you're unable to do that, then read your typed message very carefully to insure you don't introduce new errors or problems. And if it's a typo, then edit to correct it instead of saying so in a comment. – Ken White
Point taken Ken. Thanks Leo for the edit. – Tim Vo
@TimVo, Are your SQL server and your TFS server installed on the same machine? – Leo Liu-MSFT

1 Answers

0
votes

thank you all for you help. Apparently when I specified the Server in "DATABASES", I also have to specify the port (SERVER,port). Oddly enough with just specifying the server name and clicking on "test", the connection checks out. Nevertheless the verify portion went through.