sql2005 1418 hatasi - sql server 2005 database mirroring

vazgecmek degil ama bu noktadan sonra ne yapacagimi bilmiyorum hemem hemen hersei denedim sorunun ne oldugunu bulamiyorum

Merhabalar,

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=258365&SiteID=1  adresindeki 26 adimlik surece gore Database Mirroring islemini tekrar yaparmisiniz?

Mesut ALADAG

Technology Director

Microsoft Certified Trainer

www.ITSTACK.com.tr | www.mesutaladag.com | www.cozumpark.com

Error:
1418 - Microsoft SQL Server - The server network address can not be
reached or does not exist. Check the network address name and reissue
the command

The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

Fix/Workaround/Solution:

Step 1) Your system Firewall should not block SQL Server port.

Step 2) Go to Computer Management >> Service and Application
>> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

Just to make sure follow one more step which may or may not be necessary.

Step 3) Go to Computer Management >> Service and Application
>> SQL Server 2005 Configuration >> Client Configuration
Enable TCP/IP protocol.

mesut bey bilgi icin tesekkur ederim o maddeleri bu aksam tekrardan kontrol edicem tesekkurler

gene olmadi 🙁 sanirim sorun bende

sizin makineler de amma inatmis 🙂 hala bekliyorum, acaba sorunu cozen cikar mi diye

hala ugrasiyorum ama bi sonuc yok

arkadaslar ben problemi cozdum suan sql miror calişiyor 🙂

peki bizimlede paylaşmayı hatta makalesini yazmayı düşünürmüsün.

tabiki yazicam suan derliyorum bitince buraya yazarim

Ben merakla bekliyor olacağım 🙂

sql 2005 miroring

konfigurasyon icin sistemimde 3 adet server ve ozellikleri

1 Principal Server win2003 sbs pre (AD DNS DHCP) sp2 Bütün updateleri yapili durumda  SQL2005 Developer SP2 yuklu  

2  Mirror Server win2000 server domain joined sp4 ve updateleri yapili  SQL2005 Developer SP2 yuklu  

3 Witness Server win2003 stnd sp2 ve butun updateleri yapili  SQL2005 Developer SP2 yuklu  

sql mirorin işlemine baslamadan once aşagidaki adimlari kontrol ediyoruz

--- SQL Server Surface Area Configuration dan administrator e sysadmin rol ekliyoruz

---   SQL Server Configuration Manager TCP/İP , Named pipes in enable yapiyoruz

--- eger sistemde bir firewall kullaniyorsak firewall dan 1433 ve sql mirorin icin 5022 portlarini aciyoruz

---  SQL Server Management Studio acip mirorin işlrmi icin kullanacagimiz database in ozelliklerine girip recovery model i   full olarak seciyoruz

---  databaseimizin ful  backup unu aliyoruz

--- transactions log un backup unu aliyoruz

--- Mirror Server aldigimiz yedekleri no recovery secenegiyle restore ediyoruz

bundan sonra asagidaki scripleri sirasi ile caliştirmaniz yeterli

--- HOST A = Principal Server , HOST B = Mirror Server , HOST W = Witness Server

 -- Principal Server
      create master key encryption by password = 'abc123!!';
      GO

      create certificate HOST_A_cert with subject = 'HOST_A certificate',
start_date = '2007/11/11', expiry_date = '2020/11/11';
      GO

      Create endpoint endpoint_mirroring state = started
      as tcp(listener_port = 5022, listener_ip = all)
      for database_mirroring (authentication = certificate HOST_A_cert,
encryption = disabled, role = all);
      GO

      Backup certificate HOST_A_cert to file = 'c:\HOST_A_cert.cer';
      GO

      -- Mirror Server
      create master key encryption by password = 'abc123!!';
      GO

      create certificate HOST_B_cert with subject = 'HOST_B certificate',
start_date = '2008/11/11', expiry_date = '2020/11/11';
      GO

      Create endpoint endpoint_mirroring state = started
      as tcp(listener_port = 5022, listener_ip = all)
      for database_mirroring (authentication = certificate HOST_B_cert,
encryption = disabled, role = all);
      GO

      Backup certificate HOST_B_cert to file = 'c:\HOST_B_cert.cer';
      GO

      -- Witness Server
      create master key encryption by password = 'abc123!!';
      GO

      create certificate HOST_W_cert with subject = 'HOST_W certificate',
start_date = '2008/11/11', expiry_date = '2020/11/11';
      GO

      Create endpoint endpoint_mirroring state = started
      as tcp(listener_port = 5022, listener_ip = all)
      for database_mirroring (authentication = certificate HOST_W_cert,
encryption = disabled, role = witness);
      GO

      Backup certificate HOST_W_cert to file = 'c:\HOST_W_cert.cer';
      GO

      -- Principal Server
      create login HOST_B_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_B_user from login HOST_B_login;
      GO

      Create certificate HOST_B_cert
      Authorization HOST_B_user
      From file = 'c:\HOST_B_cert.cer';
      GO

      Grant CONNECT ON Endpoint::endpoint_mirroring to [HOST_B_login];
      GO
      ------
      create login HOST_W_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_W_user from login HOST_W_login;
      GO

      Create certificate HOST_W_cert
      Authorization HOST_W_user
      From file = 'c:\HOST_W_cert.cer';
      GO

      Grant CONNECT ON Endpoint::endpoint_mirroring to [HOST_W_login];
      GO

      -- Mirror Server
      create login HOST_A_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_A_user from login HOST_A_login;
      GO

      Create certificate HOST_A_cert
      Authorization HOST_A_user
      From file = 'c:\HOST_A_cert.cer';
      GO

      Grant CONNECT ON Endpoint::Endpoint_mirroring to [HOST_A_login];
      GO

      -------
      create login HOST_W_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_W_user from login HOST_W_login;
      GO

      Create certificate HOST_W_cert
      Authorization HOST_W_user
      From file = 'c:\HOST_W_cert.cer';
      GO

      Grant CONNECT ON Endpoint::Endpoint_mirroring to [HOST_W_login];
      GO

      -- Witness Server
      create login HOST_A_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_A_user from login HOST_A_login;
      GO

      Create certificate HOST_A_cert
      Authorization HOST_A_user
      From file = 'c:\HOST_A_cert.cer';
      GO

      Grant CONNECT ON Endpoint::Endpoint_mirroring to [HOST_A_login];
      GO

      -------
      create login HOST_B_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_B_user from login HOST_B_login;
      GO

      Create certificate HOST_B_cert
      Authorization HOST_B_user
      From file = 'c:\HOST_B_cert.cer';
      GO

      Grant CONNECT ON Endpoint::endpoint_mirroring to [HOST_B_login];
      GO

      -- Mirror Server
      alter database  set partner = 'TCP://Principalpcismi.domain.com:5022';
      GO

      -- Principal Server
      alter database set partner = 'TCP://mirorpcismi.domain.com:5022';
      GO

      alter database set witness = 'TCP://Witnesspcismi.domain.com:5022';
      GO

daha sonra Principal Server da blunan database sag tiklayip task lach database miroring monitorden instance eklenerek sql miror işlemi monitor edilebilir

 

sql 2005 miroring

konfigurasyon icin sistemimde 3 adet server ve ozellikleri

1 Principal Server win2003 sbs pre (AD DNS DHCP) sp2 Bütün updateleri yapili durumda  SQL2005 Developer SP2 yuklu  

2  Mirror Server win2000 server domain joined sp4 ve updateleri yapili  SQL2005 Developer SP2 yuklu  

3 Witness Server win2003 stnd sp2 ve butun updateleri yapili  SQL2005 Developer SP2 yuklu  

sql mirorin işlemine baslamadan once aşagidaki adimlari kontrol ediyoruz

--- SQL Server Surface Area Configuration dan administrator e sysadmin rol ekliyoruz

---   SQL Server Configuration Manager TCP/İP , Named pipes in enable yapiyoruz

--- eger sistemde bir firewall kullaniyorsak firewall dan 1433 ve sql mirorin icin 5022 portlarini aciyoruz

---  SQL Server Management Studio acip mirorin işlrmi icin kullanacagimiz database in ozelliklerine girip recovery model i   full olarak seciyoruz

---  databaseimizin ful  backup unu aliyoruz

--- transactions log un backup unu aliyoruz

--- Mirror Server aldigimiz yedekleri no recovery secenegiyle restore ediyoruz

bundan sonra asagidaki scripleri sirasi ile caliştirmaniz yeterli

--- HOST A = Principal Server , HOST B = Mirror Server , HOST W = Witness Server

 

 -- Principal Server
      create master key encryption by password = 'abc123!!';
      GO

      create certificate HOST_A_cert with subject = 'HOST_A certificate',
start_date = '2007/11/11', expiry_date = '2020/11/11';
      GO

      Create endpoint endpoint_mirroring state = started
      as tcp(listener_port = 5022, listener_ip = all)
      for database_mirroring (authentication = certificate HOST_A_cert,
encryption = disabled, role = all);
      GO

      Backup certificate HOST_A_cert to file = 'c:\HOST_A_cert.cer';
      GO

      -- Mirror Server
      create master key encryption by password = 'abc123!!';
      GO

      create certificate HOST_B_cert with subject = 'HOST_B certificate',
start_date = '2008/11/11', expiry_date = '2020/11/11';
      GO

      Create endpoint endpoint_mirroring state = started
      as tcp(listener_port = 5022, listener_ip = all)
      for database_mirroring (authentication = certificate HOST_B_cert,
encryption = disabled, role = all);
      GO

      Backup certificate HOST_B_cert to file = 'c:\HOST_B_cert.cer';
      GO

      -- Witness Server
      create master key encryption by password = 'abc123!!';
      GO

      create certificate HOST_W_cert with subject = 'HOST_W certificate',
start_date = '2008/11/11', expiry_date = '2020/11/11';
      GO

      Create endpoint endpoint_mirroring state = started
      as tcp(listener_port = 5022, listener_ip = all)
      for database_mirroring (authentication = certificate HOST_W_cert,
encryption = disabled, role = witness);
      GO

      Backup certificate HOST_W_cert to file = 'c:\HOST_W_cert.cer';
      GO

      -- Principal Server
      create login HOST_B_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_B_user from login HOST_B_login;
      GO

      Create certificate HOST_B_cert
      Authorization HOST_B_user
      From file = 'c:\HOST_B_cert.cer';
      GO

      Grant CONNECT ON Endpoint::endpoint_mirroring to [HOST_B_login];
      GO
      ------
      create login HOST_W_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_W_user from login HOST_W_login;
      GO

      Create certificate HOST_W_cert
      Authorization HOST_W_user
      From file = 'c:\HOST_W_cert.cer';
      GO

      Grant CONNECT ON Endpoint::endpoint_mirroring to [HOST_W_login];
      GO

      -- Mirror Server
      create login HOST_A_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_A_user from login HOST_A_login;
      GO

      Create certificate HOST_A_cert
      Authorization HOST_A_user
      From file = 'c:\HOST_A_cert.cer';
      GO

      Grant CONNECT ON Endpoint::Endpoint_mirroring to [HOST_A_login];
      GO

      -------
      create login HOST_W_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_W_user from login HOST_W_login;
      GO

      Create certificate HOST_W_cert
      Authorization HOST_W_user
      From file = 'c:\HOST_W_cert.cer';
      GO

      Grant CONNECT ON Endpoint::Endpoint_mirroring to [HOST_W_login];
      GO

      -- Witness Server
      create login HOST_A_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_A_user from login HOST_A_login;
      GO

      Create certificate HOST_A_cert
      Authorization HOST_A_user
      From file = 'c:\HOST_A_cert.cer';
      GO

      Grant CONNECT ON Endpoint::Endpoint_mirroring to [HOST_A_login];
      GO

      -------
      create login HOST_B_login with PASSWORD = 'abc123!!';
      GO

      create user HOST_B_user from login HOST_B_login;
      GO

      Create certificate HOST_B_cert
      Authorization HOST_B_user
      From file = 'c:\HOST_B_cert.cer';
      GO

      Grant CONNECT ON Endpoint::endpoint_mirroring to [HOST_B_login];
      GO

      -- Mirror Server
      alter database  set partner = 'TCP://Principalpcismi.domain.com:5022';
      GO

      -- Principal Server
      alter database set partner = 'TCP://mirorpcismi.domain.com:5022';
      GO

      alter database set witness = 'TCP://Witnesspcismi.domain.com:5022';
      GO

daha sonra Principal Server da blunan database sag tiklayip task lach database miroring monitorden instance eklenerek sql miror işlemi monitor edilebilir

 

Geri bildirim için teşekkürler.