News

I needed to change SQL Server Account and Agent Account names and passwords across 15 servers due to a compliance issue. This script can streamline that process for you. I have included detailed ...
Learn how to use OLE DB to change the password of a user account under SQL Server Authentication with this example. When possible, use Windows Authentication. If Windows Authentication is not ...
Ok, for SQL server 2000, I need to change the account it runs under. I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab, and at the ...
Spread the loveIntroduction: The SA (System Administrator) account holds the highest privileges in SQL Server databases. However, it is not uncommon for users to lose or forget the SA password. In ...
Now you should be able to login into SQL server management studio by using the sa user account and the new password….. During the installation of SQL server database (express or standard) the DB ...
If the password could not be changed in SQL Studio Manager, try logging into SQL Studio Manager as an administrator or chaning the password with OSQL.
It sounds like EM was using the sa account to connect, which is a 'bad thing' and this should be changed. It's common practice to set the sa password, test it, seal it and store it away in a safe ...