Changing the SQL Server Administrator Login

See Also

When using Windows NT integrated security with SQL Server, the SQL Server login information must be identical to the Windows NT account information. Therefore, if you change the Windows NT password of the domain account that the SQL Server is logged on with, then you also must update the password in the following SQL Server services: MSSQLServer, SQLServerAgent, MSDTC, and the MODTBAD Office Developer DCOM component.

If you change a password, it must be updated on the server, the developer workstation, and the client computers. If the password is not updated for the SQL Server Agent, Access Workflow Designer cannot start and stop the agent automatically. Access Workflow Designer also uses the agent to manage time-out events for team solutions, so it is critical this service be set up properly.

Any time you change a password, it should be updated in the following locations:

Changing the sa Password on the Server

During installation of the Access Workflow Designer server components, you enter the user name and password of the Windows NT domain. When using Windows NT integrated security, this same account information is used by SQL Services. When you change the Windows NT password for that log on, it also must be changed for SQL Server services. For information about changing the password when using MSDE, see Changing the sa Password on the Client.

To set up SQL Server services to log on under a different user account

  1. On the Start menu, point to Settings, and then click Control Panel.

  2. Double-click Services.

  3. Double-click MSSQLServer, SQLServerAgent, or MSDTC. You must update the information for each of these services.

  4. In the Services dialog box, in the Login area, select This account, and then enter or update the account information.

  5. Click OK. Update the other services listed in step 3 as required.

  6. Click Close.

    Important   If Microsoft Full-Text Search is installed on the computer, do not change the MSSQLServer account information in the Services application in Control Panel. Although the Search service is assigned to the local system account, it also tracks the MSSQLServer service account. You must change the MSSQLServer service account in SQL Server Enterprise Manager for the Microsoft Search service to stay synchronized.

Changing the User ID for MODTBAD

During installation of the Access Workflow Designer server components, you enter the user name and password of the Windows NT domain account that the Access Workflow Designer executable (MODTBAD.exe) uses to log on to the domain. Generally, this is the same account used by the SQL Server Services. If this is the case, when you change the Windows NT password for that log on, it also must be changed for MODTBAD.exe.

To change the User ID for MODTBAD

  1. From the Start menu on the server, select Run, and then type DCOMCNFG.

  2. If you have never run DCOMCNFG before and Office is installed on the server, you may see two messages asking if you want to register Msohelp.exe. Click Yes for both messages.

  3. On the Team Solutions tab, select MODTBAD.

  4. Click Properties, and then select the Identity tab.

  5. Under This user, type or browse for the user whose password has changed.

  6. Enter and confirm the new password.

  7. Click OK.

  8. Restart the server.

    Note   The Windows NT domain account used for the MODTBAD identity must have system administrator permissions on the server. However, this account does not have to be the same account used by SQL Server.

Changing the sa Password on the Client

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.