Re: ADO.NET help - Filling a DataGrid with contents of a DataSet



hello thebison,

it seems to me that you are experiencing problem with the database
permissions you have on your sql server. This happens because ASPNET,
which is the default user account for your ASP.NET application, donot
have access permission to the database you are using.

If you have Enterprise Manager installed on your machine, you must
assign access permission to ASPNET account. Under Security folder,
Select New Login, browser for ASPNET account. Assign the database
VSDOTNET to ASPNET account.

b regards

rodel e. dagumampan
filipino c#/.net developer
http://community.devpinoy.org/blogs/dehranph

.



Relevant Pages

  • Re: attaching SQL Server 2005 Express database in ASP.NET web application
    ... attach databases requires admin permission. ... they access any database on the hard drive. ... > because the ASPNET account has limited permission by default. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.NET, Win2k, SQL 2k on an intranet (w/Kerberos?)
    ... Grant ASPNET account logon rights to SQL server and limit it ... >just to one database. ... >trough stored procedures and give ASPNET account just execute permission on ...
    (microsoft.public.inetserver.iis.security)
  • Re: ASP.NET, Win2k, SQL 2k on an intranet (w/Kerberos?)
    ... Grant ASPNET account logon rights to SQL server and limit it ... >just to one database. ... >trough stored procedures and give ASPNET account just execute permission on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: Help: Database Access Denied
    ... When ASP.NET is installed it create a user with least previliges ASPNET. ... web application runs in ASPNET user identity. ... permission to access the database. ... is to give access to database to this user ASPNET. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Is the login control with sql server express a known bug
    ... I added ASPNET into the admin group but it didn't solved my problem. ... TEST NUMBER 1 using the Northwind database running from VisualStudio ... Cannot open user default database. ... IIS and which account is running the ASP.NET. ...
    (microsoft.public.dotnet.framework.aspnet)