Connection probs with SQL bloody server

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.

Hi

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

Harold Hoffman

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

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

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

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

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

Harold Hoffman

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