All tables are invalid objects

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

From: "Fox" <fox @ connexions .net>
Date: Tue, 18 Feb 2003 01:29:28 -0500

One of my database projects was not working after changing over to
Server Config, Windows Authentication. I changed back to SQL Authentication
temporarily to make sure that was all that was wrong.
I then switched back to Windows Authentication and now all my statements
to open recordsets are claiming that the TableName is an invalid object.
What could I have done to lose access to the tables ? Does this
sound related or did I maybe cause this some other way while
fiddling around ?

Thanks,
Fox

Relevant Pages

  • Re: Problems connecting to SQL server on W2K3 from Win 2000 workst
    ... Can you connect to a network share on the SQL server? ... Also I know this isn't as important on 2k machines but is the primary DNS ... >> This is because you are using Windows authentication without a domain ... >> because it tends not to work, use SQL Authentication and you'll always ...
    (microsoft.public.sqlserver.connect)
  • Re: Login error when opening a deployed project
    ... You should use SQL Authentication instead of Windows Authentication. ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand ... command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.security)
  • Re: SQL Login vs NT Login
    ... the index every night with my maintenance plan and my user tell me that the ... I reinstall the old version of my application with the SQL Authentication ... that I have on my company to use Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • SQL Login vs NT Login
    ... Last week I modify my application that connect to a SQL Server 7 to use ... For exemple, for the same batch of record, with the SQL Authentication, it ... takes 15 second but with the Windows Authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: trouble changing SA password on SQL Server 2005 Express
    ... I'd quickly switch to SQL Authentication, try logging in as SA with what you ... instance of SQL 2005 Express running in Windows Authentication mode. ... it throughs an error saying that I do not ...
    (microsoft.public.sqlserver.security)