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.
Syntax
<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 |
|
Child elements |
None. |
Remarks
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 Database Engine instance to which you are connected.
For information about moving the instance to another database server, see Moving Instances of Notification Services.
Example
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>
See Also
Reference
Application Definition File Reference
Concepts
Instance Configuration File Reference
Other Resources
Specifying the Database System Name
Moving Instances of Notification Services
Updating Instances and Applications