SQL Server does not exist error

From: David N (anonymous_at_discussions.microsoft.com)
Date: 08/25/04


Date: Wed, 25 Aug 2004 09:49:57 -0700

I have a trial version of visual studio and downloaded the
sql desktop engine MSDE for studing web application
programing with .NET. When I try to create a DataAdapter
using the wizard or draging a table from Server Explorer,
I get "! generated SELECT statement, SQL server does not
exist or access denied." Everythin is on a W2K
professional and the MSDE was loaded with
DISABLENETWORKPROTOCALS 1 and a nonblank SAPWD.

If I click "retrieve data from table" , the table is
loaded, and even the wizard can access the table when
designing a query. So, I don't know what access is being
denied. I have tried setting web sharing and file sharing
to read and write on the directories where the database
files are, and added administrator group to security tab.
I have tried numerous variations of allowing anonymous
access and Windows Authentication on these directories. I
added all users including ASPNET and IUSR_ to the
administrator group. Obviously, I am not a DBA, but I am
not trying to be one. I just want to access the sample
databases so I can go back to developing applications.
I've read everything I can find about this in Microsoft
support and still no solution. Please help!