System administration and maintenance > Database administrator tools > Utility functions

Modify SQL services logon

In order to back up the VCAT database to a destination drive that is not on the SQL database machine, it may be necessary to modify the SQL services service logon.

To modify the logon, perform the following steps:

  1. Log on to the SQL database machine (the source machine) as the local administrator. (To configure service startup, you must be logged on with a user account that has membership in the Administrators local group.)
  2. Select Start → Settings → Control Panel → Administrative Tools.
  3. Double-click Services.
  4. Select the named SQL Server instance, SQL Server (MSSQL Server).
    Note

    There can be other named SQL Server instances depending on what DeltaV functions or other applications are installed. For VCAT, select SQL Server (MSSQL Server).

  5. Right-click and select Properties.
  6. Click the Log On tab.
  7. In the Log on as section, click the This Account: button.
  8. Click the Browse button to browse for the account. The account must already exist in Windows User Manager.
  9. Enter the name and click Check Names.
  10. Click OK if the name is found.
  11. Enter the password for that account on the Log On tab.
  12. Repeat the process, selecting the SQLServerAgent service.

Use the following table to determine the type of account to use and what the password must be.

If you are backing up to: MSSQLServer and SQLServerAgent Services Account log in as: The destination machine: Security access on the destination machine:
a computer on the same domain a domain account uses the DeltaV domain account The DeltaV domain account must have write access to the backup destination.
a computer on a different domain with a domain trust relationship a domain account uses DeltaV domain account

Note Grant access to remote network and directory to the DeltaV domain account.

 The DeltaV domain account must have write access to the backup destination.
a computer on a different domain without a domain trust relationship a local or domain account must have a local account with same name and password The local account must have write access to the backup destination.
a computer in the same or another workgroup a local account must have a local account with same name and password The local account must have a backup destination.

The destination (where the backup will be written) must be a shared device and the MSSQL services logon account must have Change permission to the destination folder.

To configure the share, perform the following steps:

  1. Go to the destination machine.
  2. Right-click the drive or folder where the backup will be written.
  3. Select Sharing.
  4. Select Shared As and provide a share name.
  5. Set the User Limit.
  6. Click Permissions.
  7. Click Add and select the MS SQL services user account (the one that MSSQLServer and SQLServerAgent are using for logon on the source machine).
  8. Select Type of Access as Change.
  9. Click OK until all dialogs are closed.

For more information on configuring sharing, refer to the Windows help system.

To set the permissions on the backup folder, perform the following steps:

  1. Right-click the folder where the backup will be written. This can be a subfolder of the share.
  2. Select Properties.
  3. Select the Security tab.
  4. Click the Permissions button.
  5. Set the MS SQL services user account (the one that MSSQLServer and SQLServerAgent are using for logon on the source machine) to be listed with Change access. The account needs the ability to read from that folder, write to that folder, and create new files and folders in that folder.
  6. Click OK until all dialogs are closed.

For more information on permissions, security, and access type, refer to the Windows help system.

Related information