Click here to Skip to main content
15,942,710 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I want to connect to sql server 2005. so i tried the OLEDB Provider for SQL server, then i am prompt to enter the server name, user id, pwd, database,etc.
After entering, i select Finish but an error msg pop up, Login failed for user my username. The user is not associated with a trusted SQL Server connection. Can anyone advise me on how to resolve this problem?????
Posted

Read this: The user is not associated with a trusted SQL Server connection[^] and switch on Windows Authentication mode.
 
Share this answer
 
Change the Authentication Mode of the SQL server from
"Windows Authentication Mode (Windows Authentication)" to
"Mixed Mode (Windows Authentication and SQL Server Authentication)".
 
Share this answer
 
 
Share this answer
 
v2
Hi Ryan, digital man, dheeraj4u

I did what you said. Connection is established. Thanks

But now a new problem arise. When i install my software on client PC and try to access the report. There it ask for password and even after giving it. error msg comes "login failed"

Now what to do with this situtation.

If required i can give you code...

Thanks
 
Share this answer
 
Comments
Ryan Zahra 27-Jan-11 6:45am    
Does the user exist in the client's database?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900