Click here to Skip to main content
15,887,477 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
SQL
i recently create project in visual studio 2010 and use sqlserver 2005. after complete process of setup , i run setup, and first page is login page. now i fill usename,and passwod and click on login button.
and error arise.
login failed for user", the user is not associated with a
Posted
Comments
Krunal Rohit 2-Oct-15 5:22am    
with a.. ??

-KR
Member 11952997 2-Oct-15 6:03am    
Login failed for user", The user is not associated with a trusted SQL Server connection.

1 solution

This error most commonly occurs when using SQL authentication. There are a few reasons to use SQL authentication rather than Windows:

- Client is not running a domain
- Network contains PC’s running Windows98

To enable both authentication protocols:
1. Go to Enterprise Manager.
2. Right Click on Server Name
3. Select Properties
4. Go to Security Tab
5. Set authentication to SQL Server and Windows

Or try below links:
https://support.microsoft.com/en-us/kb/555332[^]
https://support.microsoft.com/en-us/kb/889615[^]

-KR
 
Share this answer
 
Comments
Member 11952997 2-Oct-15 7:51am    
thank you so much sir for your reply,
sir, I create windows application in visual studio 2010 with sql server 2005, with windows 7 64 bit.
sir i didn't get such answer for solve my problm.
pls help me sir.

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