"Steve G" wrote:

> Hi,
>
> I'm currently configuring SQL Server mirroring on the same machine
> (named W2KPrincipal) by using the following scenario:
>
> SQL Default Instance = W2KPrincipal
> SQL Mirror Instance = W2KPrincipal\Mirror
> SQL Witness Instance = W2KPrincipal\Witness
>
> The trace flag has been configurered for the 3sql server and Remote
> connection has been allowed in Surface Area connection for all of these
> instances. I have configured my endpoint correctly with different port number
> for each instance. I also successfully altering the mirror database to set
> it's partner (Principal). But when I try to alter the principal database to
> set it's partner (the mirror) it fails with the following error:
>
> Msg 1418, Level 16, State 1, Line 1
> The server network address "TCP://W2KPrincipal:5023" can not be reached or
> does not exist. Check the network address name and reissue the command.
>
> Here are the script used:
>
> -- ON PRINCIPAL: Endpoint for the principal server
> CREATE ENDPOINT mirroring_ep
> STATE=STARTED AS TCP
> (LISTENER_PORT=5022)
> FOR DATABASE_MIRRORING
> (ROLE=PARTNER)
>
> -- ON MIRROR: Endpoint for the mirror server
> CREATE ENDPOINT mirroring_ep
> STATE=STARTED AS TCP
> (LISTENER_PORT=5023)
> FOR DATABASE_MIRRORING
> (ROLE=PARTNER)
>
> -- ON WITNESS: Endpoint for the mirror server
> CREATE ENDPOINT mirroring_ep
> STATE=STARTED AS TCP
> (LISTENER_PORT=5024)
> FOR DATABASE_MIRRORING
> (ROLE=WITNESS)
>
> -- ON MIRROR: Define database mirroring partner
> ALTER DATABASE AdventureWorks
> SET PARTNER = 'TCP://W2KPrincipal:5022'
>
> -- ON PRINCIPAL: Define database mirroring partner
> ALTER DATABASE AdventureWorks
> SET PARTNER = 'TCP://W2KPrincipal:5023'
>
>
> then it fails on the last step.
>
> Any idea
> thanks