Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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


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



  • No labels