Re: Credential error when using SSPI
- From: "Warren Brunk" <wbrunk@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Sep 2006 11:27:21 -0700
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@xxxxxxxxxx> wrote in message
news:eR058I11GHA.1268@xxxxxxxxxxxxxxxxxxxxxxx
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?
.
- References:
- Credential error when using SSPI
- From: William
- Credential error when using SSPI
- Prev by Date: Re: Security risk for Excel on SQL Server Box?
- Next by Date: Re: Security risk for Excel on SQL Server Box?
- Previous by thread: Credential error when using SSPI
- Next by thread: Re: sp_detach_db when not using a system administrator role
- Index(es):
Relevant Pages
|
|