Problem with SQL Server authentication

  • Thread starter Thread starter Vayse
  • Start date Start date
V

Vayse

Hi
I added a new user to SQL Server, called Reporting1. I set it up to use SQL
Server authentication.
In VB2005, I want to Add a Data Source, and use the Reporting1 user.
I tick to Use SQL Server Authentication, but it doesn't work. The error I
get is:
Login failed for 'Reporting`'. Reason: Not associated with a Trusted SQL
Server Connection.

I'm not that familiar with SQL Server security, so please advise what I
should change.
Thanks
Vayse
 
Make sure the SQL Server/Express's mixed security mode is enabled. By
default, only Windows security is used. If you want to use SQL Server
authentication, you must explicitly enable the MIXED mode.
 
Back
Top