Re: Can't access any old tables

From: Fox (@)
Date: 03/21/03

  • Next message: Kevin McDonnell [MS]: "RE: SQL Monitor Service port scans" 
    From: "Fox" <fox @ connexions .net>
Date: Fri, 21 Mar 2003 12:06:40 -0500

    I screwed up, its entry is there, just not where I was looking.
    There was another group of started databases higher in the log.

    Fox

    "Nikhil Mehrotra" <nikhil@rsd.4mis.com> wrote in message
    news:eelS$o47CHA.2984@TK2MSFTNGP11.phx.gbl...
    > check the owner of the tables and whether the users of windows
    > authentication have rights on the tables.
    > u need to check both.
    >
    > Regards
    > Nikhil
    >
    > "Fox" <fox @ connexions .net> wrote in message
    > news:#VTaMV17CHA.2984@TK2MSFTNGP11.phx.gbl...
    > > I was running a set of templates/application made by another company and
    > > they worked fine. This is on MS-SQL 2000 on Windows 2000 server
    > > without Active Directory (much less complicated). SQL Server was
    > > running in SQL/Windows Authentication. I decided to change to
    > > Windows Only. I have another project that I created while in Windows
    > > Only Authentication and it works fine. However, the previous
    > > database and tables do not work any longer. I changed the ODBC
    > > and I set up the Users and Roles exactly like the newer working project.
    > > To try to access the tables directly I created simple scripts, but I
    keep
    > > being told "Invalid Object Name" and it names the table.
    > > Doesn't matter which table I try to access I cannot. However
    > > I can import a table from my other project and access it without
    > > any problem. Is there some security that could have been set in
    > > SQL when the templates were installed. All the tables for that
    > > project were created by an installation program. There must be
    > > some setting somewhere that is stopping me from accessing
    > > these tables considering any new or imported table is easily
    > > and readily accessed.
    > >
    > > Does anyone have any idea what might be the problem ?
    > >
    > > Thanks,
    > > Fox
    > >
    > >
    >
    >

  • Next message: Kevin McDonnell [MS]: "RE: SQL Monitor Service port scans"

    Relevant Pages

    • Re: Cant access any old tables
      ... check the owner of the tables and whether the users of windows ... authentication have rights on the tables. ... SQL Server was ... > project were created by an installation program. ...
      (microsoft.public.sqlserver.security)
    • Re: Cant access any old tables
      ... I just noticed that the database we are talking about does not show ... > check the owner of the tables and whether the users of windows ... > authentication have rights on the tables. ... >> project were created by an installation program. ...
      (microsoft.public.sqlserver.security)
    • Quantcast