The reliability and security of the SQL Server are the two main factors which increase the usability and performance. Some of the conflicts cause the services to stops work as well as induced error like SQL Error 4064 which occurs when the database is not connected with the Server.
This error states that Cannot open user default database. Login failed.
Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)
Well to fix and eliminate this error First, click on Option>> Button of “Connect to Server” Prompt.
Now change the connect to database to any existing database on your server like master or msdb. Such method is very useful and appreciable when corruption at its low level but whenever level cross over these methods become useless hence failure to connect the database.
At such point the SQL password recovery software is beneficial to use which helps to reset the password the SQL Server database account. With the help of this software you can easily reset and recover the lost SQL Server SA password of any length any type. You can try the demo version of this tool which gives password hints of the lock SQL SA account quickly. But to reset password completely you need to purchase the license version of this software so must purchase the license version and get reset SQL Server SA password upto 2008 version.
Must read:- http://www.fixsqlserver.net/reset-sqlserver-password2008.html