Please immediate help needed, msde fill problem in a form

filistor

Member
Joined
Jun 16, 2004
Messages
8
Programming Experience
3-5
Please help! i have to deliver an html page for my university, listing financial pages, so i thought i could create it with vb and sql Desktop. Even though i can create applications using Sql, when i try to make a webform(with the same database) and fill it with data i get the error :

Server Error in '/' Application.

Login failed for user 'PAUHLO-TEST\ASPNET'

however i can preview the data with the sqladapter. What is going wrong?Thanks in advance
 

levyuk

Well-known member
Joined
Jun 7, 2004
Messages
313
Location
Wales, UK
Programming Experience
3-5
It might be something to do with the web.config file used to authenticate users. I try not to use this because it annoys me and I don't know how they work.
 

Mykre

Active member
Joined
Jun 14, 2004
Messages
28
Location
Australia
Programming Experience
3-5
This is a permission problem on the database side, You will need to add the ASP user to the database and give it permissions.


When you install MSDE from the setup files, it installs the database to use trusted connections, which means that the user accessing the database must be an account on the local machine or on the domain. Then it must have permissions in the database to access the systems needed.

If you must use user names in the connection strings, you will need to convert the database to use mixed mode (Thereare articles on this all over the web, but I prefer the MSDN Article).

Or Reinstall the MSDE Application and edit the setup INI file as per the document that comes with the setup files, it tells you how to configure an SQL User and set it to Mixed Mode.

Mykre
 
Top Bottom