How can we help you today? How can we help you today?

How can I add a server in SQL Search

I need to use SQL Search in a server but it is not listed in the drop down control and there is no option to add it. How can I do that..?
canzorena
0

Comments

4 comments

Sort by
  • Tianjiao_Li
    Hi @canzorena

    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
    0
  • canzorena
    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:23.598 [Redgate.Usage.AsynchronousUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event:
    [
      {
        "eventType": "index.objects",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.5.2031",
          "eventUuid": "a73b4da6-c38a-4234-8fb6-6e003df40ac5",
          "usageUserId": "052859d7-15da-44c9-8e43-070cda91a885",
          "sessionUuid": "ee0c30bd-c7fb-4502-84c5-0d2337871bdb",
          "createdTimeUtc": "2018-09-06T17:54:23Z"
        },
        "payload": {
          "index-type": "full",
          "time-taken": "53",
          "objects-updated": "662"
        }
      }
    ]
    06 Sep 2018 10:54:23.617 [215] INFO  DatabaseObjectStorage - Done columns
    06 Sep 2018 10:54:23.618 [215] INFO  DatabaseObjectStorage - Inserting objects into index
    06 Sep 2018 10:54:23.625 [215] INFO  DatabaseObjectStorage - Done objects
    06 Sep 2018 10:54:23.643 [Redgate.Usage.AsynchronousUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event:
    [
      {
        "eventType": "search",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.5.2031",
          "eventUuid": "295ff4e5-e02b-4f29-bb0d-b02ed6c45ea2",
          "usageUserId": "22af9272-a50e-417f-b837-d076a84e6672",
          "sessionUuid": "c7226706-782c-4be4-aca8-7b7af5e42fd8",
          "createdTimeUtc": "2018-09-06T17:54:23Z"
        },
        "payload": null
      }
    ]
    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
      Number of submitted usage events = 1
      HTTP status code = 204 NoContent
      Response body =
    06 Sep 2018 10:54:24.521 [Redgate.Usage.AsynchronousUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 2 events:
    [
      {
        "eventType": "index.objects",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.5.2031",
          "eventUuid": "c687debb-5ccd-42fb-b261-92f87abd099a",
          "usageUserId": "052859d7-15da-44c9-8e43-070cda91a885",
          "sessionUuid": "ee0c30bd-c7fb-4502-84c5-0d2337871bdb",
          "createdTimeUtc": "2018-09-06T17:54:23Z"
        },
        "payload": {
          "index-type": "full",
          "time-taken": "80",
          "objects-updated": "235"
        }
      },
      {
        "eventType": "search",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.5.2031",
          "eventUuid": "a387692e-4251-4a16-b050-319ca5b9d00b",
          "usageUserId": "052859d7-15da-44c9-8e43-070cda91a885",
          "sessionUuid": "ee0c30bd-c7fb-4502-84c5-0d2337871bdb",
          "createdTimeUtc": "2018-09-06T17:54:23Z"
        },
        "payload": {
          "searched-databases": "multiple",
          "search-string-length": "13"
        }
      }
    ]
    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
      Number of submitted usage events = 2
      HTTP status code = 204 NoContent
      Response body =

    canzorena
    0
  • Tianjiao_Li
    Can you uninstall SQL Search and reinstall using this installer?
    Tianjiao_Li
    0
  • lldooley
    I'm having the same issue with the latest version of SQL Search 3.4.1.2506.
    lldooley
    0

Add comment

Please sign in to leave a comment.