Re: Credential error when using SSPI



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?



.



Relevant Pages

  • RE: How to: List a table in Tables holder of Server Explorer
    ... 1.Click Connect to Database icon in Server Explorer. ... button in Add Connection window. ... 3.Select "Microsoft ODBC Data Source" from Data source list in Change Data ... 5.Select MS Access Database from Computer Data source. ...
    (microsoft.public.vsnet.general)
  • Re: Need help in VB.NET connecting to Access database
    ... >provier to MS Jet 4.0 OLE DB PRovider, then back to the Connection tab. ... create the data connection using Server Explorer no problem. ... Private Sub Button1_Click(ByVal sender As System.Object, ... perhaps as part of a Custom installation that may be missing? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ComboBox Row Source = Result of DB Query?
    ... The easiest way would be to drag the table from server explorer (you ... will need to create a new DB connection to the access table in the ... required connections and adapters get automatically setup, ... > I have an access database and I want to populate a combo box with the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Drag/Drop SQL Connection Fails
    ... I've been working on using "Server Explorer" to ease the creation of my ... The problem occurs when I drag/drop the connection into a new page, ... try to adjust the connection string in the Properties window of the ...
    (microsoft.public.vsnet.ide)
  • RE: Server Error in /Access Application
    ... IDE's server explorer, but didn't close the connection, then at runtime, ... Microsoft Online Support ... Server Error in '/Access' Application ...
    (microsoft.public.dotnet.framework.aspnet)