Partager via


SqlServerSystem Element (ICF)

Contains the name of a Microsoft SQL Server instance that hosts the databases for the instance of Microsoft SQL Server Notification Services.

Syntaxe

<NotificationServicesInstance>
    ...
    <SqlServerSystem>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 255 characters in length.

Default value

None.

Occurrence

Required once per NotificationServicesInstance element.

Updates

Can only be updated if you move the databases, re-register the instance, and then update the instance.

Element Relationships

Relationship Elements

Parent element

NotificationServicesInstance Element (ICF)

Child elements

None.

Notes

For nonclustered instances of SQL Server, specify the name in one of the following ways:

  • If Notification Services uses the default instance of SQL Server, use the computer name. For example, if the network name of the computer is DBServer01, use DBServer01. IP addresses and fully-qualified domain names (FQDN) are not supported.
  • If Notification Services uses a named instance of SQL Server, use the computer name followed by a backslash and the instance name. For example, if the computer name is DbServer01 and the instance of SQL Server is named NSData, use DbServer01\NSData as the value.

If the databases are on a failover cluster, use the SQL Server virtual name.

To use a port other than 1433, use the following format for the SqlServerSystem value: tcp:computerName,portNumber\instanceName. An example of this format is tcp:DBServer01,1432\NSData.

You cannot use a period (.), "localsystem", or IP address as the value for SqlServerSystem.

If you are using SQL Server Management Studio to create an instance of Notification Services, the SqlServerSystem value must match the Moteur de base de données instance to which you are connected.

For information about moving the instance to another database server, see Déplacement d'instances de Notification Services.

Exemple

This example shows how to specify that the database server is DBServer01.

<SqlServerSystem>DBServer01</SqlServerSystem>

The following sample shows how to specify that the database server is the NSData instance of SQL Server on server DBServer01.

<SqlServerSystem>DbServer01\NSData</SqlServerSystem>

The following sample shows how to specify that the database server is the NSData instance of SQL Server on server DBServer01, and that Notification Services should use port 1432 to connect to SQL Server.

<SqlServerSystem>tcp:DBServer01,1432\NSData</SqlServerSystem>

The following sample shows how to specify that the database server is the default instance of SQL Server on a failover cluster. The virtual server name is VirtualServer01.

<SqlServerSystem>VirtualServer01</SqlServerSystem>

Voir aussi

Référence

Application Definition File Reference

Concepts

Instance Configuration File Reference

Autres ressources

Spécification du nom du système de base de données
Déplacement d'instances de Notification Services
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005