Under Authentication, select a method from the list: Username/Password, Kerberos, or NTLM.Įnter credentials in the User Name and Password boxes.
Get this information from the database administrator.
Select Data > Get External Data > New Database Query > SQL Server ODBC. The Connect to SQL Server ODBC Data Source dialog box appears.Įnter the server in the Server Name box, and optionally, enter the database in the Database Name box.