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.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-12-23 : 01:25:41
|
| Hi,For sql server v2005 sql server authemtication username and password is sa and sa@!23.now i want to change it to abc and abc.how can i do this. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-23 : 11:37:46
|
| in Management Studio, expand the security node, logins. right click sa. type in and confirm new password |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-12-26 : 09:47:51
|
| ALTER LOGIN [sa] WITH PASSWORD = N'new_pw' OLD_PASSWORD = 'old_pw';Jack Vamvas--------------------http://www.ITjobfeed.com (IT jobs) |
|
|
|
priyankaksvrm1111
Starting Member
1 Post |
Posted - 2009-12-28 : 01:36:38
|
| The query posted for changing the sql password credential really worked a lot thanks for posting the query |
|
|
|
|
|
|
Change username and Password in sql server 2005