Login failed for user 'OHOSERVER\ASPNET'.

[sureshcd10]

:) Thank u for listening to me

 

I m new to ASP.NET ,Now my problem is as follows :

 

I tried to create one ASP.NET web application with Vb.NET

 

I used DataForm Wizard to connect to the SqlsERVER2000 DATABASE SERVER

mY sERVER NAME IS: OHOSERVER\VSDOTNET

 

In the DataLinkProperties I Specified Server Name as OHOSERVER\VSDOTNET

Then I specified information to log on to the server as- Use WindowsNT integrated security.

Then I selected my database name from the dropdown list

Then I clicked on the button labelled "Test Connection" and got the message "Test Connection Succeeded"

on clicking the finish button

A Button labelled "Load" is displayed on the DataWebform1.ASPx

I clicked Run button

and clicked on the Button labelled "Load"

and I am getting the following Error message

 

 

Login failed for user 'OHOSERVER\ASPNET'.

 

Why I was not able to display the contents of my table? :confused:

My OS is Windows2000 professional

 

 

Plz help me

[PlausiblyDamp]

If you are accessing SQL from an ASP.Net application the web app will access the DB as the user account the application itself runs as (\ASPNET. You will either need to grant this account permissions to the SQL server / database or investigate impersonation (search these forums and you will get some examples) Edited March 18, 2004 by PlausiblyDamp

[sureshcd10]

But how can I grant this account permissions to the SQL server / database .Which file ?I m using SQLServer2000 desktop engine.(I also searched the entire forum for

'imppersonation' but I got only my thread as result.) .Please specify clearly.

Thank u for your quick reply.

[PlausiblyDamp]

Whoops - my bad, bit of a typo (i'll fix it now)

http://www.xtremedotnettalk.com/showthread.php?t=73612&highlight=impersonation is probably a good link to start.

If you need to change permissions on a database either use Enterprise Manager to create a login / user for the DB or through Query Analyzer you can use a couple of stored procs (sp_grantlogin and sp_adduser)