Creating SQL Data Adapter Access denied

Question

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.

mohdali81comp · Answer

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

Creating SQL Data Adapter, Access denied