Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Manage SQL Server services login (start) account and password     - View processes and threads under Linux (Linux)

- DRBD rapid installation and deployment (Server)

- IOS interview questions Summary (Programming)

- Physical backup and recovery SYSTEM table space (Database)

- CentOS 6.x and CentOS7 installation RPMforge (Linux)

- CentOS 6 rapid deployment of Java applications (Linux)

- Ubuntu install video conversion tool Selene (Linux)

- Create and modify Oracle temporary table space (Database)

- Ubuntu and derived versions of the user how to install G Mic 1.5.8.5 (Linux)

- Ansible installation configuration and simple to use (Server)

- Sysdig: system troubleshooting tool (Linux)

- CentOS / Linux NIC set IP address configuration (Linux)

- Simple steps allows you to build a more secure Linux server (Linux)

- Oracle 11R2 Grid Infrastructure execute root.sh script rootcrs.pl execution failed treatment (Database)

- Python Socket Network Programming (Programming)

- Ubuntu 12.04 configure NVIDIA CUDA 5.5 Record (Linux)

- Object-C in the preparation of multi-parameter function parameter is omitted (Programming)

- MySQL time field based partitioning scheme summary (Database)

- Android design patterns - state mode (Programming)

- Java eight new features 8 (Programming)

 
         
  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:      
 
- To install and deploy Java applications under CentOS 6.5 (Linux)
- MultiWriter: while the ISO image concurrent writes 20 USB Startup Disk (Linux)
- Oracle database import and export (Database)
- Linux start the process (Linux)
- Linux Security Module (LSM) Introduction (Linux)
- 10 Best Swift Tutorial examples (Programming)
- The difference between Linux su and sudo commands (Linux)
- ORA-4031 error Solution (Database)
- How to install Ubuntu California - the calendar application (Linux)
- How to configure security services under Linux (Linux)
- Installation Experience open source car Automotive Grade Linux system (Linux)
- Oracle data row split multiple lines (Database)
- Installation GitLab appears ruby_block supervise_redis_sleep action run (Linux)
- A deep understanding of Java enum (Programming)
- CentOS install Memcached (Server)
- Debian (Wheezy) were installed wxPython GUI development (Linux)
- Mac Docker deploy development environment (Server)
- Qt for file splitting and fusion gadgets (Programming)
- There is sort of a directed acyclic graph topology (Programming)
- Static member variable modified (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.