[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

db mirroring

news.microsoft.com

3/8/2007 8:40:00 PM

Hi all,

I'm trying to install db mirroring on my laptop with 2 sql server
standard and an express as witness, but I couldn't because I receive always
the same message: "Neither the partner nor witness server instance for
database TestDB is available". I think the problem is with ports (I use
5025, 5026 and 5027), but I try to stop the firewall, even uninstalled the
antivirus, but always the same.

Telnet to that ports are ok...

The remote connections for the three instances are set on...

I tried with the machine name and with the IP, with the same results...

Any help?

Thanks in advance
--
-----------------------------
"Informatizar el error sólo acelera el caos"


6 Answers

Tibor Karaszi

3/9/2007 7:51:00 AM

0

You're not specifying instance name in the alter database (where you set the partner)? You should
only have machine name/IP and port, no instance name.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://www.solidqualitylea...


"Carlos Sacristan" <nomail> wrote in message news:uXi7xHcYHHA.4368@TK2MSFTNGP06.phx.gbl...
> Hi all,
>
> I'm trying to install db mirroring on my laptop with 2 sql server standard and an express as
> witness, but I couldn't because I receive always the same message: "Neither the partner nor
> witness server instance for database TestDB is available". I think the problem is with ports (I
> use 5025, 5026 and 5027), but I try to stop the firewall, even uninstalled the antivirus, but
> always the same.
>
> Telnet to that ports are ok...
>
> The remote connections for the three instances are set on...
>
> I tried with the machine name and with the IP, with the same results...
>
> Any help?
>
> Thanks in advance
> --
> -----------------------------
> "Informatizar el error sólo acelera el caos"
>


news.microsoft.com

3/9/2007 10:21:00 AM

0

I know, I didn't put instance name in any place. I'll try the next
sentences:

-- in the mirror
ALTER DATABASE xx SET PARTNER = 'TCP://IP:5025' -- port for the
principal

-- in the principal
ALTER DATABASE xx SET PARTNER = 'TCP://IP:5026' -- port for the mirror
GO
ALTER DATABASE xx SET PARTNER = 'TCP://IP:5027' -- por for the witness

Is something wrong?


"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió
en el mensaje news:OqUZo%23hYHHA.3520@TK2MSFTNGP04.phx.gbl...
> You're not specifying instance name in the alter database (where you set
> the partner)? You should only have machine name/IP and port, no instance
> name.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/d...
> http://www.solidqualitylea...
>
>
> "Carlos Sacristan" <nomail> wrote in message
> news:uXi7xHcYHHA.4368@TK2MSFTNGP06.phx.gbl...
>> Hi all,
>>
>> I'm trying to install db mirroring on my laptop with 2 sql server
>> standard and an express as witness, but I couldn't because I receive
>> always the same message: "Neither the partner nor witness server instance
>> for database TestDB is available". I think the problem is with ports (I
>> use 5025, 5026 and 5027), but I try to stop the firewall, even
>> uninstalled the antivirus, but always the same.
>>
>> Telnet to that ports are ok...
>>
>> The remote connections for the three instances are set on...
>>
>> I tried with the machine name and with the IP, with the same
>> results...
>>
>> Any help?
>>
>> Thanks in advance
>> --
>> -----------------------------
>> "Informatizar el error sólo acelera el caos"
>>
>
>


Tibor Karaszi

3/9/2007 12:56:00 PM

0

That looks like the right way to me. First the mirror, then the principal. Now the mirroring should
be up, and you can add the witness if you wish. Did you create the endpoint properly?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://www.solidqualitylea...


"Carlos Sacristan" <nomail> wrote in message news:%23NOpsSjYHHA.4232@TK2MSFTNGP05.phx.gbl...
> I know, I didn't put instance name in any place. I'll try the next sentences:
>
> -- in the mirror
> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5025' -- port for the principal
>
> -- in the principal
> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5026' -- port for the mirror
> GO
> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5027' -- por for the witness
>
> Is something wrong?
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió en el mensaje
> news:OqUZo%23hYHHA.3520@TK2MSFTNGP04.phx.gbl...
>> You're not specifying instance name in the alter database (where you set the partner)? You should
>> only have machine name/IP and port, no instance name.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/d...
>> http://www.solidqualitylea...
>>
>>
>> "Carlos Sacristan" <nomail> wrote in message news:uXi7xHcYHHA.4368@TK2MSFTNGP06.phx.gbl...
>>> Hi all,
>>>
>>> I'm trying to install db mirroring on my laptop with 2 sql server standard and an express as
>>> witness, but I couldn't because I receive always the same message: "Neither the partner nor
>>> witness server instance for database TestDB is available". I think the problem is with ports (I
>>> use 5025, 5026 and 5027), but I try to stop the firewall, even uninstalled the antivirus, but
>>> always the same.
>>>
>>> Telnet to that ports are ok...
>>>
>>> The remote connections for the three instances are set on...
>>>
>>> I tried with the machine name and with the IP, with the same results...
>>>
>>> Any help?
>>>
>>> Thanks in advance
>>> --
>>> -----------------------------
>>> "Informatizar el error sólo acelera el caos"
>>>
>>
>>
>
>


news.microsoft.com

3/9/2007 1:29:00 PM

0

I suppose so...

-- in the principal
CREATE ENDPOINT end_mirror STATE=STARTED

AS TCP (LISTENER_PORT=5025)

FOR DATABASE_MIRRORING (ROLE=ALL)



-- in the mirror

CREATE ENDPOINT end_mirror STATE=STARTED

AS TCP (LISTENER_PORT=5026)

FOR DATABASE_MIRRORING (ROLE=ALL)



-- in the witness

CREATE ENDPOINT end_mirror STATE=STARTED

AS TCP (LISTENER_PORT=5027)

FOR DATABASE_MIRRORING (ROLE=WITNESS)





I also try with the wizard, with the same results...


"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió
en el mensaje news:uUIlVpkYHHA.1008@TK2MSFTNGP03.phx.gbl...
> That looks like the right way to me. First the mirror, then the principal.
> Now the mirroring should be up, and you can add the witness if you wish.
> Did you create the endpoint properly?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/d...
> http://www.solidqualitylea...
>
>
> "Carlos Sacristan" <nomail> wrote in message
> news:%23NOpsSjYHHA.4232@TK2MSFTNGP05.phx.gbl...
>> I know, I didn't put instance name in any place. I'll try the next
>> sentences:
>>
>> -- in the mirror
>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5025' -- port for the
>> principal
>>
>> -- in the principal
>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5026' -- port for the mirror
>> GO
>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5027' -- por for the witness
>>
>> Is something wrong?
>>
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
>> escribió en el mensaje news:OqUZo%23hYHHA.3520@TK2MSFTNGP04.phx.gbl...
>>> You're not specifying instance name in the alter database (where you set
>>> the partner)? You should only have machine name/IP and port, no instance
>>> name.
>>>
>>> --
>>> Tibor Karaszi, SQL Server MVP
>>> http://www.karaszi.com/sqlserver/d...
>>> http://www.solidqualitylea...
>>>
>>>
>>> "Carlos Sacristan" <nomail> wrote in message
>>> news:uXi7xHcYHHA.4368@TK2MSFTNGP06.phx.gbl...
>>>> Hi all,
>>>>
>>>> I'm trying to install db mirroring on my laptop with 2 sql server
>>>> standard and an express as witness, but I couldn't because I receive
>>>> always the same message: "Neither the partner nor witness server
>>>> instance for database TestDB is available". I think the problem is with
>>>> ports (I use 5025, 5026 and 5027), but I try to stop the firewall, even
>>>> uninstalled the antivirus, but always the same.
>>>>
>>>> Telnet to that ports are ok...
>>>>
>>>> The remote connections for the three instances are set on...
>>>>
>>>> I tried with the machine name and with the IP, with the same
>>>> results...
>>>>
>>>> Any help?
>>>>
>>>> Thanks in advance
>>>> --
>>>> -----------------------------
>>>> "Informatizar el error sólo acelera el caos"
>>>>
>>>
>>>
>>
>>
>
>


Tibor Karaszi

3/9/2007 4:48:00 PM

0

Hmm, looks good. And you had the TestDb in full recovery, did a database backup and restore it with
NORECOVERY on the mirror first? If so, I'm out of ideas, I'm afraid... :-(

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://sqlblog.com/blogs/tib...


"Carlos Sacristan" <nomail> wrote in message news:uZSfr7kYHHA.2316@TK2MSFTNGP04.phx.gbl...
> I suppose so...
>
> -- in the principal
> CREATE ENDPOINT end_mirror STATE=STARTED
>
> AS TCP (LISTENER_PORT=5025)
>
> FOR DATABASE_MIRRORING (ROLE=ALL)
>
>
>
> -- in the mirror
>
> CREATE ENDPOINT end_mirror STATE=STARTED
>
> AS TCP (LISTENER_PORT=5026)
>
> FOR DATABASE_MIRRORING (ROLE=ALL)
>
>
>
> -- in the witness
>
> CREATE ENDPOINT end_mirror STATE=STARTED
>
> AS TCP (LISTENER_PORT=5027)
>
> FOR DATABASE_MIRRORING (ROLE=WITNESS)
>
>
>
>
>
> I also try with the wizard, with the same results...
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió en el mensaje
> news:uUIlVpkYHHA.1008@TK2MSFTNGP03.phx.gbl...
>> That looks like the right way to me. First the mirror, then the principal. Now the mirroring
>> should be up, and you can add the witness if you wish. Did you create the endpoint properly?
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/d...
>> http://www.solidqualitylea...
>>
>>
>> "Carlos Sacristan" <nomail> wrote in message news:%23NOpsSjYHHA.4232@TK2MSFTNGP05.phx.gbl...
>>> I know, I didn't put instance name in any place. I'll try the next sentences:
>>>
>>> -- in the mirror
>>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5025' -- port for the principal
>>>
>>> -- in the principal
>>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5026' -- port for the mirror
>>> GO
>>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5027' -- por for the witness
>>>
>>> Is something wrong?
>>>
>>>
>>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió en el mensaje
>>> news:OqUZo%23hYHHA.3520@TK2MSFTNGP04.phx.gbl...
>>>> You're not specifying instance name in the alter database (where you set the partner)? You
>>>> should only have machine name/IP and port, no instance name.
>>>>
>>>> --
>>>> Tibor Karaszi, SQL Server MVP
>>>> http://www.karaszi.com/sqlserver/d...
>>>> http://www.solidqualitylea...
>>>>
>>>>
>>>> "Carlos Sacristan" <nomail> wrote in message news:uXi7xHcYHHA.4368@TK2MSFTNGP06.phx.gbl...
>>>>> Hi all,
>>>>>
>>>>> I'm trying to install db mirroring on my laptop with 2 sql server standard and an express
>>>>> as witness, but I couldn't because I receive always the same message: "Neither the partner nor
>>>>> witness server instance for database TestDB is available". I think the problem is with ports
>>>>> (I use 5025, 5026 and 5027), but I try to stop the firewall, even uninstalled the antivirus,
>>>>> but always the same.
>>>>>
>>>>> Telnet to that ports are ok...
>>>>>
>>>>> The remote connections for the three instances are set on...
>>>>>
>>>>> I tried with the machine name and with the IP, with the same results...
>>>>>
>>>>> Any help?
>>>>>
>>>>> Thanks in advance
>>>>> --
>>>>> -----------------------------
>>>>> "Informatizar el error sólo acelera el caos"
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

news.microsoft.com

3/9/2007 5:11:00 PM

0


Yes, I do: I follow the steps of a lab that works on other computers,
that's the reason I don't understand what happens.

I don't know if is something wrong with that ports. As you, I'm out of
ideas too :-(

Anyway, thanks for your help

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> escribió
en el mensaje news:%23a8hnqmYHHA.4560@TK2MSFTNGP03.phx.gbl...
> Hmm, looks good. And you had the TestDb in full recovery, did a database
> backup and restore it with NORECOVERY on the mirror first? If so, I'm out
> of ideas, I'm afraid... :-(
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/d...
> http://sqlblog.com/blogs/tib...
>
>
> "Carlos Sacristan" <nomail> wrote in message
> news:uZSfr7kYHHA.2316@TK2MSFTNGP04.phx.gbl...
>> I suppose so...
>>
>> -- in the principal
>> CREATE ENDPOINT end_mirror STATE=STARTED
>>
>> AS TCP (LISTENER_PORT=5025)
>>
>> FOR DATABASE_MIRRORING (ROLE=ALL)
>>
>>
>>
>> -- in the mirror
>>
>> CREATE ENDPOINT end_mirror STATE=STARTED
>>
>> AS TCP (LISTENER_PORT=5026)
>>
>> FOR DATABASE_MIRRORING (ROLE=ALL)
>>
>>
>>
>> -- in the witness
>>
>> CREATE ENDPOINT end_mirror STATE=STARTED
>>
>> AS TCP (LISTENER_PORT=5027)
>>
>> FOR DATABASE_MIRRORING (ROLE=WITNESS)
>>
>>
>>
>>
>>
>> I also try with the wizard, with the same results...
>>
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
>> escribió en el mensaje news:uUIlVpkYHHA.1008@TK2MSFTNGP03.phx.gbl...
>>> That looks like the right way to me. First the mirror, then the
>>> principal. Now the mirroring should be up, and you can add the witness
>>> if you wish. Did you create the endpoint properly?
>>>
>>> --
>>> Tibor Karaszi, SQL Server MVP
>>> http://www.karaszi.com/sqlserver/d...
>>> http://www.solidqualitylea...
>>>
>>>
>>> "Carlos Sacristan" <nomail> wrote in message
>>> news:%23NOpsSjYHHA.4232@TK2MSFTNGP05.phx.gbl...
>>>> I know, I didn't put instance name in any place. I'll try the next
>>>> sentences:
>>>>
>>>> -- in the mirror
>>>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5025' -- port for the
>>>> principal
>>>>
>>>> -- in the principal
>>>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5026' -- port for the
>>>> mirror
>>>> GO
>>>> ALTER DATABASE xx SET PARTNER = 'TCP://IP:5027' -- por for the
>>>> witness
>>>>
>>>> Is something wrong?
>>>>
>>>>
>>>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
>>>> escribió en el mensaje news:OqUZo%23hYHHA.3520@TK2MSFTNGP04.phx.gbl...
>>>>> You're not specifying instance name in the alter database (where you
>>>>> set the partner)? You should only have machine name/IP and port, no
>>>>> instance name.
>>>>>
>>>>> --
>>>>> Tibor Karaszi, SQL Server MVP
>>>>> http://www.karaszi.com/sqlserver/d...
>>>>> http://www.solidqualitylea...
>>>>>
>>>>>
>>>>> "Carlos Sacristan" <nomail> wrote in message
>>>>> news:uXi7xHcYHHA.4368@TK2MSFTNGP06.phx.gbl...
>>>>>> Hi all,
>>>>>>
>>>>>> I'm trying to install db mirroring on my laptop with 2 sql server
>>>>>> standard and an express as witness, but I couldn't because I receive
>>>>>> always the same message: "Neither the partner nor witness server
>>>>>> instance for database TestDB is available". I think the problem is
>>>>>> with ports (I use 5025, 5026 and 5027), but I try to stop the
>>>>>> firewall, even uninstalled the antivirus, but always the same.
>>>>>>
>>>>>> Telnet to that ports are ok...
>>>>>>
>>>>>> The remote connections for the three instances are set on...
>>>>>>
>>>>>> I tried with the machine name and with the IP, with the same
>>>>>> results...
>>>>>>
>>>>>> Any help?
>>>>>>
>>>>>> Thanks in advance
>>>>>> --
>>>>>> -----------------------------
>>>>>> "Informatizar el error sólo acelera el caos"
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>