| Author |
Topic |
|
moebelwachs
Starting Member
6 Posts |
 Posted - 2009-09-03 : 08:14:27
|
| hello,(dont laugh)our sa password wont work anymore, i cant explain this. while making a backup of a database there must have happened sth. so:- what category is this ? (doesnt matter, critical, fatal, disaster)- is there any way to restore this password?- can i give sa a new one ?would be nice to get some positive feedbackregardsw.thoma |
|
|
moebelwachs
Starting Member
6 Posts |
Posted - 2009-09-03 : 08:18:09
|
| ..oh... forgot : its a sql2005 server |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-03 : 08:24:11
|
go to / login to the box where sql server is installed and try to connect via windows authentication.Greetings from Hamburg!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
moebelwachs
Starting Member
6 Posts |
Posted - 2009-09-03 : 08:29:30
|
Hello, thanks for first..actually ive no problem with the machine, windows authentication works fine, BUT what could happen if sa's password is away?thanks a lotw.thomaquote:
Originally posted by webfred
go to / login to the box where sql server is installed and try to connect via windows authentication.Greetings from Hamburg!
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-03 : 08:35:31
|
I thought login directly to the box as admin connect then to sql server via windows authentication and then you should have the right to set the sa-pwd...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
moebelwachs
Starting Member
6 Posts |
Posted - 2009-09-03 : 08:54:29
|
Hallo :) ...deutsch kann ich besser ;)Wenn ich das PAsswort ändere... gibts irgendwelche Dienste oder so die unter dem ALTEN sa passwort laufen ? Muß ich da noch wo das NEUE sa passwort eingeben ? Nicht dass mir die Maschine komplett stehenbleibt..Danke,Schöne Grüße aus MünchenW.Thomaquote:
Originally posted by webfred
I thought login directly to the box as admin connect then to sql server via windows authentication and then you should have the right to set the sa-pwd...
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-09-03 : 09:10:59
|
| if you sysadmin right on the server you can change the sa password to whatever you want |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-03 : 09:22:26
|
Überall dort, wo Verbindungen über den SA-Zugang hergestellt werden (vielleicht z.B. in SSIS-Paketen/Jobs) müssen Anpassungen vorgenommen werden. Das merkt man spätestens, wenn irgendwelche Steps auf die Bretter gehen - sorry.Trying to translate  Each existing "step" which uses SA-Account to connect to the server (maybe in some SSIS packages) is to change to use the new PWD. You will find that steps at latest when they are crashing.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-03 : 09:25:01
|
Hey! Your age is 99 (in profile) - so take away your fingers from that modern stuff!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
moebelwachs
Starting Member
6 Posts |
Posted - 2009-09-04 : 07:46:09
|
quote:
Originally posted by webfred
Hey! Your age is 99 (in profile) - so take away your fingers from that modern stuff!
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
moebelwachs
Starting Member
6 Posts |
Posted - 2009-09-04 : 07:47:25
|
Hm, perhaps youre right... the last post i forgot to fill in content ;)thanks for allquote:
Originally posted by moebelwachs
quote:
Originally posted by webfred
Hey! Your age is 99 (in profile) - so take away your fingers from that modern stuff!
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
|
sa password lost