How can we help you today? How can we help you today?
vinodj
Activity overview Badges (0) Posts (3) Comments (8)

Activity overview

Latest activity by 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
  1. Community
  2. SQL Search
  3. SQL Search and Cross Domain SQL Server
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
Feature Request
  1. Community
  2. SQL Search
I would like to request SQL Search to be able to run as different user option because I have a SQL Server setup that is cross domain and there is only a one way trust so I need to run SSMS using th...
1 follower 1 comment 0 votes
So is there anyway to specify what user to use with SQL Search or I am unable to use the software? / comments
  1. Community
  2. SQL Search
  3. SQL Search and Cross Domain SQL Server
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
  1. Community
  2. SQL Search
  3. SQL Search and Cross Domain SQL Server
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
SQL Search and Cross Domain SQL Server
  1. Community
  2. SQL Search
Our SQL Server is on a different domain and I connect using the RunAs executable in SSMS in order to connect to the SQL Server over SSMS However SQL Search is not working as it is getting the follo...
2 followers 4 comments 0 votes
What about my error? Is there any solution for the one that I am getting? / comments
  1. Community
  2. SQL Search
  3. SQL Search does not work on Visual Studio 2017 or SSMS 2017
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
  1. Community
  2. SQL Search
  3. SQL Search does not work on Visual Studio 2017 or SSMS 2017
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
SQL Search does not work on Visual Studio 2017 or SSMS 2017
  1. Community
  2. SQL Search
SQL Search does not work in either Visual Studio 2017 or SSMS 2017 - it keeps saying indexing and does not appear to run to find anything in the search results and I know that there are items that ...
3 followers 7 comments 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
  1. Community
  2. SQL Search
  3. SQL Search doesnt work with SSMS 17
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
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
  1. Community
  2. SQL Search
  3. SQL Search doesnt work with SSMS 17
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
Total activity
14
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3