Login failed for user 'OHOSERVER\ASPNET'.

S

sureshcd10

Regular
Joined
Dec 25, 2003
Messages
77
:) 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
 
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 (<local machine name>\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)
 
Last edited:
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.
 
Back
Top