| Author |
 Topic  |
|
|
Curt
Moderator
USA
5634 Posts
Status: offline |
 Posted - 04/14/2005 : 5:26:11 PM
|
Since so many applications run on MSSQL, it seems that administrators find themselves in the "NOT QUITE A DBA" role.
Publications like SQL Server Magazine are good but often don't address what admins need to know. Books and Magazines for MSSQL are often overkill because they are addressing an audience that is not IMHO the average Administrator.
SO, here is the situation. A VAR sets up an app and does all the implementation. Gives you the keys and says "bye".
You forget the SA password 7 months later.
So! How do ya change the SA password, if you don't know the SA password.
Perhaps this will help.
So! How do ya change the SA password.
Login to the server with an administrative account for that machine. Open Query Analyzer and connect to SQL Server using Windows authentication, not mixed. Run sp_password as show below to reset the sa password:
sp_password @new = 'MRND', @loginame = 'sa'
Try this on test, and if your it works, keep it in your tool box.
One problem though. If you have System DSNs setup in your client's machines to access servers like a Great Plains, Solomon, Navision or MSCRM server, you will have to change them as well.
Who said the job was easy, anyway.
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
(Romans 5:7) . . .For hardly will anyone die for a righteous [man]; indeed, for the good [man], perhaps, someone even dares to die.
|
|
|
cybersteve
Here To Stay
USA
284 Posts
Status: offline |
Posted - 04/15/2005 : 4:56:22 PM
|
Curt -
You got that right. I woke up one morning and discovered I needed to move all our ACCESS databases to SQL Server and get up to speed on supporting and aministering it virtually over night.
It's never boring though. |
Cybersteve
"And so it goes..."
Kurt Vonnegut |
 |
|
|
IG88
Old Timer
Canada
523 Posts
Status: offline |
Posted - 05/05/2006 : 09:36:10 AM
|
Curt,
Can you not just go to Ent Manager and SECURITY then change the SA pw there? Rather then all that Query Analyzer code? |
-=[ IG88 ]=-
General failure reading Hydro Bill: (I)gnore (B)orrow (G)et cut off. |
|
|
|
smeogul
Major Contributor
Canada
1006 Posts
Status: offline |
Posted - 05/05/2006 : 11:45:11 PM
|
changing the security through the gui works with windows authentication, well in SQL 2k5 anyway.
security/logins/sa/properties... done.
I have no idea with SQL only authentication though. I'm sure without SA to begin with it might be tough to get into the gui... just guessing ;) |
Ron |
|
|
|
Wiseman82
Old Timer
United Kingdom
474 Posts
Status: offline |
Posted - 05/06/2006 : 06:18:01 AM
|
There are 2 modes of security - Mixed and Windows only -
Windows Only - The preferred and most secure mode. SQL Logins won't be authenticated (you can still create them though). Administrators of the local machine will be members of the sysadmin role and can perform the same operations as a user logged on as sa.
Mixed - Both Windows and SQL Logins will be authenticated. Unless you need to use SQL Logins for some reason, stick with Windows Only.
You can change passwords for SQL Logins using Enterprise Manager (Under Security, Logins). Forgetting the sa password isn't a problem as long as you are an admin on the local machine. |
David Wiseman
MCSE (2000/2003), MCSA (2003), MCDBA, MCITP:Database Administrator
 |
|
|
|
Mark Minasi
Chief cook and bottle washer
USA
9546 Posts
Status: online |
Posted - 05/06/2006 : 09:20:35 AM
|
And with SQL Server 2005 the old syntax works but is deprecated. In SQL Server 2005-ese, you change the sa password like so:
alter login sa with password='newpassword'
(From Newsletters 48 (MSDE basics) and 50 (SQL Server 2005 basics)
|
Mark
tweetin' at mminasi |
|
|
| |
Topic |
|
So! How do ya change the SA password.
