troubleshooting Question

What are these SQL connections

Avatar of al4629740
al4629740Flag for United States of America asked on
1 Comment1 Solution20 ViewsLast Modified:
I ran a query to see what connections existed to the SQL database and this is what I got.  My question is why are there 23 connections from sa if I had disabled the login to sa.  Are these system connections?

DBName	NumberOfConnections	LoginName
master	2	capsqluser                                                                                                                      
msdb	1	capsqluser                                                                                                                      
CAPRegistration	5	capsqluser                                                                                                                      
msdb	3	NT SERVICE\SQLSERVERAGENT                                                                                                       
master	23	sa                                                                                                                              

Open in new window

Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros