QUESTION POSED ON: 20 April 2005 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?
>
EXPERT RESPONSE
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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
