an error of login "sa" with Error 18456 Level 14

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Li (li_at_adb.com.au)
Date: 07/22/04


Date: Thu, 22 Jul 2004 00:16:55 -0700

I got an error of login "sa" with Error 18456 Level 14 .
Server A is the MSSQL Server where the database sit and
the other Server B is just with MSSQL Server tool which
act as a Terminal Service and have the Accounting
applications.The Accounting application unable to perform
its database transfer to another application on the
Terminal Service. We use Window 2003 Server. The
application programs are fine. The ODBC, MSSQL and
application "sa" password are identical. Any idea? Thanks



Relevant Pages

  • Re: Cant copy database
    ... Copy database files to another machine. ... Start the original MSSQL Server and forget about it forever. ... I use sa as the account ...
    (microsoft.public.sqlserver)
  • Re: Re-installed SQL 7 and trying to use already existing dbs without doing a restore
    ... SQL Server tracks quite a bit more than filenames and logical names created ... > as the actual database files. ... I then stopped the MSSQL Server and copied my ...
    (microsoft.public.sqlserver.setup)
  • Maintaining local and remote databases with MSSSE?
    ... I'm trying to move database structure, and if possible, complete databases ... between my local PC and my domain hosts MSSQL server. ... I've got MSSQL 2005 server express. ... At my host I believe that they ...
    (microsoft.public.sqlserver)
  • Migrate wss to server farm
    ... I've managed to take a backup of the content and config MSDE database ... and restored it on the MSSQL server. ... Install WSS on one server? ...
    (microsoft.public.sharepoint.windowsservices)
  • I got an error of login "sa" with Error 18456 Level 14
    ... Server A is the MSSQL Server where the database sit and ... act as a Terminal Service and have the Accounting ... its database transfer to another application on the ...
    (microsoft.public.sqlserver.security)