Home‎ > ‎StuffLearned‎ > ‎

Change sa password in Access

posted Apr 11, 2013, 1:43 PM by Brian Grenier
MS Access ADP project connected to SQL Server, the sa password was lost, there was no authenticated Windows users, just the sa. The data connection/server properties had the sa password saved. So, looked into ways to run sql code to update the password. May have gone this way, making a function in Access and running 
   EXEC sp_password N'old password', N'new password', N'sa';
or
    USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword'
GO
But there was no permission on SQL server for the Windows authenticated user.
So, Went to Access, under Security where was logged on to the connection to the server from Access, change password was right there. Thanks Access Creators Gods, got it changed without knowing the sa password.
Comments