Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Manage SQL Server services login (start) account and password     - Struts2 dynamic call DMI and error Solution (Programming)

- When a software RAID data recovery and reconstruction of how failure (Linux)

- Java open source monitoring platform Zorka basic use (Linux)

- OpenSIPS offline messaging feature set (Server)

- Getting CentOS Learning Notes (Linux)

- Ubuntu Gitolite management Git Server code base permissions (Server)

- Compile and install GCC 4.8.1 + GDB 7.6.1 + Eclipse in CentOS 6.4 in (Linux)

- Expand an existing RAID arrays and remove the failed disk in a RAID (Linux)

- C ++ why we chose to use the smart pointer (Programming)

- Use the command line MySQL database backup and recovery (Database)

- CentOS yum source as the default setting methods in DVD (Linux)

- Using LLVM Clang and Blocks under Linux (Programming)

- Ubuntu install ruby (Linux)

- VMware difference in three network connection (Linux)

- Linux Mint 17.2 64 bit installation Docker and management software seagull (Linux)

- How to create a remote (Linux)

- DRBD + Heartbeat solve NFS single point of failure (Server)

- Linux system package manager -RPM (Linux)

- Tecplot Installation under Linux (Linux)

- MySQL Tutorial: About checkpoint mechanism (Database)

 
         
  Manage SQL Server services login (start) account and password
     
  Add Date : 2018-11-21      
         
         
         
  Today addressed a alwaysOn problem - a secondary copy because of insufficient disk space has not synchronized display [-] suspicious, you can see in the log database in a suspended state, out of sync with the master copy. Simply thought to be a secondary copy of the disk cleanup to free up a little space, and then restart the SQL Server service just fine (restart to make the database from the suspend state into an online state, then let alwaysOn restart sync).
However, failure to restart! ! !
See the operating system log Cause SQL Server failed to start is to start :( account) user name and password is wrong! ! !

AlwaysOn had to do when convenience, the direct use of a domain administrator user name and password, then for the sake of security policy, the account password is re-turn, and then no one remembers to modify the startup account password synchronization for SQL Server. On normal, as long as SQL Server does not restart, the password does not change it, all right, but after the restart, you must use the correct password. Otherwise this error.
So to solve this problem simply modify the correct password.

Even so, alwaysOn still will not immediately restore synchronization, you can see from the database log, and the other unfortunate things happened:

Database Mirroring login attempt failed with error: 'Connection handshake failed An OS call failed (8009030c)) x8009030c (login without success). . State.67 '[client: 10.1.2.2]

10.1.2.2 is alwaysOn master copy IP, given the information from the point of view, is a master copy of the database mirroring endpoint (AlwaysOn use database mirroring endpoint for communication) can not log on to the secondary replica.
This is a problem account login. We just changed the secondary replica login account password, but does not modify the master copy of the master copy or with an expired password to access the secondary replica mirroring endpoint, secondary replica will naturally reject the connection request, so we need (in a non business hours) to modify the password logon account under the master copy, and then restart SQL Server on it.
 
Database mirroring endpoint connection is re-established, the error will not be there, but this still does not recover alwaysOn synchronization, but also on the secondary replica database available right click and select "Restore Data Movement", since only alwaysOn began to recover synchronization.

In fact, this problem can be avoided, if at the time SQL Server starts accounts using a separate, dedicated account will not have this problem, in fact, we also recommend such accounts to try to separate business accounts to avoid mutual influence.
     
         
         
         
  More:      
 
- Access clipboard content across multiple vim instances in a terminal (Linux)
- Git commands (Linux)
- JavaScript file loader LABjs API Explanation (Programming)
- Linux basis: a comprehensive study pwd command (Linux)
- Android Activity launchMode (Programming)
- DRBD installation configuration, working principle and Recovery (Server)
- Oriented C ++ test-driven development (Programming)
- To read the Linux ext3 / ext4 format partitions under Windows system software (Linux)
- ASM required disk format process in Solaris platforms (Linux)
- See Shell Script Linux Server network traffic (Server)
- Make full use of the Raspberry Pi SD card space (Linux)
- Ubuntu 14.10 Install Ubuntu Touch Music App 2.0 (Linux)
- C ++ class implementation date operator overloading (Programming)
- Python class of operator overloading (Programming)
- The free command in Linux (Linux)
- Linux raw socket (Programming)
- Timeout control related to Python threads and a simple application (Programming)
- Java Collections Framework interfaces map (Programming)
- Spark parquet merge metadata problem (Server)
- JBPM6 Tutorial - Fast Fun JBPM table (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.