question

cstephen avatar image
cstephen asked

After renaming SA account,still it there in profiler trace?

Dear Amigos, We are having basic doubt!!!! After installing the sql server with Mixed mode authentication,We renamed SA user with different name due to security attacks.While taking sql server profile trace most of the times login name shows as 'SA'. we not able predict why it is still there? Is There any Hacking happend in my server. Even when we look at running processes through sp_who, we see that 'sa' is still being used in various background operations Ex: trace in sql server: Event class Binary Data login name Lock:Acquired oxo.. Sa Regards, Stephen
securityprofilertracesa
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.
0 Likes 0 ·
H_G_H avatar image
H_G_H answered
Try this ALTER LOGIN sa DISABLE; GO ALTER LOGIN sa WITH NAME = [SQLGuru]; GO Good Luck
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

cstephen avatar image cstephen commented ·
Hi, We renamed SA Login with different name.but profiler trace it showing login name as 'SA'.But we are not sure whether sa login has disabled? And my basic question is? Suppose i Disabled sa login.How can i renamed?
0 Likes 0 ·
H_G_H avatar image
H_G_H answered
ALTER LOGIN sa DISABLE; GO ALTER LOGIN sa WITH NAME = SQLGuru; GO ALTER LOGIN SQLGURU ENABLE ; GO
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.