SQL Exception

U

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!
 
U

Ulysses

Thanks for the follow-up.

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

William Ryan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server connection string for deployment ? 1
ADO DB Connection (SQL Server) via ASP.Net web app - help!!!! 2
An error has occurred while establishing a connection to the server.When connecting to SQL Server 20 0
Login fails for SQL Server 8
SQL Server connection issue 4
Connection Exception 4
Login failed for user ''. The user is not associated with a trusted SQL Server connection. 14
Connection to SQL Server 3

Top