How User Authentication Is Changed
104 Agent for Microsoft SQL Server Guide
Check and Change the ODBC Settings
To check and change the ODBC settings
1.
On the system where Microsoft SQL Server is running, from the Start Menu,
select Control Panel (if necessary) and select Administrative Tools.
2.
Select Data Sources (ODBC). The ODBC Data Source Administrator dialog
opens.
3.
On the System DSN folder tab, select the entry for the appropriate Microsoft
SQL Server instance or instances. For Microsoft SQL Server 7.0, the entry is
called DBASQL7. For Microsoft SQL Server 2000 and 2005, the default
instance is called dbasql_MSSQLSERVER. Other instances use the format
dbasql_ followed by the instance name.
4.
Click Configure. The Microsoft SQL Server DSN Configuration dialog opens.
The name field displays the same name as the entry you selected. The
Description field displays SQL Backup Agent. The Server field displays the
computer on which Microsoft SQL Server is running.
5.
Click Next
without changing any settings
. You are prompted to indicate
whether Microsoft SQL Server should use Windows authentication or
Microsoft SQL Server authentication to verify the authenticity of the login ID:
■
If you are using Windows Only for Microsoft SQL Server, ensure that
Windows authentication is selected.
■
If you are using Mixed Mode for Microsoft SQL Server, select either
Windows authentication to enable both Windows and Microsoft SQL
Server-native user logins or Microsoft SQL Server authentication to
enable only Microsoft SQL Server-native user logins.
■
If you are using Microsoft SQL Server authentication, ensure that the
specified login ID has system administrator access. If you are uncertain,
use
sa
, and consult the Microsoft SQL Server documentation for
instructions on setting the password for this account in Microsoft SQL
Server. Reenter the password to ensure it is correct.
6.
Click Next. If you have specified Microsoft SQL Server authentication, and
either the login ID or password is incorrect, an error message appears. Click
OK to close the error message, reenter the login ID and password, and click
Next.
7.
Click Next and click Finish. The ODBC Microsoft SQL Server Setup dialog
opens, summarizing the settings. Click Test Data Source.
