Connection probs with SQL bloody server

[venerable bede]

I am developing a web page in asp.net

I have a webform which uses a connection to an sql server 2000 database residing on the local machine.

Whenever I try to connect to the database I get the error message :

Login failed for user 'DELL\ASPNET'.

I can view the database in Server Explorer and have succesfully tested the connection.

Does anyone have any ideas?
I know nothing about sql server, in access it was always easy.

[HAROLD HOFFMAN]

Hi

Did you set up a Login user in SQL Server 2000 for DELL\ASPNET and give it database access permissions?

Harold Hoffman

[venerable bede]

I know this sounds nuts but.......How do I do that?

[HAROLD HOFFMAN]

Hi

Right click Logins under Security in SQL Server Manager.

Click New Login.

Used the ellipsis button to find your Login DELL\ASPNET.

On Database Access Tab give perissions to the database and select the roles (read / write) in the bottom half of the screen.

Hope this helps.

Harold Hoffman

[venerable bede]

I did what you said but I now get the following:

SELECT permission denied on object 'tblCustomers', database 'dbCustomers', owner 'dbo'

[HAROLD HOFFMAN]

Try also adding public Permission in addition to read/ write database roles.

Harold Hoffman

[robdotnet00]

so is this sql bloody server the next version of sql server