Owner's Manual

Migrating the Dell OpenManage IT Assistant Discovery Settings 29
• 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.”
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 .
3 On the left pane, select Security and change the Server authentication to
SQL Server and Windows Authentication mode .
4 Right-click the instance name again, select Restart to restart SQL Server
service for the changes to take effect.
book.book Page 29 Monday, April 19, 2010 5:19 PM