SQLServer2008R2 2台構成において、ミラーリングができない

Question

お世話になります。

SQLServer2008R2 2台構成において、ミラーリングが構成できません

なにとぞお知恵をお貸しください。よろしくお願いいたします。

【環境】

【DB1】①OS:Windows2008Server+DBServer（①プライマリ）＝ SQL Server2008R2 StandardEdition＝ファイアーウォールは無効

【DB2】①OS:Windows2008Server+AD+DBServer（②セカンダリ）+（③ウィットネス＝インスタンスを追加）＝ SQL Server2008R2 StandardEdition

【現象】ミラーリングのウィザードですすみ、最後に以下のようなエラーメッセージが出てミラーリングができません。

ミラーリングのDBは復旧中となってます。

      "ミラーリングの開始中にエラーが発生しました。
        データベース'xxxx'のAlterに失敗しました。
        サーバーネットワークアドレス"TCP://ミラー側サーバ名:5022"にアクセスできないか、このアドレスが存在し
        ません。... (Microsoft SQL Server、エラー: 1418）"

【サービスアカウント】

-DC1-プライマリ

名前                                         状態     開始   ログオン

SQL Server Full-text Filter Deamon Launcher 実行中   手動   ドメイン\ユーザ　　　　　　権限：（domain admins）

SQL Server                                  実行中   自動   ドメイン\ユーザ　　　　　　権限：（domain admins）

SQL Server Agent                             実行中   手動   ドメイン\ユーザ　　　　　　権限：（domain admins）

SQL Server Analysis Service                 実行中   自動   ドメイン\ユーザ　　　　　　権限：（domain admins）

SQL Server Browser                           実行中   自動   ドメイン\ユーザ　　　　　　権限：（domain admins）

SQL Server Integration Services 10.0        実行中   自動   ドメイン\ユーザ　　　　　　権限：（domain admins）

SQL Server Reporting Services               実行中   自動   ドメイン\ユーザ　　　　　　権限：（domain admins）

 

-DC2-ミラー+ウィットネス

名前                                         状態     開始   ログオン

SQL Server Full-text Filter Deamon Launcher 実行中   手動   LocalSystem

SQL Server(ミラー)                          実行中   自動   ドメイン\administrator　　　　　　権限：（domain admins）

SQL Server Agent(ミラー)                     実行中   手動   ドメイン\administrator　　　　　　権限：（domain admins）

SQL Server(ｳｨｯﾄﾈｽ)                           実行中   自動   ドメイン\administrator　　　　　　権限：（domain admins）

SQL Server Agent(ｳｨｯﾄﾈｽ)                     実行中   手動   ドメイン\administrator　　　　　　権限：（domain admins）

SQL Server Analysis Service                 実行中   自動   LocalSystem

SQL Server Browser                           実行中   自動   LocalSystem

SQL Server Integration Services 10.0        実行中   自動   LocalSystem

SQL Server Reporting Services               実行中   自動   LocalSystem

 

Answer 1

ログを取得したのでおくります。

【エンドポイント】１、エンドポイントのスクリプト

エンドポイントのスクリプト（プリンシバル）

/****** Object:  Endpoint [ミラー化]    Script Date: 12/03/2011 15:30:28 ******/

CREATE ENDPOINT [ミラー化] 

AUTHORIZATION [sa]

STATE=STARTED

AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)

FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

, ENCRYPTION = REQUIRED ALGORITHM RC4)

GO

エンドポイントのスクリプト（ミラー）

/****** Object:  Endpoint [ミラー化]    Script Date: 12/03/2011 15:31:13 ******/

CREATE ENDPOINT [ミラー化] 

AUTHORIZATION [AMIYADOMAIN\Administrator]

STATE=STARTED

AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)

FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

, ENCRYPTION = REQUIRED ALGORITHM RC4)

GO

 

Answer 2

【DB1ログ】

 

日付,ソース,重大度,メッセージ

12/03/2011 15:14:07,spid30s,不明,Database mirroring has been terminated for database 'AMIYA'. This is an informational message only. No user action is required.

12/03/2011 15:14:07,spid30s,不明,エラー: 1443、重大度: 16、状態: 2。

12/03/2011 15:13:47,spid32s,不明,Database mirroring connection error 4 'An error occurred while receiving data: '10054(既存の接続はリモート ホストに強制的に切断されました。)'.' for 'TCP://SVAH22.amiyadomain.local:5022'.

12/03/2011 15:13:47,spid32s,不明,Error: 1474<c/> Severity: 16<c/> State: 1.

12/03/2011 15:07:33,バックアップ,不明,Database backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> pages dumped: 170017<c/> first LSN: 36684:380:75<c/> last LSN: 36684:446:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\amiya1112031505full.bak'}). This is an informational message only. No user action is required.

12/03/2011 15:03:42,バックアップ,不明,Log was backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> first LSN: 36679:1463:1<c/> last LSN: 36684:337:1<c/> number of dump devices: 1<c/> device information: (FILE=2<c/> TYPE=DISK: {'C:\amiya1112031500_mirror.bak'}). This is an informational message only. No user action is required.

12/03/2011 15:02:34,バックアップ,不明,Database backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> pages dumped: 170017<c/> first LSN: 36684:309:46<c/> last LSN: 36684:329:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\amiya1112031500_mirror.bak'}). This is an informational message only. No user action is required.

12/03/2011 14:59:03,バックアップ,不明,Database backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> pages dumped: 170025<c/> first LSN: 36684:16:260<c/> last LSN: 36684:155:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\amiya1112031456mirror.bak'}). This is an informational message only. No user action is required.

12/03/2011 14:58:37,バックアップ,不明,BACKUP failed to complete the command BACKUP DATABASE AMIYA. Check the backup application log for detailed messages.

12/03/2011 14:58:37,バックアップ,不明,エラー: 3041、重大度: 16、状態: 1。

12/03/2011 13:07:24,spid81,不明,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

12/03/2011 13:07:24,spid81,不明,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 13:07:24,spid81,不明,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.

12/03/2011 13:07:24,spid81,不明,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 13:07:24,spid81,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 13:07:24,spid81,不明,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

12/03/2011 13:07:24,spid81,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 13:07:24,spid81,不明,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.

12/03/2011 13:07:24,spid81,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 13:07:24,spid81,不明,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

12/03/2011 12:56:22,バックアップ,不明,Database backed up. Database: TEST<c/> creation date(time): 2011/11/29(13:03:28)<c/> pages dumped: 220200<c/> first LSN: 36393:43:36<c/> last LSN: 36393:59:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\test1112031254.bak'}). This is an informational message only. No user action is required.

12/03/2011 12:37:02,バックアップ,不明,Database backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> pages dumped: 170018<c/> first LSN: 36679:2433:223<c/> last LSN: 36679:2530:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\amiya1112031235.bak'}). This is an informational message only. No user action is required.

12/03/2011 12:25:23,spid30s,不明,Database mirroring has been terminated for database 'AMIYA'. This is an informational message only. No user action is required.

12/03/2011 12:25:23,spid30s,不明,エラー: 1443、重大度: 16、状態: 2。

12/03/2011 12:25:03,spid32s,不明,Database mirroring connection error 4 'An error occurred while receiving data: '10054(既存の接続はリモート ホストに強制的に切断されました。)'.' for 'TCP://SVAH22.amiyadomain.local:5022'.

12/03/2011 12:25:03,spid32s,不明,Error: 1474<c/> Severity: 16<c/> State: 1.

12/03/2011 12:10:21,spid30s,不明,Database mirroring has been terminated for database 'AMIYA'. This is an informational message only. No user action is required.

12/03/2011 12:10:21,spid30s,不明,エラー: 1443、重大度: 16、状態: 2。

12/03/2011 12:10:01,spid32s,不明,Database mirroring connection error 4 'An error occurred while receiving data: '10054(既存の接続はリモート ホストに強制的に切断されました。)'.' for 'TCP://SVAH22.amiyadomain.local:5022'.

12/03/2011 12:10:01,spid32s,不明,Error: 1474<c/> Severity: 16<c/> State: 1.

12/03/2011 11:43:59,spid30s,不明,Database mirroring has been terminated for database 'AMIYA'. This is an informational message only. No user action is required.

12/03/2011 11:43:59,spid30s,不明,エラー: 1443、重大度: 16、状態: 2。

12/03/2011 11:43:39,spid32s,不明,Database mirroring connection error 4 'An error occurred while receiving data: '10054(既存の接続はリモート ホストに強制的に切断されました。)'.' for 'TCP://SVAH22.amiyadomain.local:5022'.

12/03/2011 11:43:39,spid32s,不明,Error: 1474<c/> Severity: 16<c/> State: 1.

12/03/2011 11:43:39,spid95,不明,Database mirroring has been enabled on this instance of SQL Server.

12/03/2011 10:49:26,バックアップ,不明,Database backed up. Database: TEST<c/> creation date(time): 2011/11/29(13:03:28)<c/> pages dumped: 220200<c/> first LSN: 36389:43:36<c/> last LSN: 36389:59:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\test_111203.bak'}). This is an informational message only. No user action is required.

12/03/2011 10:44:09,バックアップ,不明,Database backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> pages dumped: 170018<c/> first LSN: 36679:1560:167<c/> last LSN: 36679:1627:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\amiya_111203.bak'}). This is an informational message only. No user action is required.

12/03/2011 10:37:35,ログオン,不明,Login failed for user 'AMIYADOMAIN\Administrator'. 理由: トークン ベースのサーバー アクセス検証は、インフラストラクチャ エラーが発生して失敗しました。以前に発生したエラーを確認してください。 [クライアント: 192.168.11.22]

12/03/2011 10:37:35,ログオン,不明,エラー: 18456、重大度: 14、状態: 11。

12/03/2011 10:37:16,ログオン,不明,Login failed for user 'AMIYADOMAIN\Administrator'. 理由: トークン ベースのサーバー アクセス検証は、インフラストラクチャ エラーが発生して失敗しました。以前に発生したエラーを確認してください。 [クライアント: 192.168.11.22]

12/03/2011 10:37:16,ログオン,不明,エラー: 18456、重大度: 14、状態: 11。

12/03/2011 10:25:07,バックアップ,不明,Log was backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> first LSN: 36490:86:1<c/> last LSN: 36679:1463:1<c/> number of dump devices: 1<c/> device information: (FILE=2<c/> TYPE=DISK: {'C:\1112031020.bak'}). This is an informational message only. No user action is required.

12/03/2011 10:22:49,バックアップ,不明,Database backed up. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> pages dumped: 170026<c/> first LSN: 36679:1317:238<c/> last LSN: 36679:1456:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'C:\1112031020.bak'}). This is an informational message only. No user action is required.

12/03/2011 00:00:01,spid26s,不明,This instance of SQL Server has been using a process ID of 5936 since 2011/12/02 12:14:01 (local) 2011/12/02 3:14:01 (UTC). This is an informational message only; no user action is required.

Answer 3

【DB２ログ】

日付,ソース,重大度,メッセージ

12/03/2011 15:14:41,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:39,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:36,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:34,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:31,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:29,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:27,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:26,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:25,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:23,Logon,不明,Database Mirroring login attempt by user 'AMIYADOMAIN\amiyasv21.' failed with error: 'Connection handshake failed. The login 'AMIYADOMAIN\amiyasv21' does not have CONNECT permission on the endpoint. State 84.'.  [CLIENT: 192.168.11.21]

12/03/2011 15:14:21,spid61,不明,Database mirroring has been enabled on this instance of SQL Server.

12/03/2011 15:12:32,バックアップ,不明,Log was restored. Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> first LSN: 36679:1463:1<c/> last LSN: 36684:337:1<c/> number of dump devices: 1<c/> device information: (FILE=2<c/> TYPE=DISK: {'D:\全拠点共通\amiya1112031500_mirror.bak'}). This is an informational message. No user action is required.

12/03/2011 15:12:29,バックアップ,不明,Database was restored: Database: AMIYA<c/> creation date(time): 2011/11/03(09:33:11)<c/> first LSN: 36684:309:46<c/> last LSN: 36684:329:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'D:\全拠点共通\amiya1112031500_mirror.bak'}). Informational message. No user action required.

12/03/2011 15:12:25,spid54,不明,The database 'AMIYA' is marked RESTORING and is in a state that does not allow recovery to be run.

12/03/2011 15:12:25,spid54,不明,Starting up database 'AMIYA'.

12/03/2011 15:03:11,spid58,不明,Setting database option PAGE_VERIFY to CHECKSUM for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option MULTI_USER to ON for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option RECOVERY to FULL for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option READ_WRITE to ON for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option PARAMETERIZATION to SIMPLE for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option DISABLE_BROKER to ON for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option RECURSIVE_TRIGGERS to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option QUOTED_IDENTIFIER to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option NUMERIC_ROUNDABORT to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option CURSOR_DEFAULT to GLOBAL for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option AUTO_UPDATE_STATISTICS to ON for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option AUTO_SHRINK to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option AUTO_CREATE_STATISTICS to ON for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option AUTO_CLOSE to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option ARITHABORT to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option ANSI_WARNINGS to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option ANSI_PADDING to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option ANSI_NULLS to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option ANSI_NULL_DEFAULT to OFF for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Setting database option COMPATIBILITY_LEVEL to 90 for database AMIYA.

12/03/2011 15:03:11,spid58,不明,Starting up database 'AMIYA'.

12/03/2011 14:52:21,spid55,不明,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

12/03/2011 14:52:21,spid55,不明,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 14:52:20,spid55,不明,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

12/03/2011 14:52:20,spid55,不明,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 14:52:20,spid55,不明,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.

12/03/2011 14:52:20,spid55,不明,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 14:52:19,spid55,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 14:52:19,spid55,不明,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.

12/03/2011 14:52:19,spid55,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 14:52:19,spid55,不明,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.

12/03/2011 14:52:19,spid55,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 14:52:19,spid55,不明,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

12/03/2011 14:50:13,spid7s,不明,Recovery is complete. This is an informational message only. No user action is required.

12/03/2011 14:50:13,spid11s,不明,Service Broker manager has started.

12/03/2011 14:50:12,spid11s,不明,The Database Mirroring protocol transport is now listening for connections.

12/03/2011 14:50:12,spid11s,不明,Server is listening on [ 'any' <ipv4> 5022].

12/03/2011 14:50:12,spid11s,不明,Server is listening on [ 'any' <ipv6> 5022].

12/03/2011 14:50:12,spid11s,不明,The Service Broker protocol transport is disabled or not configured.

12/03/2011 14:50:12,spid10s,不明,Starting up database 'tempdb'.

12/03/2011 14:50:11,spid17s,不明,The database 'AMIYA2' is marked RESTORING and is in a state that does not allow recovery to be run.

12/03/2011 14:50:11,spid16s,不明,The database 'AMIYA' is marked RESTORING and is in a state that does not allow recovery to be run.

12/03/2011 14:50:11,spid17s,不明,Starting up database 'AMIYA2'.

12/03/2011 14:50:11,ログオン,不明,Login failed for user 'NT AUTHORITY\SYSTEM'. 理由: 明示的に指定されたデータベースを開けませんでした。 [クライアント: <local machine>]

12/03/2011 14:50:11,ログオン,不明,エラー: 18456、重大度: 14、状態: 38。

12/03/2011 14:50:11,spid14s,不明,Starting up database 'ReportServer$LPG'.

12/03/2011 14:50:11,spid16s,不明,Starting up database 'AMIYA'.

12/03/2011 14:50:11,spid15s,不明,Starting up database 'ReportServer$LPGTempDB'.

12/03/2011 14:50:11,spid11s,不明,Starting up database 'msdb'.

12/03/2011 14:50:10,spid14s,不明,A new instance of the full-text filter daemon host process has been successfully started.

12/03/2011 14:50:10,ログオン,不明,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [クライアント: <local machine>]

12/03/2011 14:50:10,ログオン,不明,エラー: 17187、重大度: 16、状態: 1。

12/03/2011 14:50:10,サーバー,不明,SQL Server is now ready for client connections. This is an informational message; no user action is required.

12/03/2011 14:50:10,サーバー,不明,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/SVAH22.amiyadomain.local:53999 ] for the SQL Server service.

12/03/2011 14:50:10,サーバー,不明,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/SVAH22.amiyadomain.local:LPG ] for the SQL Server service.

12/03/2011 14:50:10,サーバー,不明,Dedicated admin connection support was established for listening locally on port 54000.

12/03/2011 14:50:10,サーバー,不明,Server is listening on [ 127.0.0.1 <ipv4> 54000].

12/03/2011 14:50:10,サーバー,不明,Server is listening on [ ::1 <ipv6> 54000].

12/03/2011 14:50:10,サーバー,不明,Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$LPG\sql\query ].

12/03/2011 14:50:10,サーバー,不明,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\LPG ].

12/03/2011 14:50:10,サーバー,不明,Server is listening on [ 'any' <ipv4> 53999].

12/03/2011 14:50:10,サーバー,不明,Server is listening on [ 'any' <ipv6> 53999].

12/03/2011 14:50:10,サーバー,不明,A self-generated certificate was successfully loaded for encryption.

12/03/2011 14:50:10,spid10s,不明,Clearing tempdb database.

12/03/2011 14:50:09,spid7s,不明,Server name is 'SVAH22\LPG'. This is an informational message only. No user action is required.

12/03/2011 14:50:09,spid10s,不明,Starting up database 'model'.

12/03/2011 14:50:09,spid7s,不明,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.

12/03/2011 14:50:09,spid7s,不明,Starting up database 'mssqlsystemresource'.

12/03/2011 14:50:09,spid7s,不明,SQL Trace ID 1 was started by login "sa".

12/03/2011 14:50:09,spid7s,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPG'.

12/03/2011 14:50:09,spid7s,不明,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

12/03/2011 14:50:08,spid7s,不明,Starting up database 'master'.

12/03/2011 14:50:08,サーバー,不明,Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

12/03/2011 14:50:08,サーバー,不明,Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.

12/03/2011 14:50:07,サーバー,不明,Detected 4 CPUs. This is an informational message; no user action is required.

12/03/2011 14:50:07,サーバー,不明,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

12/03/2011 14:50:07,Server,不明,Registry startup parameters: <nl/>  -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPG\MSSQL\DATA\master.mdf<nl/>  -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPG\MSSQL\Log\ERRORLOG<nl/>  -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPG\MSSQL\DATA\mastlog.ldf

12/03/2011 14:50:07,Server,不明,This instance of SQL Server last reported using a process ID of 3712 at 2011/12/03 13:59:52 (local) 2011/12/03 4:59:52 (UTC). This is an informational message only; no user action is required.

12/03/2011 14:50:07,Server,不明,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPG\MSSQL\Log\ERRORLOG'.

12/03/2011 14:50:07,Server,不明,Authentication mode is MIXED.

12/03/2011 14:50:07,Server,不明,System Manufacturer: 'Dell Inc.'<c/> System Model: 'PowerEdge T110'.

12/03/2011 14:50:07,Server,不明,Server process ID is 3728.

12/03/2011 14:50:07,Server,不明,All rights reserved.

12/03/2011 14:50:07,Server,不明,(c) Microsoft Corporation.

12/03/2011 14:50:07,Server,不明,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) <nl/> Apr  2 2010 15:48:46 <nl/> Copyright (c) Microsoft Corporation<nl/> Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

【ウィットネス】インスタンス

日付,ソース,重大度,メッセージ

12/03/2011 14:54:21,spid51,不明,Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

12/03/2011 14:54:21,spid51,不明,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 14:54:21,spid51,不明,Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

12/03/2011 14:54:21,spid51,不明,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 14:54:20,spid51,不明,Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.

12/03/2011 14:54:20,spid51,不明,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.

12/03/2011 14:51:04,spid7s,不明,Recovery is complete. This is an informational message only. No user action is required.

12/03/2011 14:51:04,spid14s,不明,Service Broker manager has started.

12/03/2011 14:51:04,spid14s,不明,The Database Mirroring protocol transport is now listening for connections.

12/03/2011 14:51:04,spid14s,不明,Server is listening on [ 'any' <ipv4> 5023].

12/03/2011 14:51:04,spid14s,不明,Server is listening on [ 'any' <ipv6> 5023].

12/03/2011 14:51:04,spid14s,不明,The Service Broker protocol transport is disabled or not configured.

12/03/2011 14:51:04,spid10s,不明,Starting up database 'tempdb'.

12/03/2011 14:51:03,spid10s,不明,Clearing tempdb database.

12/03/2011 14:51:03,サーバー,不明,SQL Server is now ready for client connections. This is an informational message; no user action is required.

12/03/2011 14:51:03,サーバー,不明,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/SVAH22.amiyadomain.local:54550 ] for the SQL Server service.

12/03/2011 14:51:03,サーバー,不明,The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/SVAH22.amiyadomain.local:LPGMIRRORING ] for the SQL Server service.

12/03/2011 14:51:03,サーバー,不明,Dedicated admin connection support was established for listening locally on port 54551.

12/03/2011 14:51:03,サーバー,不明,Server is listening on [ 127.0.0.1 <ipv4> 54551].

12/03/2011 14:51:03,サーバー,不明,Server is listening on [ ::1 <ipv6> 54551].

12/03/2011 14:51:03,サーバー,不明,Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$LPGMIRRORING\sql\query ].

12/03/2011 14:51:03,サーバー,不明,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\LPGMIRRORING ].

12/03/2011 14:51:03,サーバー,不明,Server is listening on [ 'any' <ipv4> 54550].

12/03/2011 14:51:03,サーバー,不明,Server is listening on [ 'any' <ipv6> 54550].

12/03/2011 14:51:03,サーバー,不明,A self-generated certificate was successfully loaded for encryption.

12/03/2011 14:51:02,spid7s,不明,Starting up database 'msdb'.

12/03/2011 14:51:02,spid7s,不明,Database mirroring has been enabled on this instance of SQL Server.

12/03/2011 14:51:02,spid7s,不明,情報: フルテキストでサポートされている言語が見つかりません。

12/03/2011 14:51:02,spid7s,不明,Server name is 'SVAH22\LPGMIRRORING'. This is an informational message only. No user action is required.

12/03/2011 14:51:02,spid10s,不明,Starting up database 'model'.

12/03/2011 14:51:02,spid7s,不明,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.

12/03/2011 14:51:02,spid7s,不明,Starting up database 'mssqlsystemresource'.

12/03/2011 14:51:02,spid7s,不明,SQL Trace ID 1 was started by login "sa".

12/03/2011 14:51:02,spid7s,不明,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'LPGMIRRORING'.

12/03/2011 14:51:01,spid7s,不明,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

12/03/2011 14:51:01,spid7s,不明,Starting up database 'master'.

12/03/2011 14:51:01,サーバー,不明,Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

12/03/2011 14:51:00,サーバー,不明,Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.

12/03/2011 14:51:00,サーバー,不明,Detected 4 CPUs. This is an informational message; no user action is required.

12/03/2011 14:51:00,サーバー,不明,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

12/03/2011 14:51:00,Server,不明,Registry startup parameters: <nl/>  -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPGMIRRORING\MSSQL\DATA\master.mdf<nl/>  -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPGMIRRORING\MSSQL\Log\ERRORLOG<nl/>  -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPGMIRRORING\MSSQL\DATA\mastlog.ldf

12/03/2011 14:51:00,Server,不明,This instance of SQL Server last reported using a process ID of 3480 at 2011/12/03 14:06:24 (local) 2011/12/03 5:06:24 (UTC). This is an informational message only; no user action is required.

12/03/2011 14:51:00,Server,不明,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.LPGMIRRORING\MSSQL\Log\ERRORLOG'.

12/03/2011 14:51:00,Server,不明,Authentication mode is MIXED.

12/03/2011 14:51:00,Server,不明,System Manufacturer: 'Dell Inc.'<c/> System Model: 'PowerEdge T110'.

12/03/2011 14:51:00,Server,不明,Server process ID is 3660.

12/03/2011 14:51:00,Server,不明,All rights reserved.

12/03/2011 14:51:00,Server,不明,(c) Microsoft Corporation.

12/03/2011 14:51:00,Server,不明,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) <nl/> Apr  2 2010 15:48:46 <nl/> Copyright (c) Microsoft Corporation<nl/> Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Answer 4

ログは読んでいませんし、ミラーリングもしたことありませんが、一番最初の投稿の

> サーバーネットワークアドレス"TCP://ミラー側サーバ名:5022"にアクセスできないか、このアドレスが存在しません。... (Microsoft SQL Server、エラー: 1418）

を解決する必要があるように思います。
ここが切り分けできないと次の手がないように思います。

Answer 5

こんにちは、mmmmno1 さん。

MSDN フォーラムのご利用ありがとうございます。オペレーターの山本です。
その後いかがでしょうか。

mars12 さんから、参考になるアドバイスをいただいているようでしたので、勝手ながら私の方で一旦回答としてマークさせていただきました。
mars12 さん、アドバイスありがとうございます。

mmmmno1 さん、すでに確認されていらっしゃるかもしれませんが、トラブルシューティングの資料です。ご参考まで。

　　データベース ミラーリングの配置のトラブルシューティング
　　http://msdn.microsoft.com/ja-jp/library/ms189127.aspx

もしまだ問題が解決していない場合には、その後の状況など情報の更新をしていただくと他にも情報がえられるかもしれません。
                                                          
日本マイクロソフト株式会社 フォーラム オペレーター 山本 春海