Problem with SQL Server authentication

microsoft.public.dotnet.framework.adonet

9 Oct 2006 2:56 PM

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

9 Oct 2006 3:23 PM

Norman Yuan

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.

Show quote

"Vayse" <vayse@deadspam.com> wrote in message
news:%23cRhNM76GHA.3644@TK2MSFTNGP03.phx.gbl...
> 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
>
>
>
>
>