Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Manage SQL Server services login (start) account and password     - Use Ansible efficient delivery Docker container (Server)

- Linux remote connectivity tools -OpenSSH (Linux)

- SSH port forwarding application (Server)

- Oracle 12C RAC optimizer_adaptive_features cause of data into overtime (Database)

- The free command in Linux (Linux)

- Linux crontab commands and detailed usage examples (Linux)

- Hunk / Hadoop: Performance Best Practices (Server)

- After installation of Debian 6.0 do a few things first (Linux)

- MNIST presentation and database conversion (Database)

- RPM package management under Linux (Linux)

- Vagrant Getting Start (Linux)

- How to understand the difference between synchronous and asynchronous non-blocking blocking (Programming)

- J2EE Example of Filter (Programming)

- Linux formatted partition error Could not stat / dev / sda No such file or directory Solution (Linux)

- How to Install Android Studio on Ubuntu 15.04 / CentOS7 (Linux)

- 8 Docker knowledge you may not know (Server)

- Linux common network tools: batch scanning of hosting services netcat (Linux)

- PostgreSQL export data dictionary documents (Database)

- Linux Systems Getting Started Learning: Configuration PCI passthrough on a virtual machine (Linux)

- Object-oriented language Java some of the basic features (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:      
 
- Windows environment Android Studio v1.0 Installation Guide (Linux)
- About Linux backdoor (Linux)
- Several reasons MySQL garbled (Database)
- How MySQL tracking sql statement (Database)
- Rails 4.1.6 start being given Could not find a JavaScript runtime (Linux)
- Ubuntu Tutorial: E: Failed to get lock / var / lib / apt / lists / lock - open (Linux)
- Use OpenSSL to generate a certificate detailed process (Linux)
- RocketMQ Message Queuing simple deployment (Linux)
- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)
- Ubuntu 13.04 configure MyEclipse 10.7 Environment (Linux)
- Linux Getting Started tutorial: Ubuntu 14.04 in the installation Sogou Pinyin (Linux)
- Linux command line to put on your coat GUI (Linux)
- CentOS6 install Redis (Database)
- PL / SQL in forall simple test (Database)
- Java multithreading easy to confuse the concept (Programming)
- CentOS 6.5 can not connect to the network under VMware (Linux)
- Simple to use multi-threaded programming under Linux mutex and condition variable (Programming)
- Embedded Linux Optimization (Programming)
- Achieve single backup of MySQL by innobackupex (Database)
- Grep, Ack, Ag searches Efficiency Comparison (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.