User profile for vinodj

Hi - just checking to see if there are any updates to this I like the RedGate products in fact we have a license for SQL Source Control and SQL Prompt which I love But wanted to also use the search tool - thanks / comments

Hi - just checking to see if there are any updates to thisI like the RedGate products in fact we have a license for SQL Source Control and SQL Prompt which I loveBut wanted to also use the search t...

0 votes

So is there anyway to specify what user to use with SQL Search or I am unable to use the software? / comments

So is there anyway to specify what user to use with SQL Search or I am unable to use the software?

0 votes

it is done by creating a shortcut on the desktop to the RunAs command in Windows and then providing the path to SSMS Executable Here is the shortcut path "C:\Windows\System32\runas.exe /netonly /user:STELLARISHEALTH.NET\VJACOB1 "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe" / comments

it is done by creating a shortcut on the desktop to the RunAs command in Windows and then providing the path to SSMS Executable Here is the shortcut path"C:\Windows\System32\runas.exe /netonly /us...

0 votes

What about my error? Is there any solution for the one that I am getting? / comments

What about my error? Is there any solution for the one that I am getting?

0 votes

Alex, Now after I deleted the indexes - both VS and SSMS completely crash when you try to use the SQL Search Add-in The index for the server has been recreated. Here is the error from the logfile 29 Oct 2018 15:44:14.212 [1] ERROR RedGate.SQLSearch.Addin - LogService caught unhandled exception in AppDomain: 'Value cannot be null. Parameter name: collection' System.ArgumentNullException: Value cannot be null. Parameter name: collection at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at RedGate.SQLSearch.Addin.Tab.Controls.DatabasePickerControl.PopupOpening() at RedGate.SQLSearch.Addin.Tab.Controls.PickerControlBase.ShowPopup() at RedGate.SQLSearch.Addin.Tab.Controls.PickerControlBase.CheckedComboBox_MouseClick(Object sender, MouseEventArgs e) at System.Windows.Forms.Control.OnMouseClick(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.UserControl.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) / comments

Alex,Now after I deleted the indexes - both VS and SSMS completely crash when you try to use the SQL Search Add-in The index for the server has been recreated.Here is the error from the logfile29 O...

0 votes

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? / comments

I am running SSMS 14.0.17277.0SQL Search does not work for me at allIt 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...

0 votes

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 } } ] / comments

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 rightsBut I would imagine...

0 votes

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. / comments

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 use...

0 votes

How can we help you today?

vinodj

Comments