SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Mirroring Issue


SQL Server Mirroring Issue

Author
Message
rohitsinghchauhan71
rohitsinghchauhan71
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 71
Hello,
I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2 Express edition(64bit) in witness server and Operating system is windows server 2008 R2 SP1 in all three servers.
I am trying mirroring for the first time, I have created endpoints in All three servers i.e. Principle, Mirror and Witness servers with TransactSQL query.
And set the endpoints started.
I have taken the full backup and Transaction Logs backup of DB from Principle server and restored both to the Mirror server with "No Recovery Option".
I started configuring mirroring and my mirroring setup connected to all the endpoints, but when I am starting the mirroring it is giving me the error in Principle server:
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
While in Principle server event logs I am getting Event Id 1474:
Database mirroring connection error 4 'An error occurred while receiving data '10054(An existing connection was forcibly closed by the remote host)'.'for TCP://server.domain.com:5023
In mirror server event logs I am getting:
Database mirroring Login attempt by user domain/user failed with error: connection handshake failed. The login does not have CONNECT permission on the endpoint, STATE84
While the User I am trying to access with is domain user with administrative privilege in active directory and sysadmin privilege in all three SQL server instances.
For Information: I have All 3 protocols Enabled in all 3 servers i.e. Shared Memory, Named Pipes and TCP/IP.
And I have SQL Server and SQL Server Browser services running in all the three Servers.
I have ports open in my firewall for mirroring is 5022(principle), 5023(Mirror) , 5024(Witness) and 1433(TCP and UDP) between all three servers.
When I am trying to connect Mirror and witness from Principle Server it is connecting perfectly from SSMS, when I am connecting Principle and Mirror from Witness server SSMS it's also connecting perfectly, but when I am trying to connect Principle and Witness from Mirror it is not connecting and giving me the error: SQL Network Interfaces, error:26-Error locating Server/Instance Specified
When I am checking the traffic in Firewall firewall is blocking 1434/UDP port between mirror and witness server. But we haven't opened 1434 in any of my servers, while Principle and mirror and Principle and witness are connecting perfectly.
Please someone help.
I am also attaching the snapshots for the errors.
Sorry for the big post but i thought it will help pinpoint the issue
Attachments
1418 error.JPG (43 views, 85.00 KB)
1474 error.JPG (23 views, 119.00 KB)
28048 event id.JPG (30 views, 129.00 KB)
Arsh
Arsh
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4605 Visits: 917
Can u check this without witness ? to narrow down to any issue with the witness . Also , make sure you use the same user (preferably , AD account) at both the primary and secondary SQL servers as service accounts and they have appropriate permissions.

rohitsinghchauhan71
rohitsinghchauhan71
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 71
Arsh - Tuesday, September 19, 2017 1:30 AM
Can u check this without witness ? to narrow down to any issue with the witness . Also , make sure you use the same user (preferably , AD account) at both the primary and secondary SQL servers as service accounts and they have appropriate permissions.


Thanks for the reply, I tried starting Mirroring without Witness Server also but the same error occurred in Principle and Mirror Server.
And I am using same Domain User in all 3 servers and in all 3 SQL server Instances Domain User is assigned as SYSADMIN.
I am getting error in Mirror server as "Handshake Failed, the login does not have connect permission on the endpoint. State 84"
But when I am trying to grant connect permission on the endpoint to the Domain User it sends the error "cannot grant, deny or resolve permission to sa, dbo, entity owner, information schema, sys, or yourself.
I am stuck here badly.
Beatrix Kiddo
Beatrix Kiddo
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25500 Visits: 6647
Do you yourself have sufficient permissions?
rohitsinghchauhan71
rohitsinghchauhan71
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 71
Beatrix Kiddo - Tuesday, September 19, 2017 3:10 AM
Do you yourself have sufficient permissions?


Yes the account is member of Administrator group in active directory and SYSADMIN in SQL Server
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)

Group: General Forum Members
Points: 202706 Visits: 18548
rohitsinghchauhan71 - Monday, September 18, 2017 11:59 PM
Hello,
I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2 Express edition(64bit) in witness server and Operating system is windows server 2008 R2 SP1 in all three servers.
I am trying mirroring for the first time, I have created endpoints in All three servers i.e. Principle, Mirror and Witness servers with TransactSQL query.
And set the endpoints started.
I have taken the full backup and Transaction Logs backup of DB from Principle server and restored both to the Mirror server with "No Recovery Option".
I started configuring mirroring and my mirroring setup connected to all the endpoints, but when I am starting the mirroring it is giving me the error in Principle server:
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
While in Principle server event logs I am getting Event Id 1474:
Database mirroring connection error 4 'An error occurred while receiving data '10054(An existing connection was forcibly closed by the remote host)'.'for TCP://server.domain.com:5023
In mirror server event logs I am getting:
Database mirroring Login attempt by user domain/user failed with error: connection handshake failed. The login does not have CONNECT permission on the endpoint, STATE84
While the User I am trying to access with is domain user with administrative privilege in active directory and sysadmin privilege in all three SQL server instances.
For Information: I have All 3 protocols Enabled in all 3 servers i.e. Shared Memory, Named Pipes and TCP/IP.
And I have SQL Server and SQL Server Browser services running in all the three Servers.
I have ports open in my firewall for mirroring is 5022(principle), 5023(Mirror) , 5024(Witness) and 1433(TCP and UDP) between all three servers.
When I am trying to connect Mirror and witness from Principle Server it is connecting perfectly from SSMS, when I am connecting Principle and Mirror from Witness server SSMS it's also connecting perfectly, but when I am trying to connect Principle and Witness from Mirror it is not connecting and giving me the error: SQL Network Interfaces, error:26-Error locating Server/Instance Specified
When I am checking the traffic in Firewall firewall is blocking 1434/UDP port between mirror and witness server. But we haven't opened 1434 in any of my servers, while Principle and mirror and Principle and witness are connecting perfectly.
Please someone help.
I am also attaching the snapshots for the errors.
Sorry for the big post but i thought it will help pinpoint the issue


did you setup mirroring via t-sql or via the gui?
did you receive any errors whilst setting mirroring up?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
rohitsinghchauhan71
rohitsinghchauhan71
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 71
Perry Whittle - Wednesday, September 20, 2017 4:41 AM
rohitsinghchauhan71 - Monday, September 18, 2017 11:59 PM
Hello,
I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2 Express edition(64bit) in witness server and Operating system is windows server 2008 R2 SP1 in all three servers.
I am trying mirroring for the first time, I have created endpoints in All three servers i.e. Principle, Mirror and Witness servers with TransactSQL query.
And set the endpoints started.
I have taken the full backup and Transaction Logs backup of DB from Principle server and restored both to the Mirror server with "No Recovery Option".
I started configuring mirroring and my mirroring setup connected to all the endpoints, but when I am starting the mirroring it is giving me the error in Principle server:
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
While in Principle server event logs I am getting Event Id 1474:
Database mirroring connection error 4 'An error occurred while receiving data '10054(An existing connection was forcibly closed by the remote host)'.'for TCP://server.domain.com:5023
In mirror server event logs I am getting:
Database mirroring Login attempt by user domain/user failed with error: connection handshake failed. The login does not have CONNECT permission on the endpoint, STATE84
While the User I am trying to access with is domain user with administrative privilege in active directory and sysadmin privilege in all three SQL server instances.
For Information: I have All 3 protocols Enabled in all 3 servers i.e. Shared Memory, Named Pipes and TCP/IP.
And I have SQL Server and SQL Server Browser services running in all the three Servers.
I have ports open in my firewall for mirroring is 5022(principle), 5023(Mirror) , 5024(Witness) and 1433(TCP and UDP) between all three servers.
When I am trying to connect Mirror and witness from Principle Server it is connecting perfectly from SSMS, when I am connecting Principle and Mirror from Witness server SSMS it's also connecting perfectly, but when I am trying to connect Principle and Witness from Mirror it is not connecting and giving me the error: SQL Network Interfaces, error:26-Error locating Server/Instance Specified
When I am checking the traffic in Firewall firewall is blocking 1434/UDP port between mirror and witness server. But we haven't opened 1434 in any of my servers, while Principle and mirror and Principle and witness are connecting perfectly.
Please someone help.
I am also attaching the snapshots for the errors.
Sorry for the big post but i thought it will help pinpoint the issue


did you setup mirroring via t-sql or via the gui?
did you receive any errors whilst setting mirroring up?


I have set Up mirroring using GUI but created endpoints using TSQL.
No error occurred setting up mirroring, I got error while starting the mirroring
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)

Group: General Forum Members
Points: 202706 Visits: 18548
rohitsinghchauhan71 - Wednesday, September 20, 2017 4:50 AM
Perry Whittle - Wednesday, September 20, 2017 4:41 AM
rohitsinghchauhan71 - Monday, September 18, 2017 11:59 PM
Hello,
I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2 Express edition(64bit) in witness server and Operating system is windows server 2008 R2 SP1 in all three servers.
I am trying mirroring for the first time, I have created endpoints in All three servers i.e. Principle, Mirror and Witness servers with TransactSQL query.
And set the endpoints started.
I have taken the full backup and Transaction Logs backup of DB from Principle server and restored both to the Mirror server with "No Recovery Option".
I started configuring mirroring and my mirroring setup connected to all the endpoints, but when I am starting the mirroring it is giving me the error in Principle server:
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
While in Principle server event logs I am getting Event Id 1474:
Database mirroring connection error 4 'An error occurred while receiving data '10054(An existing connection was forcibly closed by the remote host)'.'for TCP://server.domain.com:5023
In mirror server event logs I am getting:
Database mirroring Login attempt by user domain/user failed with error: connection handshake failed. The login does not have CONNECT permission on the endpoint, STATE84
While the User I am trying to access with is domain user with administrative privilege in active directory and sysadmin privilege in all three SQL server instances.
For Information: I have All 3 protocols Enabled in all 3 servers i.e. Shared Memory, Named Pipes and TCP/IP.
And I have SQL Server and SQL Server Browser services running in all the three Servers.
I have ports open in my firewall for mirroring is 5022(principle), 5023(Mirror) , 5024(Witness) and 1433(TCP and UDP) between all three servers.
When I am trying to connect Mirror and witness from Principle Server it is connecting perfectly from SSMS, when I am connecting Principle and Mirror from Witness server SSMS it's also connecting perfectly, but when I am trying to connect Principle and Witness from Mirror it is not connecting and giving me the error: SQL Network Interfaces, error:26-Error locating Server/Instance Specified
When I am checking the traffic in Firewall firewall is blocking 1434/UDP port between mirror and witness server. But we haven't opened 1434 in any of my servers, while Principle and mirror and Principle and witness are connecting perfectly.
Please someone help.
I am also attaching the snapshots for the errors.
Sorry for the big post but i thought it will help pinpoint the issue


did you setup mirroring via t-sql or via the gui?
did you receive any errors whilst setting mirroring up?


I have set Up mirroring using GUI but created endpoints using TSQL.
No error occurred setting up mirroring, I got error while starting the mirroring
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)


Post details of these queries run at each instance in the mirror session

select name AS EndpointName

, endpoint_id

, SUSER_NAME(principal_id) AS OwnerName

, protocol_desc

, state_desc

, role_desc

, is_encryption_enabled

, connection_auth_desc

, encryption_algorithm_desc

from sys.database_mirroring_endpoints

select 'Server login [' + SUSER_NAME(sp.grantee_principal_id) + '] has ' +

sp.permission_name collate Latin1_General_CI_AS + ' permission ' +

CASE sp.state

WHEN 'G' THEN 'Granted'

WHEN 'D' THEN 'Denied'

WHEN 'R' THEN 'Revoked'

END +

' on mirroring endpoint [' + dme.name + ']'

from sys.server_permissions sp

inner join sys.database_mirroring_endpoints dme

on sp.major_id = dme.endpoint_id

where class = 105



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
rohitsinghchauhan71
rohitsinghchauhan71
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 71
Perry Whittle - Wednesday, September 20, 2017 5:07 AM
rohitsinghchauhan71 - Wednesday, September 20, 2017 4:50 AM
Perry Whittle - Wednesday, September 20, 2017 4:41 AM
rohitsinghchauhan71 - Monday, September 18, 2017 11:59 PM
Hello,
I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2 Express edition(64bit) in witness server and Operating system is windows server 2008 R2 SP1 in all three servers.
I am trying mirroring for the first time, I have created endpoints in All three servers i.e. Principle, Mirror and Witness servers with TransactSQL query.
And set the endpoints started.
I have taken the full backup and Transaction Logs backup of DB from Principle server and restored both to the Mirror server with "No Recovery Option".
I started configuring mirroring and my mirroring setup connected to all the endpoints, but when I am starting the mirroring it is giving me the error in Principle server:
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
While in Principle server event logs I am getting Event Id 1474:
Database mirroring connection error 4 'An error occurred while receiving data '10054(An existing connection was forcibly closed by the remote host)'.'for TCP://server.domain.com:5023
In mirror server event logs I am getting:
Database mirroring Login attempt by user domain/user failed with error: connection handshake failed. The login does not have CONNECT permission on the endpoint, STATE84
While the User I am trying to access with is domain user with administrative privilege in active directory and sysadmin privilege in all three SQL server instances.
For Information: I have All 3 protocols Enabled in all 3 servers i.e. Shared Memory, Named Pipes and TCP/IP.
And I have SQL Server and SQL Server Browser services running in all the three Servers.
I have ports open in my firewall for mirroring is 5022(principle), 5023(Mirror) , 5024(Witness) and 1433(TCP and UDP) between all three servers.
When I am trying to connect Mirror and witness from Principle Server it is connecting perfectly from SSMS, when I am connecting Principle and Mirror from Witness server SSMS it's also connecting perfectly, but when I am trying to connect Principle and Witness from Mirror it is not connecting and giving me the error: SQL Network Interfaces, error:26-Error locating Server/Instance Specified
When I am checking the traffic in Firewall firewall is blocking 1434/UDP port between mirror and witness server. But we haven't opened 1434 in any of my servers, while Principle and mirror and Principle and witness are connecting perfectly.
Please someone help.
I am also attaching the snapshots for the errors.
Sorry for the big post but i thought it will help pinpoint the issue


did you setup mirroring via t-sql or via the gui?
did you receive any errors whilst setting mirroring up?


I have set Up mirroring using GUI but created endpoints using TSQL.
No error occurred setting up mirroring, I got error while starting the mirroring
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)


Post details of these queries run at each instance in the mirror session

select name AS EndpointName

, endpoint_id

, SUSER_NAME(principal_id) AS OwnerName

, protocol_desc

, state_desc

, role_desc

, is_encryption_enabled

, connection_auth_desc

, encryption_algorithm_desc

from sys.database_mirroring_endpoints

select 'Server login [' + SUSER_NAME(sp.grantee_principal_id) + '] has ' +

sp.permission_name collate Latin1_General_CI_AS + ' permission ' +

CASE sp.state

WHEN 'G' THEN 'Granted'

WHEN 'D' THEN 'Denied'

WHEN 'R' THEN 'Revoked'

END +

' on mirroring endpoint [' + dme.name + ']'

from sys.server_permissions sp

inner join sys.database_mirroring_endpoints dme

on sp.major_id = dme.endpoint_id

where class = 105



Hello,
I have attached the snapshot of result

rohitsinghchauhan71
rohitsinghchauhan71
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 71
rohitsinghchauhan71 - Wednesday, September 20, 2017 5:40 AM
Perry Whittle - Wednesday, September 20, 2017 5:07 AM
rohitsinghchauhan71 - Wednesday, September 20, 2017 4:50 AM
Perry Whittle - Wednesday, September 20, 2017 4:41 AM
rohitsinghchauhan71 - Monday, September 18, 2017 11:59 PM
Hello,
I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2 Express edition(64bit) in witness server and Operating system is windows server 2008 R2 SP1 in all three servers.
I am trying mirroring for the first time, I have created endpoints in All three servers i.e. Principle, Mirror and Witness servers with TransactSQL query.
And set the endpoints started.
I have taken the full backup and Transaction Logs backup of DB from Principle server and restored both to the Mirror server with "No Recovery Option".
I started configuring mirroring and my mirroring setup connected to all the endpoints, but when I am starting the mirroring it is giving me the error in Principle server:
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)
While in Principle server event logs I am getting Event Id 1474:
Database mirroring connection error 4 'An error occurred while receiving data '10054(An existing connection was forcibly closed by the remote host)'.'for TCP://server.domain.com:5023
In mirror server event logs I am getting:
Database mirroring Login attempt by user domain/user failed with error: connection handshake failed. The login does not have CONNECT permission on the endpoint, STATE84
While the User I am trying to access with is domain user with administrative privilege in active directory and sysadmin privilege in all three SQL server instances.
For Information: I have All 3 protocols Enabled in all 3 servers i.e. Shared Memory, Named Pipes and TCP/IP.
And I have SQL Server and SQL Server Browser services running in all the three Servers.
I have ports open in my firewall for mirroring is 5022(principle), 5023(Mirror) , 5024(Witness) and 1433(TCP and UDP) between all three servers.
When I am trying to connect Mirror and witness from Principle Server it is connecting perfectly from SSMS, when I am connecting Principle and Mirror from Witness server SSMS it's also connecting perfectly, but when I am trying to connect Principle and Witness from Mirror it is not connecting and giving me the error: SQL Network Interfaces, error:26-Error locating Server/Instance Specified
When I am checking the traffic in Firewall firewall is blocking 1434/UDP port between mirror and witness server. But we haven't opened 1434 in any of my servers, while Principle and mirror and Principle and witness are connecting perfectly.
Please someone help.
I am also attaching the snapshots for the errors.
Sorry for the big post but i thought it will help pinpoint the issue


did you setup mirroring via t-sql or via the gui?
did you receive any errors whilst setting mirroring up?


I have set Up mirroring using GUI but created endpoints using TSQL.
No error occurred setting up mirroring, I got error while starting the mirroring
The server network address "TCP://server.domain.com:5023 can not be reached or does not exist. check the network address name and that the ports for the local remote endpoints are operational.(Microsoft SQL Server, Error:1418)


Post details of these queries run at each instance in the mirror session

select name AS EndpointName

, endpoint_id

, SUSER_NAME(principal_id) AS OwnerName

, protocol_desc

, state_desc

, role_desc

, is_encryption_enabled

, connection_auth_desc

, encryption_algorithm_desc

from sys.database_mirroring_endpoints

select 'Server login [' + SUSER_NAME(sp.grantee_principal_id) + '] has ' +

sp.permission_name collate Latin1_General_CI_AS + ' permission ' +

CASE sp.state

WHEN 'G' THEN 'Granted'

WHEN 'D' THEN 'Denied'

WHEN 'R' THEN 'Revoked'

END +

' on mirroring endpoint [' + dme.name + ']'

from sys.server_permissions sp

inner join sys.database_mirroring_endpoints dme

on sp.major_id = dme.endpoint_id

where class = 105



Hello,
I have attached the snapshot of result from Mirror server instance.
Should I attach the result from Principle SQL Server Also??

Please help.Smile
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search