Subscriber Discussion

Software Package Not Working, We Suspect A SQL Issue, Is There A Way To See What Programs Are Using SQL On PC?

JH
Jay Hobdy
Jun 26, 2018
IPVMU Certified

Is there any way to see what programs on a PC are using SQL?

We have a new software package and we suspect it is not working properly due to other software using SQL.

Avatar
Brian Rhodes
Jun 26, 2018
IPVMU Certified

Do you want to see which programs are using a specific SQL database?  Or just check to see if they are using SQL in operation?

JH
Jay Hobdy
Jun 26, 2018
IPVMU Certified

I think just seeing what is using SQL would be a good start. I know Milestone (server and client) and DoorKing are installed on that laptop. Not sure if they use SQL

 

The software we are having issues with is from DSC for alarm panel programming. I am not a programmer but I can't see them using the same databases

Avatar
Jared Tarter
Jun 26, 2018
Milestone Systems

Do you know if the application you are using is trying to use SQL Server Authentication as opposed to Windows Authentication?  If so, that may be the issue if SQL was installed when you installed the Milestone software because when our software installs SQL Server Express, it turns off the SQL Server Authentication feature.  It can be turned back on using SQL Server Management Studios.

Outside of that, I'm not aware of anything else we are doing to SQL that would prevent another application from using it.  I have loaded databases from 3rd party application into an instance of SQL Server that our software installed without issues, except for having to enable SQL Server Authentication in some cases.

(2)
Avatar
Sean Patton
Jun 27, 2018

I did find this note regarding the DSC DLS software:

If you are trying to run DLS 5 software, it doesn't actually use SQLExpress. It uses a database engine called SQLite

U
Undisclosed #1
Jun 26, 2018
IPVMU Certified

Is there any way to see what programs on a PC are using SQL?

Stop the service, see what fails?

(1)
(1)
Avatar
Sean Patton
Jun 26, 2018

Do you have SQL Server Management Studio installed?

There is an Activity Monitor in SMS that should be able to show you which services are connected to which DBs.

Milestone Server definitely uses SQL, I do not know about DoorKing and couldn't figure out if it does through googling.

JH
Jay Hobdy
Jun 26, 2018
IPVMU Certified

 

 

 

 

 

That is what I get when I try to search this laptop with"sql"

 

It looks like SMS is free but I am going to try on another PC first. I suspect I am getting into an area where I know just enough to be dangerous...lol

Avatar
Sean Patton
Jun 27, 2018

SMS is free, and it is possible to mess something up using it, but if you're going to be working with software that utilizes SQL, it doesn't hurt to start getting comfortable with using it. Is this a production system, or just test/dev environment?

The tests that UD2 described below are good for seeing if anything is connected, but I am not 100% sure that it will really help get to the bottom of your issues.

Also, to take 2 steps back, did you try contacting DSC?

 

U
Undisclosed #1
Jun 26, 2018
IPVMU Certified

SMS may be of help, but its worth noting that SQL Server could be (unless explicitly restricted) accessed at any time by any process, possibly any machine on the LAN, if it is presented with a valid login/password.  

 

(1)
U
Undisclosed #2
Jun 27, 2018

netstat -aon

see any established tcp/upd ports on 1433, 1434, 2383, 2382, 135, 80, 443?

same row on established ports, see the PID?

find that PID in task manager. looking for anything else outside your NIC? fire up wireshark.

if there are errors in sql, run sql profiler and filter it for errors. does dsc install folder have any syslog files you can take a peek at?

(1)
(2)
U
Undisclosed #1
Jun 27, 2018
IPVMU Certified

Also, many packages install their own copy of SQL Server (Lite) by default, so it’s concievable that you may have more than one instance running.  

(1)
(2)
JH
Jay Hobdy
Jun 27, 2018
IPVMU Certified

Yes, DSC is the one that suggested it could be an issue with SQL. Before I request escalated support, we are going to try another PC. Right now I am 0/2 but they both have various items like Milestone,Unifi, etc that may conflict. I have a laptop from my marketing person that shouldn't have much installed. I will try that.

 

This is the first time we have used the DLS software and we only have one cable and one alarm panel. We do have a second panel we could test on, but trying to rule out some other items before we stage another panel.

 

Its possible the issue could be the cable or panel but not likely.

 

 

New discussion

Ask questions and get answers to your physical security questions from IPVM team members and fellow subscribers.

Newest discussions