Problem with SQL Server authentication

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
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

webservice - dsn - sql server 1
SQL connection with custom authentication 9
SQL Server authentication 5
Using Widows Authentication and accesssing SQL with SQL Authentication 4
Deployable SQL Server authentication for ASP.NET 3
Connect SQL Server from Windows Forms - Windows Authentication Mod 2
Access 2007 Application for Reports Only – SQL Server Security 3
SQL Server authentication 3

Top