credential problem with sp3a setup

for anybody interested in this issue. The problem was
that the account used for the setup was in a different
domain than the server domain
>--Original Message--
>We just installed a SQL 2000 instance in a 2 nodes W2003
>cluster. The services are running with a domain account
>which is local administrator on both nodes. When we
start
>the setup for the SQL SP3 on the active node, we get to
>the remote setup window, where it asks username,
pasword,
>and domain for the setup on both cluster nodes, we enter
>the info about the same domain account we used for the
>SQL2K setup, if gets backs saying "The caller is not the
>owner of the desired credentials", and won't let us
>continue. Any idea ?
>.
>
I am having the same problem. In my company servers are on one domain and
user accounts are on a different domain. How would you work around this
problem?
thanks
Mike
"anonymous@.discussions.microsoft.com" wrote:

> for anybody interested in this issue. The problem was
> that the account used for the setup was in a different
> domain than the server domain
> start
> pasword,
>

Credential error when using SSPI

I have a SQL Server database that I am able to connect to using Visual
Studio 2005 Server Explorer. However, when I attempt to establish a
connection in a C# program using SSPI, I get a login failure using the same
credentials used with Server Explorer.
Does anyone know what might cause this?Double check and make sure that your connection string is spelled correctly.
I sometimes like using ODBC manager to double check to make sure the
connection works that way. It uses your windows credentials as does SSIS
should you choose to look at it that way.
thanks,
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"William" <nfr@.nospam.com> wrote in message
news:eR058I11GHA.1268@.TK2MSFTNGP02.phx.gbl...
>I have a SQL Server database that I am able to connect to using Visual
>Studio 2005 Server Explorer. However, when I attempt to establish a
>connection in a C# program using SSPI, I get a login failure using the same
>credentials used with Server Explorer.
> Does anyone know what might cause this?
>