SQL 2005 SP1 Database Mirroring

Beim versuch ein Datenbank zu Spiegeln bekomme ich folgende
Fehlermeldung:

The server network address "TCP://xxx.xxxx.xxx:5022" can not be reached
or does not exist. Check the network address name and that the ports
for the local and remote endpoints are operational. (.Net SqlClient
Data Provider)

Ich kann den Server über Telnet auf Port 5022 erreichen, ich bin wie
folgt vorgegangen.

Alle drei MSSQL Server sind in einer Domain, keine Windows Firewall!


der Domain User ist auf allen drei Servern angelegt mit allen Rechten.

Principal: MSSQL 2005 x64 Enterprise Editon mit SP1
Mirror: MSSQL 2005 x64 Enterprise Editon mit SP1
Witness: MSSQL 2005 Standard Editon mit SP1
-------------------------------------------------------------------------------
Principal
USE AdventureWorks
CREATE ENDPOINT Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=5022 )
FOR DATABASE_MIRRORING (ROLE=PARTNER)
GO
-------------------------------------------------------------------------------
Mirror
CREATE ENDPOINT Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=5022 )
FOR DATABASE_MIRRORING (ROLE=ALL)
GO
-------------------------------------------------------------------------------
Witness
CREATE ENDPOINT Mirroring
STATE=STARTED
AS TCP (LISTENER_PORT=5022 )
FOR DATABASE_MIRRORING (ROLE=WITNESS)
GO
-------------------------------------------------------------------------------
:CONNECT Principal
ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT
GO
BACKUP DATABASE [AdventureWorks]
TO DISK = 'C:\Backup\AdventureWorks_dump.bak'
WITH INIT
GO
-------------------------------------------------------------------------------
:CONNECT Mirror
RESTORE DATABASE [AdventureWorks]
FROM DISK = 'C:\Backup\AdventureWorks_dump.bak'
WITH
MOVE 'AdventureWorks_Data' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.4' +
'\MSSQL\Data\AdventureWorks_Data.mdf',
MOVE 'AdventureWorks_Log' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.4' +
'\MSSQL\Data\AdventureWorks_Log.ldf',
NORECOVERY, REPLACE
-------------------------------------------------------------------------------
:CONNECT Principal
BACKUP LOG [AdventureWorks]
TO DISK = 'C:\Backup\AdventureWorksLog_Dump.bak'
WITH INIT
GO
-------------------------------------------------------------------------------
:CONNECT Mirror
RESTORE LOG [AdventureWorks]
FROM DISK = 'C:\Backup\AdventureWorksLog_Dump.bak'
WITH NORECOVERY
GO
-------------------------------------------------------------------------------
:CONNECT Mirror
ALTER DATABASE AdventureWorks
SET PARTNER = 'TCP://Principal:5022'
GO
-------------------------------------------------------------------------------
:CONNECT Principal
ALTER DATABASE AdventureWorks
SET PARTNER = 'TCP://Mirror:5022'
GO
-------------------------------------------------------------------------------
ALTER DATABASE AdventureWorks
SET WITNESS = 'TCP://Witness:5022'
GO


?????????? Wo ist der Fehler ?????????????


Wenn ich dies, mit verschiedenen Ports, auf drei Instanzen eines
Servers ausführe funktioniert es, aber leider nicht auf drei
getrennten Servern.

Auch wenn ich es über den Wizard versuche bekomme ich die selbe
Fehlermeldung.

Vielen Dank für eure Hilfe.

Viele Grüße

Stefan

.

Relevant Pages

  • Re: Got an Exception error - still
    ... it looks to me like you are trying to attach the adventureworks database which is made for sql2005 with sql2000, ... I tried using Enterprise Manager for SQL 2000. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 SP1 Database Mirroring
    ... Alle drei MSSQL Server sind in einer Domain, ... Mirror: MSSQL 2005 x64 Enterprise Editon mit SP1 ... CREATE ENDPOINT Mirroring ... ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT ...
    (microsoft.public.de.sqlserver)
  • Re: Newbie needs help
    ... Chances are they are using the AdventureWorks sample database which come ... Targetspecified: builddb ...
    (microsoft.public.sqlserver.security)
  • SQL 2005 Mirroring Problems, HELP
    ... I try to Mirror a Database, ... ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT ... but NOT on three diffrent SQL Server. ...
    (microsoft.public.sqlserver)
  • Re: Sql Server 2005 - Moving data folder
    ... Now I seem to be able to move the adventureworks database without issue. ... > I'm trying to move the data folder where the db's are kept for SQL ...
    (microsoft.public.sqlserver.setup)