AblSysadmin
asked on
SQL 2012 mirroring error 1418
Hi Guys
I'm having a problem setting up mirroring on SQL 2012.
I receive error 1418 (the server network address cannot be reached or does not exist).
troubleshooting steps include the below
1. confirmed firewall connectivity between servers.
2. tested ODBC connections successfully.
3. tested domain connectivity successfully.
when running SQL under the local system account, it throws the above error.
when running SQL under a domain account with the relevant privileges, it throws a "Cannot generate SSPI context" error.
Any assistance will be appreciated.
I've uploaded a few screendumps of the setup process when SQL is running under the local system account.
Regards
Brad
VirtualBranchSQLMirroringErrors.docx
I'm having a problem setting up mirroring on SQL 2012.
I receive error 1418 (the server network address cannot be reached or does not exist).
troubleshooting steps include the below
1. confirmed firewall connectivity between servers.
2. tested ODBC connections successfully.
3. tested domain connectivity successfully.
when running SQL under the local system account, it throws the above error.
when running SQL under a domain account with the relevant privileges, it throws a "Cannot generate SSPI context" error.
Any assistance will be appreciated.
I've uploaded a few screendumps of the setup process when SQL is running under the local system account.
Regards
Brad
VirtualBranchSQLMirroringErrors.docx
Mohammed Khawaja
To me it seems like you have Windows firewall running and TCP port 5022 is being blocked. Open port 5022 and try again.
ASKER
confirmed that firewall is not blocking connectivity between servers.
I think you need to check the following items
Goto services.msc and check the sql server is running under which account.
Make sure that sql server and sql server agent services should run with same credentials.
In the mirror database server you should do the same step as step 1.
Give the same credentials as in principal server. If that user is not present create a new one on the both servers with same credentials.
Now got principal server and in sql server add the new login under Security-->Login. Give the server roles as Sysadmin and public. Add the same user on the mirror server also.
Now do the mirror in the principal database. You did not get any error there.
http://stackoverflow.com/questions/11032937/how-to-resolve-error-1418-in-sql-server-while-mirroring
Goto services.msc and check the sql server is running under which account.
Make sure that sql server and sql server agent services should run with same credentials.
In the mirror database server you should do the same step as step 1.
Give the same credentials as in principal server. If that user is not present create a new one on the both servers with same credentials.
Now got principal server and in sql server add the new login under Security-->Login. Give the server roles as Sysadmin and public. Add the same user on the mirror server also.
Now do the mirror in the principal database. You did not get any error there.
http://stackoverflow.com/questions/11032937/how-to-resolve-error-1418-in-sql-server-while-mirroring
ASKER
Hi..The account we use is a local admin on both servers and a SA on both SQL servers. The SQL services run under the same account. When we setup the mirroring, we logged on with that account to do the setup.
It creates the endpoints successfully but when you click start mirroring, you get the attached message in the event logs.
Please post any additional questions to JSmall@AfricanBank.co.za
Are you using Kerberos for authentication and if so, are the delegations created and proper SPN are in place? My guess is that the end points are trying Kerberos authenticated which could be the cause, change them to Windows NT (NTLM) and see if it works. If it does then your problem could be delegation or incorrect/missing SPNs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Due to time limitations we reinstalled the servers