1
Answer

Creating SQL Data Adapter, Access denied

fiae

fiae

21y
2.2k
1
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.
Answers (1)
0
mohdali81comp

mohdali81comp

NA 56 0 20y
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
Next Recommended Forum