sql 2005

Login failed for user 'arjayadmin'. The user is not associated with a trusted SQL Server connection.
romeiovasuAsked:
Who is Participating?
 
ursangelCommented:
As angel said, its cos the server is configured to accept the windows authentictaion.
change it by the following way

Open The SQL Server Enterprise Manager
Start menu > Programs > Microsoft SQL Server > Enterprise Manager)
Expand the tree-control until you can your server
Right click on the server name and "SQL Server Properties (Configure)" window will open
Select the Security tab
For "Authentication", select "SQL Server and Windows"
Click "OK" to close the window and then "Yes" to restart SQL Server

Regards
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this means that the sql server is configured to only accept windows logins.
change that configuration to mixed authentication if you want to allow non-windows accounts to be able to login.

0
 
romeiovasuAuthor Commented:
Login failed for user 'testuser'
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
answer_meCommented:
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
romeiovasuAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.