Connecting to the Integration Services Server


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.

Tip

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


Note

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


Note

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.

1.

Launch Management Studio.

2.

In the Object Explorer window, click the Connect button.

3.

Select the Integration Services menu option.

4.

The Connect to Server dialog box opens, as shown in Figure 17.10.

Figure 17.10. Connecting to the Integration Services Server


5.

Select or type in the server name to which you want to connect.

6.

Click the Connect button.

Note

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.



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net