VS.net, IIS 5.1, SQL server

VS.net, IIS 5.1, SQL server

Post by VG9tIEM » Fri, 16 Apr 2004 11:26:10



I'm trying to build a website that Access's a database

I'm using VisualBasic.net, the Website is hosted on IIS 5.1 from windows XP and the Database is on
SQL server

I've followed a walk thru that I got in the help files. Essentially it uses an OLEDBDataAdapter, a Dataset, and a Datagrid.
It builds without any arrors but when I run the program or load it from Internet Explorer I get an error message that say'
access denied. The problem seems to be with the line of code "OLEDBDataAdapter1.Fill(dsAuthors1)

I've tried everything I can think of but I can't get it to wor
When I run a basically identical Windows Application (rather than a web app) it works.
I've tried using various types of database

I think the problem is with some sort of security settings either in the Internet Information Server, or the SQL Serve
but I can't find anything in the documentation

Any help would be greatly appreciated
 
 
 

VS.net, IIS 5.1, SQL server

Post by Val Mazu » Fri, 16 Apr 2004 12:24:21

Hi,

I think you did not grant access to the SQL Server for ASPNET account. By
default ASPNET account cannot access SQL Server database. Check next KB
about how to do this

http://www.yqcomputer.com/ ;en-us;815154&Product=aspnet

--
Val Mazur
Microsoft MVP

 
 
 

VS.net, IIS 5.1, SQL server

Post by VG9tIEM » Sat, 24 Apr 2004 02:06:01

Thanks Val

That was the problem, but now I have essentially the same problem when I try to access
MS Access Database. How do I set MS Access to give permission for IIS to get into it

Thanks agai

Tom
 
 
 

VS.net, IIS 5.1, SQL server

Post by Val Mazu » Sun, 25 Apr 2004 11:29:01

Hi Tom,

Check next resources

http://www.yqcomputer.com/ ;en-us;307901&Product=aspnet

--
Val Mazur
Microsoft MVP