| Groups | Blog | Home |
sql server new users : sql2005 database mirroring
i'm new to this group. i wonder if i can get answers to my question here, cos i cant find a newsgroup with database mirroring. i have two servers : pSQL - principal mSQL - mirror Have successfully create the endpoints at both servers. Have checked on the port 5021 listening at both servers. Have successfully ping and see each other in network. * but can only set the partner from the mirror server ( mSQL to pSQL ), and not the other way round. in short unable to set partner from the principal server - pSQL. below is the error msg:- Msg 1418, Level 16, State 1, Line 1 The server network address "tcp://mSQL:5021" 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. anyone successfully solved this issue? Thanks in advance, Adam
First question is are the service accounts the same for both instances and
if they aren't, did you get the certificates exchanged and access granted. Second question is do you have a local firewall on the machine that is blocking ports. Third question is there a firewall on the network that is blocking ports. -- Mike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. [quoted text, click to view] "adam" <hartmann@thestar.com.my> wrote in message news:u%23Q4bEBcGHA.3364@TK2MSFTNGP05.phx.gbl... > hi, > > i'm new to this group. > i wonder if i can get answers to my question here, cos i cant find a > newsgroup with database mirroring. > > i have two servers : > pSQL - principal > mSQL - mirror > > Have successfully create the endpoints at both servers. > Have checked on the port 5021 listening at both servers. > Have successfully ping and see each other in network. > > * > but can only set the partner from the mirror server ( mSQL to pSQL ), and > not the other way round. > in short unable to set partner from the principal server - pSQL. > > below is the error msg:- > Msg 1418, Level 16, State 1, Line 1 > The server network address "tcp://mSQL:5021" 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. > > > anyone successfully solved this issue? > > Thanks in advance, > Adam > > >
You can set the partnership at the mirror, because this is a passive
relationship. All you are doing is changing a setting. It did not work at the principal, because the principal is the active part of mirroring that is required to initiate the connection. Since the principal has to initiate the connection and transfer data immediately upon initiation, the connection is created as part of the action of setting the partnership, so the security issue would be encountered at the principal only. -- Mike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. [quoted text, click to view] "adam" <hartmann@thestar.com.my> wrote in message news:O2dhIGycGHA.3952@TK2MSFTNGP04.phx.gbl... > thanks Mike. > de 1st quest answer it. > > had discovered dat earlier - the service account (principal) has no access > rights on de other (mirror) server. > > thus, has created a domain user (cos in AD environment) and changed to > both servers' service account starter - de sqlserver and sqlagent. > -solved- > > but de weird part is, why mirror server able to set partnership with de > principal at de first place?? > -still no answer- > > anyway, thanks a lot. > > Adam. > > > "Michael Hotek" <mike@solidqualitylearning.com> wrote in message > news:%23rej74ucGHA.3888@TK2MSFTNGP02.phx.gbl... >> First question is are the service accounts the same for both instances >> and if they aren't, did you get the certificates exchanged and access >> granted. Second question is do you have a local firewall on the machine >> that is blocking ports. Third question is there a firewall on the >> network that is blocking ports. >> >> -- >> Mike >> http://www.solidqualitylearning.com >> Disclaimer: This communication is an original work and represents my sole >> views on the subject. It does not represent the views of any other >> person or entity either by inference or direct reference. >> >> >> "adam" <hartmann@thestar.com.my> wrote in message >> news:u%23Q4bEBcGHA.3364@TK2MSFTNGP05.phx.gbl... >>> hi, >>> >>> i'm new to this group. >>> i wonder if i can get answers to my question here, cos i cant find a >>> newsgroup with database mirroring. >>> >>> i have two servers : >>> pSQL - principal >>> mSQL - mirror >>> >>> Have successfully create the endpoints at both servers. >>> Have checked on the port 5021 listening at both servers. >>> Have successfully ping and see each other in network. >>> >>> * >>> but can only set the partner from the mirror server ( mSQL to pSQL ), >>> and >>> not the other way round. >>> in short unable to set partner from the principal server - pSQL. >>> >>> below is the error msg:- >>> Msg 1418, Level 16, State 1, Line 1 >>> The server network address "tcp://mSQL:5021" 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. >>> >>> >>> anyone successfully solved this issue? >>> >>> Thanks in advance, >>> Adam >>> >>> >>> >> >> > >
thanks Mike.
de 1st quest answer it. had discovered dat earlier - the service account (principal) has no access rights on de other (mirror) server. thus, has created a domain user (cos in AD environment) and changed to both servers' service account starter - de sqlserver and sqlagent. -solved- but de weird part is, why mirror server able to set partnership with de principal at de first place?? -still no answer- anyway, thanks a lot. Adam. [quoted text, click to view] "Michael Hotek" <mike@solidqualitylearning.com> wrote in message news:%23rej74ucGHA.3888@TK2MSFTNGP02.phx.gbl... > First question is are the service accounts the same for both instances and > if they aren't, did you get the certificates exchanged and access granted. > Second question is do you have a local firewall on the machine that is > blocking ports. Third question is there a firewall on the network that is > blocking ports. > > -- > Mike > http://www.solidqualitylearning.com > Disclaimer: This communication is an original work and represents my sole > views on the subject. It does not represent the views of any other person > or entity either by inference or direct reference. > > > "adam" <hartmann@thestar.com.my> wrote in message > news:u%23Q4bEBcGHA.3364@TK2MSFTNGP05.phx.gbl... >> hi, >> >> i'm new to this group. >> i wonder if i can get answers to my question here, cos i cant find a >> newsgroup with database mirroring. >> >> i have two servers : >> pSQL - principal >> mSQL - mirror >> >> Have successfully create the endpoints at both servers. >> Have checked on the port 5021 listening at both servers. >> Have successfully ping and see each other in network. >> >> * >> but can only set the partner from the mirror server ( mSQL to pSQL ), and >> not the other way round. >> in short unable to set partner from the principal server - pSQL. >> >> below is the error msg:- >> Msg 1418, Level 16, State 1, Line 1 >> The server network address "tcp://mSQL:5021" 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. >> >> >> anyone successfully solved this issue? >> >> Thanks in advance, >> Adam >> >> >> > >
oh. thanks for the info.
goodday, Adam [quoted text, click to view] "Michael Hotek" <mike@solidqualitylearning.com> wrote in message news:Odmydl1cGHA.4932@TK2MSFTNGP03.phx.gbl... > You can set the partnership at the mirror, because this is a passive > relationship. All you are doing is changing a setting. It did not work > at the principal, because the principal is the active part of mirroring > that is required to initiate the connection. Since the principal has to > initiate the connection and transfer data immediately upon initiation, the > connection is created as part of the action of setting the partnership, so > the security issue would be encountered at the principal only. > > -- > Mike > http://www.solidqualitylearning.com > Disclaimer: This communication is an original work and represents my sole > views on the subject. It does not represent the views of any other person > or entity either by inference or direct reference. > > > "adam" <hartmann@thestar.com.my> wrote in message > news:O2dhIGycGHA.3952@TK2MSFTNGP04.phx.gbl... >> thanks Mike. >> de 1st quest answer it. >> >> had discovered dat earlier - the service account (principal) has no >> access rights on de other (mirror) server. >> >> thus, has created a domain user (cos in AD environment) and changed to >> both servers' service account starter - de sqlserver and sqlagent. >> -solved- >> >> but de weird part is, why mirror server able to set partnership with de >> principal at de first place?? >> -still no answer- >> >> anyway, thanks a lot. >> >> Adam. >> >> >> "Michael Hotek" <mike@solidqualitylearning.com> wrote in message >> news:%23rej74ucGHA.3888@TK2MSFTNGP02.phx.gbl... >>> First question is are the service accounts the same for both instances >>> and if they aren't, did you get the certificates exchanged and access >>> granted. Second question is do you have a local firewall on the machine >>> that is blocking ports. Third question is there a firewall on the >>> network that is blocking ports. >>> >>> -- >>> Mike >>> http://www.solidqualitylearning.com >>> Disclaimer: This communication is an original work and represents my >>> sole views on the subject. It does not represent the views of any other >>> person or entity either by inference or direct reference. >>> >>> >>> "adam" <hartmann@thestar.com.my> wrote in message >>> news:u%23Q4bEBcGHA.3364@TK2MSFTNGP05.phx.gbl... >>>> hi, >>>> >>>> i'm new to this group. >>>> i wonder if i can get answers to my question here, cos i cant find a >>>> newsgroup with database mirroring. >>>> >>>> i have two servers : >>>> pSQL - principal >>>> mSQL - mirror >>>> >>>> Have successfully create the endpoints at both servers. >>>> Have checked on the port 5021 listening at both servers. >>>> Have successfully ping and see each other in network. >>>> >>>> * >>>> but can only set the partner from the mirror server ( mSQL to pSQL ), >>>> and >>>> not the other way round. >>>> in short unable to set partner from the principal server - pSQL. >>>> >>>> below is the error msg:- >>>> Msg 1418, Level 16, State 1, Line 1 >>>> The server network address "tcp://mSQL:5021" 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. >>>> >>>> >>>> anyone successfully solved this issue? >>>> >>>> Thanks in advance, >>>> Adam >>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |