Authenticate and connect to your SQL Server instance.
On the Establish Connection page, you authenticate your credentials and connect to a specific instance of SQL Server.
List of Options
The following options are displayed.
Server Details
Enter the server instance and authentication details to establish connection to the SQL Server. Based on the requirements of your database or application, select either Windows Authentication or use a specific user name and password to log on to the SQL Server.
- SQL Server Link
- Shows a list of server instances. Click the Ellipsis button to navigate and select the appropriate server instance for your connection.
- Use Windows authentication
- Allows a network user to access the database for this connection without supplying a separate user name or password because these credentials are obtained from the Windows network security process.
- Use SQL Server authentication
- Sets the logon requirements so you must enter a user name and password to open the connection
Note: When you click Next, the utility tests the connection to the instance and validates your credentials on that specific server instance. If there is an error establishing connection or validating your credentials; the appropriate field is highlighted with a corresponding message.