sireesha.budagala (2/1/2011)

---

How Can we modify the Login permissions on SQL Mirrored Database ?
for ex : 'abc' is the Login we need to reduce the level of permission from 'db_owner' to 'read/write' on Mirrored database . Database will be Read-only .

Provide all your inputs on the above .

Thanks in Advance

Sireesha

jorge.rodriguez (2/1/2011)

---

When I try to partner the principal to the mirror I get the error:

The server network address "TCP://<server>:5022" 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

Strange thing is I cant partner the mirror to the principal.

I have followed all the steps listed on the article all to no avail. The service account are running under the same domain account on both databases... Any help would be apreciated.

-- 1. Ping and telnet your principal and mirror servers: if you cannot ping or telnet, this can be your problem (add your ips on your host files and see if this fix your issue)
-- 2. Firewall setup: inbound and outbound packets need to be allowed on the ports used by your listening end points
-- 3. Windows negotiate: can you confirm you use windows negotiate for your end points?

This is for starters.