Re: Cannot access table with windows authentication

From: Fox (@)
Date: 02/24/03 

From: "Fox" <fox @ connexions .net>
Date: Mon, 24 Feb 2003 16:45:48 -0500

Forget the last meszsage. I am realizing that there are some idiosyncrasies
regarding windows aythentication, that I was not understanding.
Firstly, it appears that one cannot login to pages on the web, via the login
name
of the DBO. I created another account with the same rights and I secured
the windows directory itself. I changed the login DSN on the fitst page to
match that account. This worked fine. But what surprised me is that the
results pages still had the login to the dbo account, yet under this
circumstance worked. Can anyone give some of the basic logistics regarding
windows authentications theory and logistics (idiosyncrasies)?

Such as why can I not login using the DBO user login ? Yet once logged in
under a different account it seems this is ignored for sake of the rights of
the origunal login for the session.

I still cannot get the IUSR_MachineName to work. It did work before I
switched to Windows authentication,

Regards,
Fox

"Fox" <fox @ connexions .net> wrote in message
news:uWt9xGD3CHA.1156@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I am using Windows authentication via a system DSN. Everything worked
> fine until I changed the DBO. I changed this because it was originally
> an SQL login which was my name and I also had a windows login
> that was my name. I dumped the SQL login and changed it to my
> window login by detaching and reattching the database. Now I can no
> longer access the tables over the Web. All previous acccess to
> IUSR_MachineName and for myself, has halted on this same error
> message which tells me that I am trying to access an invalid object.
> But this is the table name. So it appears
> I am getting logged into the database but cannot access any tables.
> Can anyone help me how to get my full access back. I am
> associated with the System Admin in the Server Group
> security tab and I am the DBO of the database. This is so weird
> cause after months and so much help from the people here, I had
> completely finished my project. And now I cannot log into it anymore.
> How ironic.
>
> Regards,
> Fox
>
>

Relevant Pages

  • Re: How do I set the login name for a user?
    ... You are better to make a dbo roled account (database god?), although that is not my first recommendation for connections. ... name, key name, without login. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Client tools access to SS remote nstance - 2 diff. Win Server domain accounts ?
    ... Well, when I need to run at higher rights, I right click on the SSMS icon and choose Run As ... That gives me a dialog to enter my administrator account and password. ... login with my normal domain user account. ... SS that I use to login in that RDP session (Windows login) to then ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows equiv of UNIX "Restricted Users"??
    ... the Network and Users still in the local login rights on numerous ... defining a domain account does grant broad access. ... the "Everyone" permissions in Windows, will be limited to have access ONLY ...
    (microsoft.public.windows.server.security)
  • Re: Task Scheduler
    ... I do not have on my login as I want the computer to startup after a power ... security (and a bit more than prior NT-based versions of Windows). ... Scheduled tasks do NOT require you to be logged in (it is an option that ... logged in or not because you told them under what account to run. ...
    (microsoft.public.windowsxp.newusers)
  • Re: If my computer is a single PC with ADSL connection, can I leave the password blank when I login
    ... I leave the password of user blank when I login the Windows XP? ... If you really want to be safer, add a router to sit between you and the ... built-in Administrator account and also to your own user account. ...
    (microsoft.public.security)