Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Manage SQL Server services login (start) account and password     - Linux uses a screen recording under RecordMyDesktop (Linux)

- Use chattr and lsattr command to manage linux files and directory attributes (Linux)

- Linux Network Security Tips Share (Linux)

- Ant command-line compiler Android project (Programming)

- Thinking in Java study notes - everything is an object (Programming)

- Shell array: Define Shell array, the array length (Programming)

- Sshuttle A VPN-based transparent proxy that uses ssh (Server)

- CentOS 6.5 Telnet SecureCRT use management tools (Linux)

- Nagios plugin installation tutorial of Nrpe (Linux)

- Archlinux installation tutorial (Linux)

- CentOS7 boot systemd introduction and use of management (Linux)

- C ++ Supplements - Virtual Function Principle (Programming)

- Minimum period string problem (Programming)

- Oracle 11g new features and associated SQL TUNING (Database)

- Nginx DHCP TFTP Kickstart set up automatic installation system (Server)

- stat Usage: Get permission to file the corresponding figures (Linux)

- The new task parallel library feature in .NET 4.6 (Programming)

- Setting Wetty do not need an account login command line operations (Linux)

- How to install Linux on a MacBook Pro Retina (Linux)

- Java regular expressions examples (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:] 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.
- Linux mention the right notes (Linux)
- ORA-04031 Error Resolution (Database)
- Thrift 0.9.3 compiler installation under Ubuntu (Linux)
- How to install Perl modules from CPAN (Linux)
- Linux scp remote file copy (Linux)
- Linux operating system, the internal and external security overview (Linux)
- Java collections series (Programming)
- CentOS7 set boot directly into the command line interface (Linux)
- Installation Flow N Play- interface stylized video player on Ubuntu (Linux)
- How to clean up your Ubuntu 14.10 / 14.04 / 13.10 system (Linux)
- Install Web-based monitoring tool: Linux-Dash (Server)
- HDFS Hadoop Distributed File System Works (Server)
- MySQL 5.6 Open full query log (Database)
- C # DateTime structure common method (Programming)
- Linux System Getting Started Learning: compile and install ixgbe driver in Ubuntu or Debian (Linux)
- numpy and SciPy installation under Python for scientific computing package (Linux)
- Using open source software to build XWiki Wiki system installed within the company (Linux)
- ElasticSearch - Basic Concepts (Server)
- Talk about Java EE Learning (Programming)
- CentOS 6.4 installation and configuration LNMP build PHP server runtime environment (Server)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.