User's Manual

Migrating the Dell OpenManage IT Assistant Discovery Settings 33
• Microsoft Windows Authentication — Ensure that the username and
password is the same for both IT
Assistant and Dell Management Console.
• Mixed/SQL Authentication — Provide the administrator SQL login
credentials for the IT
Assistant database. The given SQL login credentials
should be e
nabled and have the appropriate server roles and user mapping
for the remote database.
IT Assistant creates its database in the Windows Authentication mode only.
To use SQL Authentication, change the authentication mode. For more
information, see "Enabling SQL Server and Windows Authentication" on
page 33.
IT Assistant supports the default instance of the remote database. If you
have configured the database for IT Assistant with the named instance,
specify the named instance along with the server name, for example,
MyServer/NamedInstance.
Enabling Remote Connection to SQL Server 2005 or 2008 Express
By default, SQL Server does not automatically connect to a remote database;
you have to enable it manually. Use the Microsoft Windows’ ODBC Data
Source Administrator tool to verify your remote database connection. If you
connect to a remote SQL Server without first enabling the remote
connection, an error is displayed.
To resolve this error, do the following:
• Enable both the SQL Server and Windows authentication mode on
the
SQL Server.
• Enable remote connection using the TCP/IP protocol.
Enabling SQL Server and Windows Authentication
To enable SQL server and Windows Authentication:
1 Log into the SQL Server using SQL Server Management Studio Express
on the local SQL Server using Windows Authentication user credentials.
Windows account is used to authenticate to SQL Server.
2 In Object Explorer , right-click the instance name and select Properties .
book.book Page 33 Monday, August 8, 2011 9:23 AM