Database Mirroring - Error 1418
-
Hello everyone, how are you?
I am deploying SQL Server 2005 Database Mirroring here at the University with a database with compatibility level 80 where we as an Open Directory Server LDAP. As a result, I chose to configure the instances of SQL Server accounts and local groups put the account in the SQL Server service of Windows.
The problem is that if I do the Mirror to the main server with the following statement gives some
ALTER DATABASE SecranPessoal
SET PARTNER = 'TCP: / / fortes01.secran.com.br: 1400'
However if I make the principal to the mirror with the error:
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP: / / 192.168.1.203:1400" 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.
Since the drip ips, disable the firewall, checked the ports for telnet, the endpoints are running, since I edited the hosts file on each server and put the account I created for use in the Endpoint with permission from Grant. But none of these actions fixed the problem.
Could someone give me a help how I can solve this problem?
Regards,
Marcondes Alexandre
-
You can use this Database Mirroring Troubleshooter CLICK HERE
Alex S -
Marcondes Josino Alexandre (8/30/2011)
Hello everyone, how are you?I am deploying SQL Server 2005 Database Mirroring here at the University with a database with compatibility level 80 where we as an Open Directory Server LDAP. As a result, I chose to configure the instances of SQL Server accounts and local groups put the account in the SQL Server service of Windows.
The problem is that if I do the Mirror to the main server with the following statement gives some
ALTER DATABASE SecranPessoal
SET PARTNER = 'TCP: / / fortes01.secran.com.br: 1400'
However if I make the principal to the mirror with the error:
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP: / / 192.168.1.203:1400" 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.
Since the drip ips, disable the firewall, checked the ports for telnet, the endpoints are running, since I edited the hosts file on each server and put the account I created for use in the Endpoint with permission from Grant. But none of these actions fixed the problem.
Could someone give me a help how I can solve this problem?
Regards,
Marcondes Alexandre
is the machine joined to a domain?
are your mirror and principal instances on the same machine?
do the services for all the instances run under the same account?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
-
Is the machine joined to a domain?
No.
Are your mirror and principal instances on the same machine?
No. Are different instances and machines.
Do the services for all the instances run under the same account?
Yes. I created a local account on each machine with the same User and Password
Marcondes Alexandre
-
So if you dont have a domain where are you getting this from????
Marcondes Josino Alexandre (8/30/2011)
SET PARTNER = 'TCP: / / fortes01.secran.com.br: 1400'To set up mirroring for a workgroup you need to follow the steps in this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply