CodePudding user response:
Is estimated to be in your new computer installed in the database with the original computer database setup is different, generally fail to log in sa is basically to install the database Settings, such as the original login login is sa, is also likely to have a password, but the new computer when installing the database is not sa login or password error, etc., this you must know that the original computer installation Settings, new computer database installation Settings must be consistent with the original computer Settings can be,CodePudding user response:
In a 64 - bit Windows:64 exe and DLL in the directory c: \ Windows \ sys tem32 directory.
32 bit exe and DLL in the directory c: \ Windows \ sys wow64 directory.
So pay attention to:
In win64 system registered under 32-bit ocx DLL to 32 ocx or copy the DLL to the c: \ Windows \ syswow64 \ directory,
And registered to c: \ Windows \ syswow64 \ regsvr32 XXXXXXX ocx or DLL
Under win64 a system set up 32-bit programs use a database alias to c: \ Windows \ \ syswow64 \ cliconfg exe
Under win64 a system set up a 32-bit application system DSN to c: \ Windows \ \ syswow64 \ odbcad32 exe
CodePudding user response:
Logon failure:1, the password changed,
2, sa, the user is not enabled,