The Integration Services Server is a Windows NT Service that provides the underlying functionality for the Management Studio Integration Services node. Of course, you can connect to the Integration Services Server only if the service is running. By default, the server is installed and configured to run automatically when you install Integration Services, but you should check just to make sure.
If you have trouble connecting to the server, you should double-check that the service is running.
Starting the Integration Services Server
To start the server, or to just check if it is running, select the SQL Server Configuration Manager menu option from the Configuration Tools submenu of the SQL Server 2005 Start menu. The SQL Server Configuration Manager appears, as shown in Figure 17.8.
Figure 17.8. Use the SQL Server Configuration Manager to check the server status
You can also launch the SQL Server Configuration Manager from any server node in the Registered Servers window by right-clicking on the node and selecting the Configuration Manager menu option. The same configuration features are available from the Computer Management management console in the Services and Applications node under the SQL Server Configuration Manager subnode.
To modify any of the server settings, right-click on the server you want to change, and select Properties. Figure 17.9 shows the SQL Server Integration Services Properties dialog box where you can modify the start mode and change the account to use for logging on. You can also start, stop, and restart the service in this dialog box.
Figure 17.9. Use the SQL Server Integration Services Properties dialog box to manage the service
The SSIS Service performs the enumeration of all installed components and caches the information for quicker package and designer startup. The SSIS Service Start Mode should always be set to Automatic so that the designer and executing packages can use the cached enumerations instead of doing the costly enumerations each time the designer is opened or a new package is executed.
Connecting to a Local Server
To connect to the Integration Services Server, perform the following steps.
For this version, if you open the Server name drop down and select the Browse for More option, the Browse for Servers dialog box only shows you the local servers and doesn't support searching for remote servers. If you click the Options button, the Connection Properties tab is available, but the settings on this tab have no effect on the connection and should be ignored.
Connecting to a Remote SSIS Server
Connecting to the remote server is straightforward. However, because you cannot use the Browse button to discover other IS servers on the network in this version, you need to know the name of the server and type it in directly.