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

On 4 Feb 2006 07:22:41 -0800, "thebison"
<alex.sinclair3@xxxxxxxxxxxxxx> wrote:

[snip]
Exception Details: System.Data.SqlClient.SqlException: Cannot open
database requested in login 'SCMS'. Login fails. Login failed for
user 'AL-NOTEPAD\ASPNET'.

To me this is an error with my connection string. My database
instance is actually 'AL-NOTEPAD\VSDOTNET'. However the properties
for sqlConnection1 are pointing to the correct datasource. I do not
know why the application is looking for user 'AL-NOTEPAD\ASPNET'. It
does not exist, to my knowledge.

Check your web folder's user permissions in IIS. It looks to me as
though you have your web site anonymous user set to ASPNET and you
haven't given that user permissions on your database.

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com
.

Relevant Pages

  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: No db access after publishing web site
    ... Cannot open database "pago" requested by the login. ... When you run any app using the Visual Studio Development Server, ... a different account...and you're using integrated security in your connection string. ...
    (microsoft.public.dotnet.framework.aspnet)