SQL Exception

[Ulysses]

Hello,
I'm learning .NET. Within my C# application I am
attempting to establish a connection to my
SQLServer 2000 database using the OleDbConnection
type of ADO.NET.

Both the database and application are running on the
same machine. The SQL Server is configured to perform
'Windows Only' authentication. However when I attempt
to connect as one of the Windows users I get the
following exception:

Exception: Login failed for user 'xyz'.
Reason: Not associated with a trusted SQL Server
connection.

I'd greatly appreciate your help.

Thanks!

 

[William Ryan]

Does XYZ have an account with permissions on the server?

 

[Ulysses]

Thanks for the follow-up.

Yes I do have XYZ as a registered user on the SQL Server.

 

[William Ryan]

Is your connection string specifiying SSPI= TRUE or are you poassing in XYZ
and the password?