yourfirstserver.com

Changing the sa Password on the Client

Tweet

You have a variety of options for updating the SQL Server Agent password on the clients. The method you specify depends on the tools available on the client computer.

If the SQL Server Enterprise Manager is available on the client computer, you can change the sa password directly. For details, follow the procedure in Changing the sa Password on the Server.

If Access is available on the client computer, update the password using the Security option on the Tools menu in an Access data project.

If you are using MSDE on the client, there is no user interface for changing the sa password for the SQL Server Agent. You can update the password by accessing the client computer remotely using SQL Server Enterprise Manager on the server.

To change the sa password on the client using Access

1. From the Tools menu in your Access data project, select Database Security.

2. On the Server Logins tab, select sa, and then click Edit.

3. Change the password, and click OK.

You can connect to the client computer remotely to use SQL Server Enterprise Manager to modify the client settings as long as you have created a server alias for your client computer. For details, see Using MSDE with Windows 95/98.

To change the sa password on the client computer without SQL Server Enterprise Manager

1. In the SQL Server Enterprise Manager, right-click the SQL Server Group, and select New SQL Server Registration. If the registration wizard launches, clear the Always run this wizard option, and click OK.

2. Type the name of your client computer, or click Browse to display a list of computer names.

3. Under Connection, select Use SQL Server authentication, enter sa in the Login Name field and the sa password, and click OK.

4. Expand the client computer node you just added, and then expand the Management node.

5. Right-click SQL Server Agent, and select Properties.

6. On the Connection tab, enter the appropriate Password for SysAdmin login ID.

7. Click OK.

After you have changed the client settings, you must synchronize your offline subscription by opening your solution in Internet Explorer and selecting Tools and then Synchronize. A dialog box appears in which you can enter the new password.

source: http://blog.passwordunlocker.com