Re: Cant Connect



I am trying to set up my Access Data Access Page but it is telling
that "this account inst a trusted SQL account" or something along
those lines, but it does it for all, even my Administrator account,
what do i need to do so I can connect?

You may try to use SQL authentication, using a SQL Login, instead of a trusted authentication.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution


.



Relevant Pages

  • Re: Cant Connect
    ... I have tried this and nothing works I get the same error of "this account is ... I have tried administrator, sql, windows authenticated...all get the same ... My servers are virtual servers ... PBsoft di Gabriele Bertolucci ...
    (microsoft.public.sqlserver.connect)
  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ...
    (comp.databases.oracle.server)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.win32.programmer.wmi)