SQL Search and Cross Domain SQL Server
vinodj
Posts: 11 New member
in 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 following error as shown below. I think that the SQL Search is using the current logged in user and not the run as user.
Is there anyway to fix this and be able to use the great tool that is SQL Search?
Thanks,
However SQL Search is not working as it is getting the following error as shown below. I think that the SQL Search is using the current logged in user and not the run as user.
Is there anyway to fix this and be able to use the great tool that is SQL Search?
Thanks,
07 May 2019 03:53:34.595 [SessionStartedUsageApiClient] ERROR RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Error during 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)
07 May 2019 03:53:34.807 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event:
[
{
"eventType": "session.started",
"headers": {
"productId": "sql-search",
"productVersion": "3.2.6.2313",
"eventUuid": "5816f913-4f31-4a9b-9786-b3c3dea1d8f4",
"usageUserId": "b2ae0b0e-a9e1-4f58-b555-ba2876894b29",
"sessionUuid": "164c930b-1dc1-4a4c-a76d-abcec018314d",
"createdTimeUtc": "2019-05-07T07:53:34Z"
},
"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.3353.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.03062",
"servicePack": null,
"release": 461814
}
},
"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.17289.00 ((SSMS_Rel_17_4).181117-0805)",
"productVersion": "14.0.17289.0"
}
},
"hardware": {
"processors": [
{
"numberOfLogicalProcessors": 4,
"maxClockSpeedInMHz": 2401
}
],
"memory": {
"totalPhysicalMemoryInBytes": 8079618048,
"errorCorrection": "None"
},
"display": {
"basicDpi": {
"x": 96,
"y": 96
},
"screens": [
{
"isPrimary": true,
"bounds": {
"width": 1920,
"height": 1080
}
},
{
"isPrimary": false,
"bounds": {
"width": 1920,
"height": 1080
}
},
{
"isPrimary": false,
"bounds": {
"width": 1920,
"height": 1080
}
}
]
},
"virtualizationInfo": {
"computerManufacturer": "LENOVO",
"computerModel": "20JTS0QD00",
"biosVersion": "LENOVO - 1300",
"biosBIOSVersion": [
"LENOVO - 1300",
"N1WET51W (v1.30 )",
"Phoenix BIOS SC-T v2.1"
],
"biosSerialNumber": "PC0RZKST"
}
}
}
}
}
]
Tagged:
Answers
I agree with your suspicion that SQL Search is attempting to connect as the logged in user and not the Run as user.
I quote from your post: I connect using the RunAs executable in SSMS. I cannot find this option, can you please advise how you select the RunAS option?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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"
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