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:
· Share on Twitter

Comments

  • 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?


    · Share on Twitter
  • 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?


    · Share on Twitter
  • 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.
    · Share on Twitter
  • RadiRadi Posts: 2
    Sql Search doesn't work with SSMS 17.

    Microsoft SQL Server Management Studio 14.0.17099.0
    · Share on Twitter
  • Eddie DEddie D Posts: 1,807 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
    · Share on Twitter
  • RadiRadi Posts: 2
    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.
    · Share on Twitter
  • 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?
    · Share on Twitter
  • 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
    · Share on Twitter
  • Eddie DEddie D Posts: 1,807 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
    · Share on Twitter
  • MikeyLikesItMikeyLikesIt Posts: 2
    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.
    · Share on Twitter
  • RushabhRushabh Posts: 1
    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?
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    @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
    · Share on Twitter
  • MikeyLikesItMikeyLikesIt Posts: 2
    @Rob C Yep, thanks, uninstall and reinstall worked.
    · Share on Twitter
  • 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!
    · Share on Twitter
  • 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.
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    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
    · Share on Twitter
  • 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. 
    · Share on Twitter
  • 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
    · Share on Twitter
  • 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?
    · Share on Twitter
  • 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
        }
      }
    ]


    · Share on Twitter
  • sam.blackburnsam.blackburn Posts: 224 Gold 2
    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
    · Share on Twitter
  • 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.

    · Share on Twitter
Sign In or Register to comment.