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]
|
Home > StuffLearned >