changing SA password - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

changing SA password

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-09 : 12:22:44

Is there any strategy I should follow in order to change the SA password.Experts answers only. Thanks

=============================
http://www.sqlserverstudy.com

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-06-09 : 12:54:54

quote:
Originally posted by funketekun

Is there any strategy I should follow in order to change the SA password.Experts answers only. Thanks

=============================
http://www.sqlserverstudy.com

strategy?

-ec

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-09 : 13:29:39

No one should be using the sa account anywhere, so you should just be able to change it without modifying anything else.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 09:40:51

using SQL profiler i have traced
Login failed for user 'sa'. But i dont know where is this coming from. Any ideas?

=============================
http://www.sqlserverstudy.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-20 : 09:48:01

add ApplicationName, HostName and NTUserName columns to your trace. that should gove you sufficient info
who is trying to log in unsuccesfully.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 10:07:06

hostname: the same as the one im running sql profiler
application: Microsoft sql server
ntUsername: empty

I only have sql profiler open I dont know where is Microsoft SQL server coming from.

=============================
http://www.sqlserverstudy.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-20 : 11:00:08

That came from sql server locally. Anyone tried to get on it with sa?

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 11:25:41

i dont know. how do you find out.

=============================
http://www.sqlserverstudy.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-20 : 11:29:11

you would get the trace for failed login in your profiler, no?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 11:40:54

yeah, but i dont know who is trying to login. its starting to annoy me.

=============================
http://www.sqlserverstudy.com

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-20 : 11:45:25

ok lets get something straight:
for a failed login event: Login failed for user 'sa'. in your profiler
the values for ApplicationName, HostName and NTUserName are:
hostname: the same as the one im running sql profiler
application: Microsoft sql server
ntUsername: empty
??

if that's so then try turning off the sql server agent.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-20 : 11:51:44

Perhaps you have the bad sa password registered in SSMS or EM. I believe, by default, it polls the SQL Server every minute or so.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-20 : 12:37:42

Or a job owned by SA is trying to run?

Peter Larsson
Helsingborg, Sweden

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-20 : 14:13:12

I disagree that a job owned by sa would cause this. No password is stored with the job. Now job steps would be another story, but those would have been purposeful storing of passwords.

Did you check your SSMS and EM registrations?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 14:18:32

i disagree with peso too.
tkizer.
im using windows authentication and the server is local

spirit1
i restarted the agent. Waiting for now to see if there is login failed on profiler. But i really dont knw how this is going to help.
=============================
http://www.sqlserverstudy.com

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 15:37:26

i have EM and QA running. when i do sp_who

i see 3 spid
EM has 2 and QA has 1

I dunno why EM has 2. I have only 1 registration (local windows nt) running. ITs so weird. any ideas why there are 2. And i think the SA login failed is because of this.

=============================
http://www.sqlserverstudy.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-20 : 16:19:56

From which host?

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-20 : 16:58:56

the same one.

=============================
http://www.sqlserverstudy.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-21 : 11:50:06

Do something in em and check last batch, then kill the one that has earlier last batch timestamp. Check sql log to see if still get sa login failure message.

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-06-21 : 11:55:51

its the distributor properties.
I just wonder if that password is the SA password. I want to get rid of miscellaenous agents as i dont have and publishers. How do you remove the misc agents.?

=============================
http://www.sqlserverstudy.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-21 : 12:32:52

Go to tools -> replication -> disable publishing or distribution.

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources