Error: 1418 Verifying Listening port for Mirroring

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Error: 1418 Verifying Listening port for Mirroring

Author

Topic

rezourxe
Starting Member

17 Posts

Posted - 2008-03-31 : 17:46:01

Hi,

Gentlemen, is is possible for me to verify on witch port(s) my instance(s) are, actually, listening for mirroring?

I already tried: cmd->netstat -ab hoping to find something like sqlsrv.
I also created endpoints for both, principal and mirror, servers.
created certificates and Accounts on both servers too.
So, my next try is verify the ports...

thx in advance...

if it ain't broken don't fix it!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-31 : 18:14:26

Can I answer it even though I'm not a gentleman? Why do people assume it's only men here or in IT?

The port that is used for mirroring is what was used when you setup the endpoint.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rezourxe
Starting Member

17 Posts

Posted - 2008-03-31 : 18:28:22

I'm sorry about the gentlemen thing, I'm gonna have to specify Ladies too.. lol...

Ok, so you're telling me that the port that my instance is going to use is the one specifyied on the endpoint?
then, my problem is not on the port...

so, glentle lady (or anybody else), how came that the pc is not reaching is mine? I really don't undestand...

thx for your time...

if it ain't broken don't fix it!

rezourxe
Starting Member

17 Posts

Posted - 2008-03-31 : 18:51:57

by the way I didn't make the restore part,
I used the schema and data synchronization
tools from red gate.

could the be affecting me right now?
or there is no difference?

if it ain't broken don't fix it!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-31 : 19:55:23

I don't understand what you mean by using the schema and data synchornization tools from Red Gate. That has nothing to do with database mirroring.

Are you getting an error?

Check my blog entry for how to setup database mirroring: http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rezourxe
Starting Member

17 Posts

Posted - 2008-04-03 : 11:49:17

Hi again, I got it running.
not sure, but I guess my problem was on the
"restore with norecovery"

Now, there is one more last question in order to
finish this as a happy day. I'm using not witness....
?How do I start using the mirror.? ?(make it available for use...)?

...

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-03 : 11:51:57

What do you mean? Be clear

rezourxe
Starting Member

17 Posts

Posted - 2008-04-03 : 12:23:04

I'm sorry...
forget it..
that was a dum one...

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-03 : 12:25:07

what is dum one ?You mean dumb one?

rezourxe
Starting Member

17 Posts

Posted - 2008-04-04 : 11:37:39

yes, that's what I meant.

Another little question, i understand for 'automatic failover'
that if ANYTHING happens to the principal, loosing connection with the witness, the mirror will automatically be the principal.

did I understand correctly?

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-04 : 11:41:44

You are right man!!!

rezourxe
Starting Member

17 Posts

Posted - 2008-04-04 : 11:55:35

Ok, I lunched the DB Mirroring Monitor and everything is correct.
the Principal, the Mirror and the Witness are connected.
but if I, example, Stop the service for sql2005 on the principal,
and nothing happens. the Mirror disconnects and nothing else.
The operation mode is set to Hight Safety with Automatic failover.

I'm I missing something?
doesn't the mirror it's supposed to come in as the principal
on this circumstances?

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-04 : 12:08:26

If you have witness server in place, It should failover to other server.Make sure principle and mirror endpoints are set correctly so it listens to each other.

rezourxe
Starting Member

17 Posts

Posted - 2008-04-04 : 12:15:00

so, you're telling me that even after they're connected
there could be problems to switch roles?

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-04 : 12:20:38

No!!! . Tell me after you setup mirroring with witness server,how does it react? Does it failover well when you press failover button?
After you confirm this is working well, Then go ahead and stop service on Principal and you should see mirror database turning to principle(Refresh the database)

rezourxe
Starting Member

17 Posts

Posted - 2008-04-04 : 12:48:51

yup, when I click failover it works... but now I'm checking the LOG for the Mirror server when I shutdown the service. the Witness is not able to log in on the mirror. I copied the certificate (From the Witness) to the Mirror, The same certificated I used to set the principal server.
and the automatic failover came to work. I still don't own a nice understanding of thus certificates.

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-04 : 12:53:05

Ok , the servers are not in same domain !! right. I have never dealt with Certificates before but shouldn't affect your Automatic failover?

rezourxe
Starting Member

17 Posts

Posted - 2008-04-04 : 14:06:25

yes the servers are on the same domain..
but they're running on the Local System Account
(all of them)...
so, in order for the system to trust each other (apparently)
I had to create certificates, logins and users for the servers.

the problem is I forgot the witness.
so, the witness was not able to connect to the mirror, in order
to make it the principal.

if it ain't broken don't fix it!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-04 : 14:14:01

'the problem is I forgot the witness.
so, the witness was not able to connect to the mirror, in order
to make it the principal.'

What do you mean? Witness just watches who is alive. You can do mirroring without witness as well. We always run on Domain account and not on Local system account(replication to work). Make sure you understand this. Check BOL for Database mirroring .They have good whitepaper (www.msdn.com)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources