Re: sa account Connections

Correct. Go ahead and change it.

Of course, if some other software in your shop was designed to login as 'sa'
and needed the password that software will have a problem, but the SQL
Server itself will keep running.

And if you have software logging in as 'sa' try to fix it or get rid of it.
:-)

RLF

"Tomm" <Tomm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C245188B-C30A-4218-9AF8-E0CD31F2AC04@xxxxxxxxxxxxxxxx
So if I change the 'sa' password on the server from the one I assigned
during
the installation I should not have an issues, correct?

"Russell Fields" wrote:

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: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • Re: VB app connect THROUGH proxy to a remote SQL database
    ... The whole "HTTP proxy is way more secure than allowing outgoing ... the client app and the SQL server are on ... incoming connections to the SQL server are not the problem - it's ...
    (microsoft.public.dotnet.languages.vb)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)