473,396 Members | 1,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

SQL 2005: Renamed 'sa' account

We have renamed the 'sa' account on a SQL Server 2005 machine. When
we run

SELECT * FROM syslogins

it appears that 'sa' no longer exists as a valid SQL login. However,
when we look at running processes through sp_who, we see that 'sa' is
still being used in various background operations, even when we shut
down and restart the SQL Server. Can someone explain this?

Bill E.
Hollywood, FL
Apr 7 '08 #1
2 2114
My guess is that the reported login name for these internal system processes
is hard-coded as 'sa'. I think this is a bug and will report it on via
Connect feedback (http://connect.microsoft.com/SQLServer) if not already
filed.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Bill E." <bi********@netscape.netwrote in message
news:c5**********************************@e39g2000 hsf.googlegroups.com...
We have renamed the 'sa' account on a SQL Server 2005 machine. When
we run

SELECT * FROM syslogins

it appears that 'sa' no longer exists as a valid SQL login. However,
when we look at running processes through sp_who, we see that 'sa' is
still being used in various background operations, even when we shut
down and restart the SQL Server. Can someone explain this?

Bill E.
Hollywood, FL
Apr 9 '08 #2
Thanks, Dan.

Bill E.

Apr 10 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Joshua S. Gabrielson | last post by:
Greetings, My SQL 2000 Server has been acting strange lately. Someone has gone into the server and changed the SA password. When I go to change the password back to sa, i then verify it and it...
2
by: googlemike | last post by:
On the latest SQL 6.5 with the latest SQL 6.5 service pack, what's the trick to creating an account besides sa that has the power to create databases? I was thinking of calling this account 'sa2'....
5
by: Paul King | last post by:
Ok, Im going crazy now - I had this working a week ago Im using the SA account authentication to my test.aspx page. It was working fine but now I get Login failed for user 'sa'. I had no...
2
by: Les Caudle | last post by:
I un-installed SQL 2000 developer's edition and installed SQL 2005 developer's edition in mixed mode security with the exact same sa password. I then attached my old databases. Even thought...
3
by: Radu | last post by:
Hi. I'm trying to use SQLExpress 2005 (default install vsnet 2005). No matter what I tried, I still can't use it. A. In SQL server configuration manager I have tried the following: 1. Logon as...
3
by: Arpan | last post by:
I recently installed SQL Server 2005 (Management Studio Express) along with SQL Server 2005 Express (Configuration Manager) in my Win2K Pro m/c & use IIS 5.0 to run ASPX projects. I could add my...
9
by: Gabriel | last post by:
Hello, I installed SQL server 2005 SP1 on a Windows XP SP2 From Visual Studio, I'm trygin to create a connection to a database, but I receive this error but I'm creating the connection (I...
3
by: Lee T. Hawkins | last post by:
I am having a number of problems over the last two full days trying to get an ASP.NET 2.0 application to connect to a SQL Server 2005 database... First off, I built this application w/ Visual...
17
by: Anil Gupte | last post by:
I am using the following to try to connect to the database, but it does not seem to be working. Dim sConnString sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.