InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:30:31 GMT20http://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxGood day,Please check that you do not have orphan users. Meaning delete all mirroring users. eg PrincipalUser from the master database and reinstate. Run a check on the all boxes that your principal, mirror and witness have the same certificate id. select * from sys.certificatesWed, 18 Jan 2012 23:25:08 GMTshirleymhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx-- grant permission to the Mirroring service accountGRANT CONNECT ON ENDPOINT::Mirroring TO [DOMAIN\AccountName]GO -- replace ::Mirroring with ::YourEndpointNameWed, 18 Jan 2012 07:36:53 GMTgm.joneshttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxhow to give permission to endpoint....Wed, 18 Jan 2012 07:07:00 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxUnderstood both servers were started with same account. But are they domain users or local users account? Do they have permission to EndPoint?Tue, 17 Jan 2012 11:54:02 GMTyuwen.hwanghttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxthere are two servers. and both server using same user to start.and both server's engine and agent service are running on this account.Mon, 16 Jan 2012 01:47:54 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx1st time doing this activity on this server. Mon, 16 Jan 2012 01:39:29 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxNot sure if this helps. 1. Check what window account is used to start your SQL Server service in all involved SQL Servers. You should use some domain account but not local system/network account.2. Check if this domain account is also added to the SQL Server login (security login) or into the coresponding system account group.3. If it still does not work. You might need to GRANT CONNECT ON ENDPOINT :: <endpoint_name> TO < server_principal > EugeneFri, 13 Jan 2012 08:06:56 GMTyuwen.hwanghttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxDo you have any databases mirrored on this instance already or is this the first one you are attempting?Fri, 13 Jan 2012 04:36:31 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxplease help me for this problemi stuck with it.Fri, 13 Jan 2012 01:47:22 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxi had tested. i created two system DSN pointing to the mirror and witness server it is working fine.and i have also checked in primary server to connect mirror and witness server, it is also connected with the sql server authentication.but giving timeout error with domain user authentication.Thu, 12 Jan 2012 04:51:56 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]tomorrow i'll do it and get back to u for the same.[/quote]Ensure all nodes are well connected and confirm.Wed, 11 Jan 2012 13:22:37 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxMirroring doesn't need any particular filestream setting. As I said, you can't mirror a DB that has a filestream column in it, so it would be a little weird if the filestream setting was necessary (it is not)Wed, 11 Jan 2012 09:30:29 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxi mean to say, enable filestream for t-sql access in sql server configuration manager for sql server services.Wed, 11 Jan 2012 09:25:08 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxDatabases that have a filestream filegroup can't be mirrored, so if you haven't enabled filestream then you're fine to mirror that DB.Wed, 11 Jan 2012 09:09:24 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxMay or May not be...Per [b]BOL[/b]:Database mirroring can be used with the following features or components of SQL Server.• Log shipping• Full-text catalogs• Database snapshots• ReplicationDon’t find anything on FILESTREAM articles either way (accepting / rejecting).For [b]More[/b]:[url]http://msdn.microsoft.com/en-us/library/ms189852.aspx[/url][url]http://msdn.microsoft.com/en-us/library/bb933993.aspx[/url]Wed, 11 Jan 2012 08:52:48 GMTDevhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxtomorrow i'll do it and get back to u for the same.i have not enable filestream. is any type of relation of both?.Wed, 11 Jan 2012 08:40:31 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]windows firewall is disable on both servers.[/quote]ok simple test, on the principal server go into administrative tools and open data source administrator. Create a new system DSN pointing to the mirror instance, at the end of the wizard click the test data source option and ensure it's successfulWed, 11 Jan 2012 06:50:16 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxApply the most recent transaction log to your mirror server and leave it.If you get the same error to reapply again.Wed, 11 Jan 2012 06:47:24 GMTkapfundestanleyhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxwindows firewall is disable on both servers.Wed, 11 Jan 2012 05:36:06 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]there r two server 1st one is primary server and 2nd server are two instances (Mirror and Witness)both are running on two different ports, and both server in one domain controller.[/quote]do you have Windows firewall enabled on the serversWed, 11 Jan 2012 05:22:22 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxFully Qualified Domain Name (e.g. www.google.com)Wed, 11 Jan 2012 04:53:20 GMTroasdasdb 89asdasdasd013http://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxthere r two server 1st one is primary server and 2nd server are two instances (Mirror and Witness)both are running on two different ports, and both server in one domain controller.Wed, 11 Jan 2012 04:25:09 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]how can system can't reach to own.[/quote]what do you mean by this?Are both instances on the same server?Wed, 11 Jan 2012 03:44:29 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]no firewalls between them, and both node are in same subnet mask..and i have checked using telnet command for this port, but i m configuring in primary server, how can system can't reach to own.[/quote]Have you made the host file entries on both server for each other ? I am not sure why, but this works some times.Wed, 11 Jan 2012 03:44:15 GMTDivine Flamehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxno firewalls between them, and both node are in same subnet mask..and i have checked using telnet command for this port, but i m configuring in primary server, how can system can't reach to own.Wed, 11 Jan 2012 03:34:00 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxsorryWed, 11 Jan 2012 03:27:50 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]yes i have specified FQDNs, please see attachment..[/quote]do you have any firewalls between the nodes (Windows or otherwise)Try a telnet to the port from the partner nodeWed, 11 Jan 2012 03:24:49 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxPatience. We all have our own jobs and our own problems and post here in our spare time. If you need immediate assistance, contact Microsoft CSS or hire someone.Wed, 11 Jan 2012 03:16:53 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxplease help....:hehe:Wed, 11 Jan 2012 03:07:16 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxyes i have specified FQDNs, please see attachment..Wed, 11 Jan 2012 02:23:47 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[b]F[/b]ully [b]Q[/b]ualified [b]D[/b]omain [b]N[/b]ame, example belowmy domain name is UKTrading.co.ukmy server name is SQLServer1The [b]FQDN[/b] for the server is SQLServer1.UKTrading.co.ukTo connect to this server in a mirror session using port 5022 i would useTCP://SQLServer1.UKTrading.co.uk:5022Wed, 11 Jan 2012 02:20:46 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxPlz find attachment for more detailsWed, 11 Jan 2012 02:17:36 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxi m sorry but, what is FQDNs?Wed, 11 Jan 2012 02:14:22 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]yes. but, when i m going to click on start mirror button then it is giving error.[/quote]even when you specify the FQDNs of the servers?Wed, 11 Jan 2012 02:09:41 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxyes. but, when i m going to click on start mirror button then it is giving error.Wed, 11 Jan 2012 01:58:17 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Perry Whittle (1/11/2012)[/b][hr]you cannot specify IP address in the Mirroring wizard GUI[/quote]Specify the FQDNs of the servers in the mirror GUI and try againhave you successfully created the endpoints?Wed, 11 Jan 2012 01:54:57 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxboth server in domain controller, and i have checked with the server name also, but same error is occurred, server is not reachable..Wed, 11 Jan 2012 01:49:44 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspx[quote][b]Dhirju (1/11/2012)[/b][hr]The server network address "TCP://192.168.147.24: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. (Microsoft SQL Server, Error: 1418)plz help me for this error, i m trying to configure DB mirrorring but every time i get this error.[/quote]you cannot specify IP address in the Mirroring wizard GUI, are your mirror servers part of a domain or a workgroupWed, 11 Jan 2012 01:47:17 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxyes, and i have checked the port(5022, 5023) has been opened using telnet command. i dont know where the problem. :crying:Wed, 11 Jan 2012 01:47:16 GMTDhirjuhttp://www.sqlservercentral.com/Forums/Topic1233774-391-1.aspxDoes that network address exist and can it be reached?Wed, 11 Jan 2012 01:44:27 GMTGilaMonster