What are the challenges you face when working across database platforms? Take the survey
Options

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..?
Tagged:

Answers

  • Options
    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?
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    canzorenacanzorena Posts: 2 New member
    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 =

  • Options
    Can you uninstall SQL Search and reinstall using this installer?
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    lldooleylldooley Posts: 1 New member
    I'm having the same issue with the latest version of SQL Search 3.4.1.2506.
Sign In or Register to comment.