Database Reference
In-Depth Information
Figure 8-7
.
The SQL Server PDW Destination Editor
Enter your connection information in the SQL Server PDW Connection Manager
Editor using these items:
Server:
The IP address of the Control node on your appliance (Best
practice is to use the clustered IP address to support Control node
failover.)
User:
Your login name for authenticating to the appliance
Password:
Your login password
Destination Database:
PDW_Destination_Example
Staging Database:
StageDB_Example
Let's discuss a few best practices relating to this connection information. First, you
should specify the IP address of the Control node cluster instead of the IP address of
the active Control node server. Using the clustered IP address will allow your connec-
tion to still resolve without manual intervention in the event of a Control node failover.
Search WWH ::
Custom Search