Creating SQL Data Adapter, Access denied
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
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