Q

Log in failed for user 'myservernameaspnet'

I am writing a program with VB.NET to access some data from my SQL 2000 Server but it always complains of log in failed for user "myservernameaspnet." What could be causing this error and do you have a solution?
It sounds like you might have a permissions issue with the ASPNET user on your development box. A simple way of checking is to grant "full control" permissions to the "ASPNET" user in the directory where your data resides. If this works, you know you have a permissions issue. Start rolling back the permissions until it breaks again -- you want to have the minimum amount of permissions necessary for the program to run properly. If this doesn't work, try re-installing ASP.NET.


Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on SQL Server Security

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close