sql2005 1418 hatasi - sql server 2005 database mirroring

win2003 sbs premium ustunde (ad dns dhcp var)sql2005 developer editions yuklu hem sbsnin hemde sql 2005 in sp2 yuklu  diger pcsde win200 server domaine logon oluyor admin olarak ve ustunde sql2005 developer edition yuklu ve sp2 yuklu  sistemde firewall yok 2 pcde miror yapmaya calişiyorum witness olmadan yapmaya calişiyorum

win2003 sbs premium ustunde (ad dns dhcp var)sql2005 developer editions yuklu hem sbsnin hemde sql 2005 in sp2 yuklu  diger pcsde win200 server domaine logon oluyor admin olarak ve ustunde sql2005 developer edition yuklu ve sp2 yuklu  sistemde firewall yok 2 pcde miror yapmaya calişiyorum witness olmadan yapmaya calişiyorum

 

İşletim sistemlerinin SP leri nedir. Sanırım işletim sistemlerinde bir sıkıntı var. 

win2003 de sp2 ve butun guncellemeler tamam win2000de sp4 butun guncellmeler tamam

Database Mirroring yapmanız için  hem principal hem de mirror makina tarafında  SQL Server 2005 Standard, Enterprise ve ya  Developer editions plus SQL Server 2005  SP2  olmalıdır.

kolay gelsin.

Database Mirroring yapmanız için  hem principal hem de mirror makina tarafında  SQL Server 2005 Standard, Enterprise ve ya  Developer editions plus SQL Server 2005  SP2  olmalıdır.

 

kolay gelsin.

Arkadaşımız zaten her iki makinadada sql2005 developer editions
Sp2 yüklü olduğunu belirtmiş.

SELECT type_desc, port FROM sys.tcp_endpoints;
SELECT name,role,state_desc FROM sys.database_mirroring_endpoints;

bu komutları kullandıktan sonra sonuç olarak size ne sonucu veriyor.

kolay gelsin.

type_desc                                         port

1 tsql                                                 0

2 tsql                                                 0

3 DATABASE_MIRRORING               5022

         name              role       state_ desc

1        miroring           1           started

2 sqlledede boyle yaziyor o komutlari caliştirinca

ne yapmam grekli vazmi geceyim mirordan

yardim edebilecek kimse yokmu 

1. Make sure all your Servers are running under the same account under Services
2. Go to your primary server's Microsoft SQL Management Studio.
3. Right click the database you wish to mirror and click backup (This is a two part step. Pay close attention).
4. Do a FULL backup of your database to any place. Wait for this to finish.
5. Do a Transaction log backup. (I tried it without this and was part of my failure)>
6. Go to your mirror server's Microsoft SQL Management Studio.
7. The database should not exist here yet. Right click Databases and click Restore Database...
8. Type the database name in the "To Database" text box.
9. Click From Device and get add your main bak file.
10. Check the Restore box and then click Options at the top left.
11. On the Recovery state set RESTORE WITH NORECOVERY (The second radio button).
12. Once that is done. Repeat the Recovery steps for the transaction file backup. (It also needs NORECOVERY on options).
13. Go back to the Primary Server's Management Studio and right click the database to be mirrored.
14. Select Tasks and then Mirroring.
15. Configure Security. Make sure Encrypt data is off on all of the server connections
    (Another issue I had during setup. My witness server had "Encrypt data
    sent through this endpoint" set to on and it broke. See the note below
    on how to remove Encrypt data if it is prepopulated and you can't
    uncheck it.
16. Leave the Security boxes blank.
17. Click Start Mirroring and watch your mirror with the mirroring monitor (Screenshot below).

Notes

• If you plan on using SQL Express for the Witness (A great
  choice), make sure you go into it's SQL Server Configuration Manager
  and enable TCP/IP under Protocols.
• To clear an endpoint's Encryption flag, write down or
  remember the EndPoint name where the box is greyed out. Cancel out of
  the Security wizard. Connect to the witness server and execute the
  following command. DROP ENDPOINT <Endpoint Name>
• If you are getting an error you cannot figure out (eg 1418)
  then remember to check the Server's Application Event Log as it may
  provide a clue.
• Please edit this WIKI if you had any issues.
• Getting Sql 2005 Mirroring EndPoints:

Sonuş nedir paylaşır mısınız?

henuz duzelmedi herseyi terkrar tekrar bastan yapmama ragmen 1418 hatasi almaya devam ediyorum bi sonuc yok kisacasi

bi sonuca ulasamadim hala 1418 hatasi aliyorum ne yaptimsa olmadi 

Merhabalar,

SQL de mirroring yapıyor musunuz? Herhangi bir firewall arkasındamı?

Buradaki adımlarla bir check edermisiniz http://www.dosya.tc/Database_Mirroring_in_SQL_Server_2005.doc.html

sistemde bi firewall yok

senin gonderdigin word documanindaki  

CREATE ENDPOINT endPointName [ AUTHORIZATION login ]
[ STATE = { STARTED | STOPPED | DISABLED } ]
AS { HTTP | TCP } (
<protocol_specific_arguments>
)
FOR { SOAP | TSQL | SERVICE_BROKER | DATABASE_MIRRORING } (
<language_specific_arguments>
)

<AS TCP_protocol_specific_arguments> ::=
AS TCP (
LISTENER_PORT = listenerPort
[ [ , ] LISTENER_IP = ALL | ( 4-part-ip ) | ( "ip_address_v6" ) ]

)

<FOR DATABASE_MIRRORING_language_specific_arguments> ::=
FOR DATABASE_MIRRORING (
[ AUTHENTICATION = {
WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ]
| CERTIFICATE certificate_name
| WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] CERTIFICATE certificate_name
| CERTIFICATE certificate_name WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ]
[ [ [ , ] ] ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }
[ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ] }

    ]
[ , ] ROLE = { WITNESS | PARTNER | ALL }
)

bu scripti caliştirinca  asagidaki hatayi veriyor

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ' AUTHORIZATION login '.

Merhaba

mirror işlemi için aşağıdaki adımları kontrol edermisiniz

http://msdn.microsoft.com/en-us/library/bb510479.aspx

http://msdn.microsoft.com/en-us/library/ms188712.aspx

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html

verilen linkleri daha onceden kontrol ettim sanirim gozden kacirdigim bişi var ama bulamiyorum bu konuda cevap veren herkese tesekkurler

eee ne yaptınız vaz mı gectiniz