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

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
See my reply in .clients. Please don't post independently to several
newsgroups.
Andrew J. Kelly SQL MVP
"Li" <li@.adb.com.au> wrote in message
news:1cc201c46fbb$deb13760$a601280a@.phx.gbl...
> 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

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

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? ThanksSee my reply in .clients. Please don't post independently to several
newsgroups.
Andrew J. Kelly SQL MVP
"Li" <li@.adb.com.au> wrote in message
news:1cc201c46fbb$deb13760$a601280a@.phx.gbl...
> 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

Amendment to question.

Is there a way to remove the rights to add a new server login from a sys
admin server role member?
TIA,
JoeYou can't deny anything to a sysadmin - they can literally do anything on
the instance and any other permissions are ignored
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:45188460-768D-4806-9F6F-A9A53B9AC84A@.microsoft.com...
> Is there a way to remove the rights to add a new server login from a sys
> admin server role member?
> TIA,
> Joe
>

Always fails on Login

I don't get it. I'm trying to use Reporting Services to deploy my reports.
They always "forget" the datasource. I can run it on my local machine but
when I move it up to the co-lo it will work for a while and then it will just
fart.
and forget the datasource I try to set it through the admin and it dies
EVERY time.
I
BryanYou could try the following :
Go to the Report project properties by right clicking on
your Report Project in the IDE and selecting properties.
Out here set OverRideDataSource property to true. Then try
to deploy the reports.
>--Original Message--
>I don't get it. I'm trying to use Reporting Services to
deploy my reports.
>They always "forget" the datasource. I can run it on my
local machine but
>when I move it up to the co-lo it will work for a while
and then it will just
>fart.
>and forget the datasource I try to set it through the
admin and it dies
>EVERY time.
>I
>Bryan
>.
>

Alternative to Account Delegation?

Hello,
I want to run distributed queries via a linked server using a windows
autheniticated login. Talking with our AD/network admin about the steps in
http://msdn.microsoft.com/library/d...>
ity_2gmm.asp
they have a problem with setting up account delegation for service account
and sql server computer, mainly because this is a new precedent and they
don't want to go there unless absolutely necessary.
Are there any alternatives to doing the above that would enable distributed
queries using windows authenicated logins?
Thanks,
DanHi
No. The way the OS has to impersonate and delegate security across machine
boundaries requires this. If there was an easier way, we would all be using
it.
Your admins will need to get used to it. As security gets tightened inside
the OS, you will need to use it more and more.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dan H" wrote:

> Hello,
> I want to run distributed queries via a linked server using a windows
> autheniticated login. Talking with our AD/network admin about the steps i
n
> http://msdn.microsoft.com/library/d...
urity_2gmm.asp
> they have a problem with setting up account delegation for service account
> and sql server computer, mainly because this is a new precedent and they
> don't want to go there unless absolutely necessary.
> Are there any alternatives to doing the above that would enable distribute
d
> queries using windows authenicated logins?
> Thanks,
> Dan