Hi Tianjiao_Li, I am connected to the server, my SQL Search version is 3.1.5.2031 and the SQL Server is a 2017. I tried to reindex but nothing happened, I looked for the log file and I got this:
06 Sep 2018 10:54:23.544 [207] INFO DatabaseObjectStorage - Inserting job steps into index
06 Sep 2018 10:54:23.545 [215] INFO DatabaseObjectStorage - Inserting objects into index
06 Sep 2018 10:54:23.556 [207] INFO DatabaseObjectStorage - Done
06 Sep 2018 10:54:23.557 [207] INFO DatabaseObjectStorage - Inserting jobs into index
06 Sep 2018 10:54:23.594 [215] INFO DatabaseObjectStorage - Done objects
06 Sep 2018 10:54:23.595 [215] INFO DatabaseObjectStorage - Inserting columns into index
06 Sep 2018 10:54:23.595 [207] INFO DatabaseObjectStorage - Done
06 Sep 2018 10:54:24.520 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents
06 Sep 2018 10:54:24.559 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://productusage.red-gate.com/v1/usageevents
Number of submitted usage events = 1
HTTP status code = 204 NoContent
Response body =
06 Sep 2018 10:54:24.825 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents
Answers
SQL Search should list any servers that you're currently connected to in SSMS. Can you make sure the server is connected in SSMS and reindex?
If it's still not showing, can you confirm the version number of your SQL Search, SQL Server, and check if there is any error in the log?
Tianjiao Li | Redgate Software
Have you visited our Help Center?
I am connected to the server, my SQL Search version is 3.1.5.2031 and the SQL Server is a 2017.
I tried to reindex but nothing happened, I looked for the log file and I got this:
Tianjiao Li | Redgate Software
Have you visited our Help Center?