al4629740

<div>
<div class="content wysiwyg-content">
I ran a query to see what connections existed to the SQL database and this is what I got. &nbsp;My question is why are there 23 connections from sa if I had disabled the login to sa. &nbsp;Are these system connections?<br />
<br />

<pre><code id="code-10-29180812-1">DBName	NumberOfConnections	LoginName
master	2	capsqluser                                                                                                                      
msdb	1	capsqluser                                                                                                                      
CAPRegistration	5	capsqluser                                                                                                                      
msdb	3	NT SERVICE\SQLSERVERAGENT                                                                                                       
master	23	sa                                                                                                                              </code></pre>
</div>
</div>


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?

(CODE)

What are these SQL connections

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.