Export (0) Print
Expand All
Expand Minimize

Log Shipping Details

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Use this dialog box to view or specify the following options. This dialog box is only available when one secondary database is in standby mode.

Options

SQL Server

View the monitor server name.

Use Windows authentication

Use Windows Authentication when connecting to an instance of Microsoft® SQL Server™. It is recommended that you use this option for security because users who connect through a Microsoft Windows NT® 4.0 or Windows® 2000 user account can make use of trusted connections. Trusted connections are those validated by Windows NT 4.0 or Windows 2000.

Security Note  When possible, use Windows Authentication.

Use SQL Server authentication

Use SQL Server Authentication to connect the monitor server. When a user connects with a specified login name and password from a nontrusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails and the user receives an error. For more information about SQL Server Authentication, see Authentication Modes.

Login Name

View the login name for the monitor server, if the server is connecting using SQL Server Authentication.

Password

View or specify the password for the monitor server, if the server is connecting using SQL Server Authentication.

Log Shipping Role

View information about the role of the monitor server.

See Also

Log Shipping

Show:
© 2014 Microsoft