Click to See Complete Forum and Search --> : DataSource


skuehner
June 7th, 2006, 10:33 AM
Hello,

I'm using DataSource in my page (publishing with IIS). I can choose the database, enter a select command and try it (successfully).

When I publish the web site, the following error is shown:


Cannot open database "matcdb" requested by the login. The login failed.
Login failed for user 'DEVEL1\ASPNET'.


It seems that Microsoft has chosen the most complicated way to insert database connections... what do I have to do that the web page acts like my designer??

P.S.: I used Windows Authentication. The user ASPNET exists in my Windows System.

skuehner
June 8th, 2006, 04:12 PM
Solution:

Properties of user ASPNET -> Member of -> Add --> SQLServer[...]