Re: sa account Connections

I should have said, 'through 50'. User SPIDs start at 51. - RLF


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:%23TGnuPG$HHA.5948@xxxxxxxxxxxxxxxxxxxxxxx
Tomm,

SPIDs below 50 are system spids. These are processes that SQL Server
itself uses to get work done on the server. If all you 'sa' connections
are in this range, then you are just seeing the system at work.

RLF

"Tomm" <Tomm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F53677A6-8E1A-4CA5-B2E6-D149261FE914@xxxxxxxxxxxxxxxx
I have a question that I can't seem to figure out. When I install a SQL
2000
w/SP 4 and no other users except for myself and sa, I see that the 'sa'
account is connected to SQL. I'm using my server account to logon, I
don't
have any startup stored procedures that are using the account and the SQL
Agent is using Windows Authentication to connect to SQL Server.

My question: What is using the sa account to connect to SQL Server?

I did a profiler on the server and excluded everything but sa and it
turned
up nothing. They all have a status of "background" and the command is
"Task
Manager"




.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Problems with WebParts
    ... The connection string specifies a local SQL Server Express instance using a ... database location within the applications App_Data directory. ... server account must have read and write access to the applications directory. ... logged-in user needs the dbcreator privilege in the appropriate SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)