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 인스턴스 이동
인스턴스 및 응용 프로그램 업데이트