NemCert
asked on
Mirror Problem in MSSQL2005
MS SQL 2005 "Mirror"
Have you verified that you can connect to the mirror server from the source server?
On the source server, go into SQL Server Management studio and verify that you can connect to the mirror server.
On the source server, go into SQL Server Management studio and verify that you can connect to the mirror server.
Actuallt scrub that, what you need to do is ensure that you do't have a firewall on
mtc-kw-bb02.corp.mtc.com.k w
which is blocking port 5022
mtc-kw-bb02.corp.mtc.com.k
which is blocking port 5022
ASKER
Dear All,
I checked my network fine there is no any firwalls between my two server i can connect to the mirror from the princible server ...
again the senario like this :
MTC-KW-BB01 : Princible
MTC-KW-BB02 : Miror
Network: Same subnet mask
Data Base Name: MSEGMGT
I checked my network fine there is no any firwalls between my two server i can connect to the mirror from the princible server ...
again the senario like this :
MTC-KW-BB01 : Princible
MTC-KW-BB02 : Miror
Network: Same subnet mask
Data Base Name: MSEGMGT
Have you checked
TELNET mtc-kw-bb02.corp.mtc.com.k w 5022
does it connect?
TELNET mtc-kw-bb02.corp.mtc.com.k
does it connect?
ASKER
Yes i can TELNET what could be the problem >?>>
That verifies that you have TCP/IP connectivity to that host and port. Therefore that rules out firewall issues. Which pretty much leaves me stumped.
If you run this on the SQL Server that is on mtc-kw-bb02.corp.mtc.com.k w, can you see your endpoint?
SELECT type_desc, port FROM sys.tcp_endpoints
If you run this on the SQL Server that is on mtc-kw-bb02.corp.mtc.com.k
SELECT type_desc, port FROM sys.tcp_endpoints
I have exactly same problem, I ran this on mirror server SELECT type_desc, port FROM sys.tcp_endpoints
following is the output which ensure that principle and mirror can see endpoints.
Type_Desc port
TSQL 0
TSQL 0
DATABASE_MIRRORING 5022
But i still could not figure out this problem infact i think that the error we get while starting mirroring is misleading. Your help would be highly appritiable.
Regards
Kamran
following is the output which ensure that principle and mirror can see endpoints.
Type_Desc port
TSQL 0
TSQL 0
DATABASE_MIRRORING 5022
But i still could not figure out this problem infact i think that the error we get while starting mirroring is misleading. Your help would be highly appritiable.
Regards
Kamran
Hello expert, let me give you another clue.
I just discovered that when I try to start mirroring on principle server and then at the same time i do netstat -n from command prompt, i can see the connection between principle and mirror server on port 5022 is at TIME_WAIT state rather than ESTABLISHED.
On the other hand when i do telnet between principle and mirror on port 5022 it connect, and while telnet session connected if i run netstat -n on another command prompt windows i can see ESTABLISHED state. Which means that as far as TCP/IP connectivity is concern it works fine but when it comes to SQL to connect it never established session.
So i think that there must be something to do with in SQL. Still your help will be appritiated.
thanks in advance.
Kamran
I just discovered that when I try to start mirroring on principle server and then at the same time i do netstat -n from command prompt, i can see the connection between principle and mirror server on port 5022 is at TIME_WAIT state rather than ESTABLISHED.
On the other hand when i do telnet between principle and mirror on port 5022 it connect, and while telnet session connected if i run netstat -n on another command prompt windows i can see ESTABLISHED state. Which means that as far as TCP/IP connectivity is concern it works fine but when it comes to SQL to connect it never established session.
So i think that there must be something to do with in SQL. Still your help will be appritiated.
thanks in advance.
Kamran
hmm I'm not sure if I can help much further. Perhaps ou could post a zero point pointer question, which will draw everyones attention to this thread.
what i have to do to post zero pointer question?
Kamran
Kamran
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In fact I will post a link now.
Thanks, nmcdermaid, I am on it. :)
Since it looks like there are no connectivity issues between the host (you can telnet from HOST1 -> HOST2:5022 etc.), then I would suspect that the problem is the authentication for the mirroring connections.
Could the asker please share with us the following information:
1. Are both machines in the same domain or they are in different domains or running as standalone servers?
2. If they are in the same domain, are both SQL Server instances running under the same domain account or are they running on local system accounts etc. ?
3. Could you please script your mirroring endpoints using SSMS and post it here? To script go to: Server Objects -> Endpoints -> Database Mirroring, select the endpooint and choose Script -> As CREATE -> to new query window. Please script the endpoints on both servers and post with your question.
Tech2010, please kindly open a new question with the description of your problem and information as above. Since you are not the original asker of this question, you will not be able to close it and assign points. The original question seems to be abandoned by the asker and will probably be forced closed soon.
Since it looks like there are no connectivity issues between the host (you can telnet from HOST1 -> HOST2:5022 etc.), then I would suspect that the problem is the authentication for the mirroring connections.
Could the asker please share with us the following information:
1. Are both machines in the same domain or they are in different domains or running as standalone servers?
2. If they are in the same domain, are both SQL Server instances running under the same domain account or are they running on local system accounts etc. ?
3. Could you please script your mirroring endpoints using SSMS and post it here? To script go to: Server Objects -> Endpoints -> Database Mirroring, select the endpooint and choose Script -> As CREATE -> to new query window. Please script the endpoints on both servers and post with your question.
Tech2010, please kindly open a new question with the description of your problem and information as above. Since you are not the original asker of this question, you will not be able to close it and assign points. The original question seems to be abandoned by the asker and will probably be forced closed soon.
ASKER
Hello again,
Yes the two machine in the same diomain with same privilge administrator
Yes the two machine in the same diomain with same privilge administrator
ASKER
TITLE: Database Properties
--------------------------
An error occurred while starting mirroring.
--------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'BESMGMT'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
--------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
The server network address "TCP://mtc-kw-bb02.corp.mt
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476