Return
-
Title
Spotlight Statistics Repository error: not configured to listen with TCP -
Description
Diagnostic Server - Spotlight Statistics Repository Repository error [Connection Error]: Connecting to the Spotlight Statistics Repository failed : The server NNNNNN is not configured to listen with TCP/IP. Put them on default instance. -
Resolution
Move the Spotlight Databases off of the named instance onto the default instance and they should connect. Sometimes, when they were on the named instance, it might say that the instance was not configured for TCP even if it is.