Facing issue while configuring database mirroring(issue with grant permission on endpoint)

Question

While configuring database mirroring between two servers, the grant permission on endpoint is working only when sql is running under network service.. But we need to have the sql running under domain account to configure database mirroring( The sql service needs to be run under the same domain account in both the principal and mirror servers).

Second issue i start the database mirror it gives an error as " The server network address"server1. partners.......:5022" can not be reached or does not exist.Check the network address name and the ports for the local and remote endpoints are operational.(Microsoft SQL error, Error:1418).

  I  have googled for this  issue  but all the fixes  which suggested  are done by me but nothing works out.

  1. Enable firewalll

  2. Open TCP port

  3. we are able to ping server using telnet

  4. End ponts create and permission is given for the domain account

  5. sql service are running under this domain account

 Can some suggest some input here to fix the issue

Regards,

Phani 

 

Answer 1

have you tried to telnet the port 5022 from one server to the other. Both servers have to see the other one

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 2

Hi,

One thing to try, is when you create the endpoint use WINDOWS for AUTHENTICATION. An example would be:

CREATE ENDPOINT Mirroring_Endpoint
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS,
ENCRYPTION = SUPPORTED,
ROLE=ALL);

You'll need to ensure the SQL service accounts are granted access to the endpoint as well e.g.

GRANT CONNECT on ENDPOINT::Mirroring_Endpoint TO [domain\sqlserviceaccountuser];

Answer 3

I have done using the telnet , both the servers are  able to talk to each other and also created the endpoints for the windows authentication

Answer 4

If you want to setup database mirroring using Windows Authentication mode (am I right?), you need to add each other server's service account as a login, and grant it with CONNECT permission on the mirroring endpoints. For more information, see the following Books Online documentation: http://technet.microsoft.com/en-us/library/ms175883.aspx.

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 5

If Telnet works I am about 95% sure that this is a permission issue... Can you script out the mirroring endpoint from both servers and post the output?

Lucifer

Answer 6

Hello Phani,

SQL Server Database Engine Service account should have connect permissions on your Endpoints.  Let me know, if this helps :)

http://sudeeptaganguly.wordpress.com/2012/03/06/database-mirroring-with-sqlcmd/

http://sudeeptaganguly.wordpress.com/2010/07/25/how-to-configure-database-mirroring-in-an-active-directory-environment-using-sql-server-2008/

---

SKG: Please Marked as Answered, if it resolves your issue. (b: http://sudeeptaganguly.wordpress.com)

Answer 7

Can you able to telnet on specific port (5022) bi-directional from principal - mirror - witness (if exists) ?  

---

http://uk.linkedin.com/in/ramjaddu

Answer 8

we have configured Mirroring as per the senario you are looking for, the steps followed are

1) On the folder ( where all Databases are present ) given full control permission to DOMAIN user account  ( principle and mirror server )

2) Started the SQL server service on both the servers ( principle and mirror server ) with same DOMAIN user Account 

3) Logged on both servers with DOMAIN User Account ( on mirror to restire database and tlog )

4) connected to SQL server ( using Managemnet studio on principle server ) with windows Authentication

5) verified that able to telnet on port 5022

6) Created End points and configured mirroing 

all done.

---

Prashant Deshpande