Microsoft indexing service is used to search files in the native file system on the server.
Troubleshooting
1) Create a index in the indexing service here i use 'test'
2) In the SQL Manager instaciate this as a linked server
EXEC sp_addlinkedserver
@server = 'test',
@srvproduct = '',
@provider = 'MSIDXS',
@datasrc = 'test'
3) Query the index
SELECT * FROM OpenQuery(test,
'SELECT rank, HitCount, FileName, Size, DocAuthor
FROM SCOPE()
WHERE CONTAINS( Contents, ''"Text to search for"'')'
)