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

SQL Search doesnt work with SSMS 17

nsundararajannsundararajan Posts: 35 Bronze 5
edited March 1, 2017 6:50PM in SQL Search
SSMS 17 RC2 didn't have SQL Search icon and it's not working.
Tagged:

Comments

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    Thanks for your post!

    SQL Search doesn't support SSMS 2017 RC2 at the moment, I'm afraid, but I will post here once we have a release that supports this.

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    I'm happy to report that SQL Search 2.4 has been released and this supports SSMS 2017 RC2. You can install this update from here: ftp://support.red-gate.com/patches/SQLS ... Search.exe

    Please let us know if you run into any issues!

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • Options
    jcricegpjcricegp Posts: 18 Bronze 3
    Jessica,
    I have the latest release of Search (2.4) and have recently installed the latest release of SSMS 17.0 but do not see the RedGate Tab on the Toolbar menu.

    Is there an additional step that I need to do to activate Search?

    John R.
  • Options
    Sql Search doesn't work with SSMS 17.

    Microsoft SQL Server Management Studio 14.0.17099.0
  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    Hi,

    If you navigate to Control Panel ->Programs ->Programs and Features ->Locate SQL Search 2 in the programs list ->Right Click and select the option to repair. Does this action resolve the problem?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    Hi Eddie,

    No, unfortunately it does not.
    I tried the same with SSMS Integration Pack 1, didn't help.
    I have Sql Prompt as well, and the Tab History button shows up in the redgate toolbar, however Sql Search doesn't.
  • Options
    AchillesAchilles Posts: 1 New member
    edited May 30, 2017 11:29AM
    Hi,
    I experience similar issue. I have installed Sql Search 2.4 on SSMS 13.0.16106.4. I try to unistall Sql Search through "Control Panel\Programs\Programs and Features" individually so to perform a clean install then, but although it seems the unistall process finished successfully the application is still there preventing reinstallation. Make long story sort i cannot unistall SQL Search 2.4 completely.
    Any ideas?
  • Options
    TaliGTaliG Posts: 5 New member
    I'm also getting this issue. Cannot see the SQL search icon in the toolbar in SSMS. Repairing the install doesn't do anything. Neither does resetting the Redgate toolbar.

    Microsoft SQL Server Management Studio 14.0.17099.0
    SQL Search 2.4.0.1203
  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    Hi, thank you to all those who have recently posted here regarding SSMS 2017.

    The last supported version of SSMS 2017 was the RC2 version.

    I have submitted an enhancement request for SQL Search to support the following RTM versions of SSMS 2017.

    SSMS 2017 / 17.0 /V14.0.17099.0
    SSMS 2017 / 17.1 / V14.0.17119.0

    The reference for this request is SDI-715. I will update this post to inform when a new version of SQL Search becomes available.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    Eddie, any update on this? Any ETA? We have to use 2 concurrent versions of SSMS to work around this, and would like to combine everything to SSMS 17.1. Thanks.
  • Options
    I am using SQL Search 2.4.2.1439. I am not getting any search results back from an Azure SQL DB. Does it not support Azure SQL DB?
  • Options
    @MikeyLikesIt - SQL Search supports SSMS 17.1, although you will have to uninstall it and then reinstall to get it to install into 17.1.

    @Rushabh - As far as I'm aware, SQL Search should work with an Azure database. Have you tried reindexing the database? Have a look at this documentation page for more help - https://documentation.red-gate.com/display/SS2/The+search+results+aren't+what+I+expected - if you're still having trouble then I'd recommend that you contact our support team.
    Software Engineer
    Redgate Software
  • Options
    @Rob C Yep, thanks, uninstall and reinstall worked.
  • Options
    PeteKPeteK Posts: 4 New member
    I just rebooted my Windows 2008 R2 server for last Tuesday's updates and now SQL Search 3 won't load in SSMS 17.5. I went to Uninstall or change a program but when I double-clicked SQL Search 3 to try a Repair it said something was wrong and it removed the entry from the programs list. I then ran your installer (I had similar problems a couple of weeks ago and still have the installer on my system) and it displays the following under heading These tools can't be installed at the moment for the SQL Search 3 entry when I go to re-install it: MSI package error.

    Why does this thing keep breaking?!?

    I have CDO. Its like OCD except the letters are in alphabetical order... as they should be!
  • Options
    shaimakem2shaimakem2 Posts: 3 New member
    I'm having the same exact problem, I have SSMS 17.4, Windows 10 and just installed SQL Search tool 3.1 but this tool is not appearing in SSMS... I see it checked when I right click on the SSMS toolbar, please advice.
  • Options
    Hi @shaimakem2 ,

    Is the Redgate toolbar hiding somewhere like this? - 



    If you can see it checked when you right click on the toolbar then SSMS may have decided to add it into a gap that is too small for any of the buttons to be visible. One thing you could also try is to disable the other toolbars to verify that the Redgate toolbar becomes visible. Once you know where it is, you can drag it to a new row so that it can fully expand.
    Software Engineer
    Redgate Software
  • Options
    shaimakem2shaimakem2 Posts: 3 New member
    Thank you Rob, I must've missed it the first time then I installed the previous version and I see the drop down now. 
    Not sure if I'm missing that much if I don't upgrade back to 3.1. 
  • Options
    MehrdadAbdiMehrdadAbdi Posts: 1 New member
    I had this problem on my 2017 ssms, I resolved the issue by dragging the Redgate button to new row on tool bar pan. the icon/buttons were hidden as Rob C show on Image
  • Options
    vinodjvinodj Posts: 11 New member
    I am running SSMS  14.0.17277.0
    SQL Search does not work for me at all
    It keeps saying indexing and does not find anything.

    When I look at the log file that is attached - I do not know what that error however I think this looks like a connection issue.
    How do I specify what login to use to access the database
    or what login does the add-in use when trying to index the database?
  • Options
    vinodjvinodj Posts: 11 New member
    Does anybody know the solution to my error - the sql search does not work in ssms 17 
    Could it be the fact that the user that I am running SQL Search as does not have admin rights
    But I would imagine that would be the case without most users

    Can somebody please help?

    Getting the following errors

    collection of environmental data for usage reporting
    System.Security.Authentication.AuthenticationException: Logon failure: unknown user name or bad password.
     ---> System.Runtime.InteropServices.COMException: Logon failure: unknown user name or bad password.

       at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
       at System.DirectoryServices.DirectoryEntry.Bind()
       at System.DirectoryServices.DirectoryEntry.get_AdsObject()
       at System.DirectoryServices.PropertyValueCollection.PopulateList()
       at System.DirectoryServices.PropertyValueCollection..ctor(DirectoryEntry entry, String propertyName)
       at System.DirectoryServices.PropertyCollection.get_Item(String propertyName)
       at System.DirectoryServices.ActiveDirectory.PropertyManager.GetPropertyValue(DirectoryContext context, DirectoryEntry directoryEntry, String propertyName)
       --- End of inner exception stack trace ---
       at System.DirectoryServices.ActiveDirectory.PropertyManager.GetPropertyValue(DirectoryContext context, DirectoryEntry directoryEntry, String propertyName)
       at System.DirectoryServices.ActiveDirectory.Domain.GetDomain(DirectoryContext context)
       at System.DirectoryServices.ActiveDirectory.Domain.GetComputerDomain()
       at RedGate.Usage.Client.Payload.SessionStarted.SecurityDataSource.IsJoinedToADomain()
       at RedGate.Usage.Client.Payload.PayloadDataSourceBase.GetDataSafely[T](Func`1 getData)
    28 Aug 2018 10:53:31.876 [Redgate.Usage.AsynchronousUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event:
    [
      {
        "eventType": "session.started",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.7.2082",
          "eventUuid": "4d7ef6a8-d6ed-40f8-a037-83accb076be9",
          "usageUserId": "b2ae0b0e-a9e1-4f58-b555-ba2876894b29",
          "sessionUuid": "7dff71e1-b667-4b03-ac38-e9cb41d90da9",
          "createdTimeUtc": "2018-08-28T14:53:30Z"
        },
        "payload": {
          "hostMachine": {
            "software": {
              "operatingSystem": {
                "name": "Microsoft Windows 7 Professional ",
                "is64Bit": true,
                "platform": "Win32NT",
                "servicePack": "Service Pack 1",
                "compatibilityVersion": "6.1.7601.65536",
                "kernelVersion": "6.1.7601.17965"
              },
              "dotNet": {
                "current": {
                  "clrVersion": "4.0.30319.42000",
                  "csharpVersion": "4.7.3130.0",
                  "is64Bit": false
                },
                "frameworks": {
                  "2.0": {
                    "isInstalled": true,
                    "version": "2.0.50727.5420",
                    "servicePack": 2,
                    "release": null
                  },
                  "3.0": {
                    "isInstalled": true,
                    "version": "3.0.30729.5420",
                    "servicePack": 2,
                    "release": null
                  },
                  "3.5": {
                    "isInstalled": true,
                    "version": "3.5.30729.5420",
                    "servicePack": 1,
                    "release": null
                  },
                  "4.0": {
                    "isInstalled": true,
                    "version": "4.7.02558",
                    "servicePack": null,
                    "release": 461310
                  }
                },
                "powerShell": {
                  "version": "5.0.10586.117"
                }
              },
              "localization": {
                "currentCulture": {
                  "name": "en-US",
                  "lcid": 1033
                },
                "currentUiCulture": {
                  "name": "en-US",
                  "lcid": 1033
                },
                "installedUiCulture": {
                  "name": "en-US",
                  "lcid": 1033
                },
                "localTimeZone": {
                  "id": "Eastern Standard Time",
                  "utcOffset": "-04:00"
                }
              },
              "processInformation": {
                "filename": "Ssms.exe",
                "fileVersion": "2017.0140.17277.00 ((SSMS_Rel_17_4).180625-0100)",
                "productVersion": "14.0.17277.0"
              }
            },
            "hardware": {
              "processors": [
                {
                  "numberOfLogicalProcessors": 4,
                  "maxClockSpeedInMHz": 2401
                }
              ],
              "memory": {
                "totalPhysicalMemoryInBytes": 8220127232,
                "errorCorrection": "None"
              },
              "display": {
                "basicDpi": {
                  "x": 96,
                  "y": 96
                },
                "screens": [
                  {
                    "isPrimary": true,
                    "bounds": {
                      "width": 1920,
                      "height": 1080
                    }
                  },
                  {
                    "isPrimary": false,
                    "bounds": {
                      "width": 1440,
                      "height": 900
                    }
                  }
                ]
              },
              "virtualizationInfo": {
                "computerManufacturer": "LENOVO",
                "computerModel": "20JTS0QD00",
                "biosVersion": "LENOVO - 1280",
                "biosBIOSVersion": [
                  "LENOVO - 1280",
                  "N1WET49W (v1.28 )",
                  "Phoenix BIOS SC-T v2.1"
                ],
                "biosSerialNumber": "PC0RZKST"
              }
            }
          }
        }
      }
    ]
    28 Aug 2018 10:53:31.884 [Redgate.Usage.AsynchronousUsageApiClient] INFO  RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 2 events:
    [
      {
        "eventType": "session.started",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.7.2082",
          "eventUuid": "da354d55-1e30-44a6-8849-f54bf12a652a",
          "usageUserId": "583e4d92-ae36-4f07-b811-541e20449493",
          "sessionUuid": "7fe6b308-f4ad-4695-b651-fa8a1d140af7",
          "createdTimeUtc": "2018-08-28T14:53:31Z"
        },
        "payload": {
          "hostMachine": {
            "software": {
              "operatingSystem": {
                "name": "Microsoft Windows 7 Professional ",
                "is64Bit": true,
                "platform": "Win32NT",
                "servicePack": "Service Pack 1",
                "compatibilityVersion": "6.1.7601.65536",
                "kernelVersion": "6.1.7601.17965",
                "systemDrive": "C:"
              },
              "dotNet": {
                "current": {
                  "clrVersion": "4.0.30319.42000",
                  "csharpVersion": "4.7.3130.0",
                  "is64Bit": false
                },
                "frameworks": {
                  "2.0": {
                    "isInstalled": true,
                    "version": "2.0.50727.5420",
                    "servicePack": 2,
                    "release": null,
                    "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v2.0.50727",
                    "is32Bit": true,
                    "is64Bit": true
                  },
                  "3.0": {
                    "isInstalled": true,
                    "version": "3.0.30729.5420",
                    "servicePack": 2,
                    "release": null,
                    "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v3.0",
                    "is32Bit": true,
                    "is64Bit": true
                  },
                  "3.5": {
                    "isInstalled": true,
                    "version": "3.5.30729.5420",
                    "servicePack": 1,
                    "release": null,
                    "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v3.5\\",
                    "is32Bit": true,
                    "is64Bit": true
                  },
                  "4.0": {
                    "isInstalled": true,
                    "version": "4.7.02558",
                    "servicePack": null,
                    "release": 461310,
                    "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v4.0.30319\\",
                    "is32Bit": true,
                    "is64Bit": true
                  }
                },
                "powerShell": {
                  "version": "5.0.10586.117",
                  "executionPolicy": {
                    "currentUser": "Undefined",
                    "localMachine": "Undefined",
                    "userPolicy": "Undefined",
                    "machinePolicy": "Undefined"
                  }
                }
              },
              "localization": {
                "currentCulture": {
                  "name": "en-US",
                  "lcid": 1033,
                  "nativeName": "English (United States)",
                  "englishName": "English (United States)",
                  "isoLanguageName": "eng"
                },
                "currentUiCulture": {
                  "name": "en-US",
                  "lcid": 1033,
                  "nativeName": "English (United States)",
                  "englishName": "English (United States)",
                  "isoLanguageName": "eng"
                },
                "installedUiCulture": {
                  "name": "en-US",
                  "lcid": 1033,
                  "nativeName": "English (United States)",
                  "englishName": "English (United States)",
                  "isoLanguageName": "eng"
                },
                "localTimeZone": {
                  "id": "Eastern Standard Time",
                  "utcOffset": "-04:00",
                  "displayName": "(UTC-05:00) Eastern Time (US & Canada)",
                  "standardName": "Eastern Standard Time",
                  "daylightName": "Eastern Daylight Time"
                }
              },
              "security": {
                "isOnDomain": null,
                "isLocalAdministrator": false,
                "isInLocalAdministratorsGroup": false
              },
              "processInformation": {
                "filename": "Ssms.exe",
                "fileVersion": "2017.0140.17277.00 ((SSMS_Rel_17_4).180625-0100)",
                "fullPath": "C:\\Program Files (x86)\\Microsoft SQL Server\\140\\Tools\\Binn\\ManagementStudio\\Ssms.exe",
                "productVersion": "14.0.17277.0"
              }
            },
            "hardware": {
              "processors": [
                {
                  "numberOfLogicalProcessors": 4,
                  "maxClockSpeedInMHz": 2401,
                  "numberOfCores": 2,
                  "addressWidthInBits": 64,
                  "architecture": "x64",
                  "caption": "Intel64 Family 6 Model 78 Stepping 3",
                  "name": "Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz"
                }
              ],
              "memory": {
                "totalPhysicalMemoryInBytes": 8220127232,
                "errorCorrection": "None",
                "memorySticks": [
                  {
                    "clockSpeedInMHz": 2133,
                    "capacityInBytes": 4294967296
                  },
                  {
                    "clockSpeedInMHz": 2133,
                    "capacityInBytes": 4294967296
                  }
                ]
              },
              "disks": {
                "logicalDrives": [
                  {
                    "name": "C:",
                    "type": "Fixed",
                    "availableFreeSpaceInBytes": 32958525440,
                    "totalFreeSpaceInBytes": 32958525440,
                    "totalSizeInBytes": 128026447872,
                    "format": "NTFS"
                  }
                ]
              },
              "display": {
                "basicDpi": {
                  "x": 96,
                  "y": 96
                },
                "screens": [
                  {
                    "isPrimary": true,
                    "bitsPerPixel": 32,
                    "bounds": {
                      "x": 0,
                      "y": 0,
                      "width": 1920,
                      "height": 1080
                    },
                    "workingArea": {
                      "x": 0,
                      "y": 0,
                      "width": 1920,
                      "height": 998
                    },
                    "effectiveDpi": null,
                    "angularDpi": null,
                    "rawDpi": null
                  },
                  {
                    "isPrimary": false,
                    "bitsPerPixel": 32,
                    "bounds": {
                      "x": 1920,
                      "y": 0,
                      "width": 1440,
                      "height": 900
                    },
                    "workingArea": {
                      "x": 0,
                      "y": 0,
                      "width": 0,
                      "height": 0
                    },
                    "effectiveDpi": null,
                    "angularDpi": null,
                    "rawDpi": null
                  }
                ]
              },
              "virtualizationInfo": {
                "computerManufacturer": "LENOVO",
                "computerModel": "20JTS0QD00",
                "biosVersion": "LENOVO - 1280",
                "biosBIOSVersion": [
                  "LENOVO - 1280",
                  "N1WET49W (v1.28 )",
                  "Phoenix BIOS SC-T v2.1"
                ],
                "biosSerialNumber": "PC0RZKST"
              }
            }
          }
        }
      },
      {
        "eventType": "honeycomb.productswitcher.initialized",
        "headers": {
          "productId": "sql-search",
          "productVersion": "3.1.7.2082",
          "eventUuid": "dc6f97b0-f180-48c9-8aab-6d05fd5d4133",
          "usageUserId": "583e4d92-ae36-4f07-b811-541e20449493",
          "sessionUuid": "7fe6b308-f4ad-4695-b651-fa8a1d140af7",
          "createdTimeUtc": "2018-08-28T14:53:31Z"
        },
        "payload": {
          "currentProgram": "SqlSearch",
          "installedPrograms": [],
          "anyProductsInSwitcher": false
        }
      }
    ]


  • Options
    The error message "unknown user or bad password" tells me you might be using invalid credentials somewhere.  Could you check them?
    Software Developer
    Redgate Software
  • Options
    vinodjvinodj Posts: 11 New member
    The only place where I am using a username and password is on startup because my main user is a member of one domain where as the server is part of another domain, there is a synchronization of users occurring but I need to run SSMS as the user of the domain where the server resides

    Unfortunately this cannot be modified because this data is shared with other locations.
    I have tried without using Run As and it does not work at all.

Sign In or Register to comment.