Adding SQL Servers

To add a SQL Server as an ESI host controllee:

  1. In the left pane of the ESI window, select Applications > SQL Server.

  1. In the Actions pane, click Add SQL Servers.

  2. In the SQL Servers dialog box, perform one of the following:

  1. Click Start Scanning to locate and list the properties for the specified range of one or more servers.

  2. All accessible SQL Servers are by default set to be added. To not add a specific SQL Server, clear the Checked checkbox for that specific server in the list.

  3. Click Add.

The server appears in All groups.

 

Note: If the "Failed to connect to one or more SQL Server" message appears, one or more SQL Server instances rejected the attempt to open a connection with Windows Authentication. Confirm that firewall and remote settings for the SQL Server instances are set up per Microsoft documentation and that the instances support Windows Authentication. Servers that cannot be accessed are identified as Unknown in the Virtual Machine column.

 

Related links

 

 SQL Server Adapter overview

 ESI overview

 Viewing SQL Servers

 Home window

 Adding SQL Server replicas

 Adding SQL Server databases to DAGs

 Creating SQL Server databases

 Using T-SQL script