Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Environment:
iQSonar 3.6r5
Windows 2008 server, with SQL 2008 Standard Edition SP3
Actual Behaviour:
The customer wanted to know if it is possible to scan a SQL Server that only has a shared memory setting in SQL Server Network Configuration
No usable issue stored in the context, unable to resolve.


Solution


Panel
bgColor#fff
Source, Instance Name, Database Edition and Database Version from the SQL Server is the information the customer will get with only shared memory protocol enabled.

This can be view in two ways from the UI and Database:

UI:

Analyze > Software > SQL Server Instances

From there they will see the Source, Instance Name, Database Edition and Database Version.

Database:

Once you setup the device to be scanned the customer can run the following SQL using the own IP address

Select * from FoundDevice
Where Hostname = '192.168.0.56'

In this case we got a FoundDeviceID of 408

Once the customer has the FoundDeviceID , you can run the following
Select * from MSSQLReportOverview
Where FoundApplicationID = 386

The data the customer will get

Filter by label (Content by label)
showLabelsfalse
max5
spacesCSKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-troubleshooting-article" and type = "page" and space = "CSKB"
labelskb-troubleshooting-article


Page Properties
hiddentrue


Related issues
Jira Legacy
serverIdf64ffcc9-ad0d-3255-a217-cd901e9e7336
keyCS-1424