Workaround for SQL Server 2014 failed to open user default database logon failure error 4064

workaround for SQL Server 2014 failed to open user default database Logon failure error 4064

Did a stupid thing in the evening, deleted the administrator account of the default database, followed by a header error.

The solution is as follows:

First step: Open the Command console

Win+r open Run, input cmd

The second step: copy and paste the following command

SQLCMD-E-D "Master"-Q "exec sp_defaultdb n 'pc\admin', n ' master '"

Note: change the previous command pc\admin to your actual account , using backslash (\)

And then there's no more.

Reference: http://www.jb51.net/article/59312.htm

Workaround for SQL Server 2014 failed to open user default database logon failure error 4064