Loading

Creating SQL Data Adapter, Access denied

fiae

Hi all, Im gonna build a Webform, with a Database Access, DataGrid on it. Placed the SQL Data Adapter and want to configure. And on the fourth Step at : Generate Select Statement SQL Server does not exist or access denied. SQL Server 2000 is installed, the Database is created and filled with Testdata.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

mohdali81comp22y ago
hi i can tell the you used the GUI (wizard) to create your adapter and connection. cause in general if you use GUI in ASP.NET it creates some kind of a bug anyway to over come this problem i REALLY SUGGEST YOU DO THE CONNECTION IN CODE this way its better another possiblity is to check the SQL Login user if he's autherized to log to the database. wish you luck