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.
语法
<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. |
备注
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 数据库引擎 instance to which you are connected.
For information about moving the instance to another database server, see 移动 Notification Services 实例.
示例
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>
请参阅
参考
Application Definition File Reference
概念
Instance Configuration File Reference
其他资源
指定数据库系统名称
移动 Notification Services 实例
更新实例和应用程序