Solution to SQL login mode problem

Two days ago to the other people to debug the server, the system and the database are installed in advance, in the server a series of security configuration found that the site's own account can not be contacted locally. Depressed, configured for half a day while making a mirror but still not sure the problem appears there. Needless to say, since it is a database access error, check the database first.

As expected, the Query Analyzer opened after the use of Windows user login can be used normally, but the use of account login is not, it seems that the problem is here. Although each time when the database is installed in the choice of account login mode to choose a hybrid login, but this time is not installed on their own, can not fully determine whether the current mode is mixed login. After asking the person who installed the software, he remembers to choose the mixed login mode, the result is no way, can only restore the system to a mirror phase again to test, the result is still the problem. It seems likely that the account login mode Setup problem, but the total can not uninstall the database from the new installation it! You can only look it up on the Internet. There is no way to troubleshoot SQL at a later stage.

After their own search finally in the online blog to find a way. Select a property in the database name group, and you can find the set method in security. Results when the Security tab is turned on, the login mode is "Only use Windows login", not to say that the login mode can be changed to both, solve the problem! Ha ha...... And a way to master it.

Of course, in addition to solve the problem of SQL login mode, but also learned how to use the SQL database backup software remote backup of the database method, this method can be a virtual host database backup. Of course, this is related to the maintenance of virtual host technology, I think through the derivation can also understand how it works, have the opportunity to study their own server.