SQL Connection/Security problem

[John]

Hi

I am trying to connect to SQL on my local machine using;
myConnection = New OleDbConnection("Provider=sqloledb;Data
Source=MYSERVER;Initial Catalog=Events;User Id=MYSERVER\ASPNET;Password=;")

This gives me error; 'System.Data.OleDb.OleDbException: Login failed for
user 'MYSERVER\ASPNET'. The user is not associated with a trusted SQL Server
connection.

What is the problem and how can I fix it?

Thanks

Regards

 

[Peter Rilling]

Is the ASPNET account registered with SqlServer at both the server and
database levels?

 

[Mark Rae]

What is the problem and how can I fix it?

See Peter Rilling's reply, but why are you using OleDb instead of the native
..NET SQL Server data provider?

 

[John]

but why are you using OleDb instead of the native
.NET SQL Server data provider?

Because I am a rookie at asp.net 2.0.

 

[Richard Thayne]

Hello John,

I would suggest using the native .Net SQL Server data provider. Unless you
have a specific reason to use something else.

 

[John]

Thanks. I have now changed the code to;
myConnection = New SqlConnection("Data
Source=IV-SERVER-02;Database=Events;User
Id=eventsuser;Password=eventsuser;"). I am still getting the same error;
System.Data.SqlClient.SqlException: Login failed for user 'eventsuser'. The
user is not associated with a trusted SQL Server connection.

Any ideas?

Regards

 

[Marina]

Do these credentials work from query analyzer? It sounds like a problem with
the user not configured on the SQL Server end.

 

[Russ Farris]

What type of Authentication is set at the SQL Server level? My guess is
that you didn't specify Mixed Mode Authentication during install.

Try this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269587

 

[John]

I chose Windows authentication as far as I can remember.

Regards

 

[Mark Rae]

Because I am a rookie at asp.net 2.0.

The .NET SQL Server data provider has been around since v1.0