Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server Server Connection.

From: Grant Reid (grant.reid_at_telefonica(dot)net)
Date: 05/24/04 

Date: Mon, 24 May 2004 17:11:23 +0200

Hello,

I am trying to create an OLE DB connection to MS-SQLSERVER 2000.
I have set the security settings inside Enterprise Manager to allow logins
for both SQL Server and Windows.
Does anybody have any ideas as to what is causing this error?

Regards
Grant Reid

Relevant Pages

  • Re: Error connecting
    ... "Sue Hoegemeier" wrote:> LLF, ... Enterprise> Manager is really just executing T-SQL commands for you so> you can manage these through Query Analyzer or any other> tool that can connect to and execute queries on SQL Server. ... > You can add logins using sp_grantlogin for Windows logins or> sp_addlogin for SQL logins. ... >>Is it can only be done by using 'Enterprise Manager'? ...
    (microsoft.public.sqlserver.connect)
  • Re: Error connecting
    ... You can use Enterprise Manager if you wish. ... Manager is really just executing T-SQL commands for you so ... tool that can connect to and execute queries on SQL Server. ... You can add logins using sp_grantlogin for Windows logins or ...
    (microsoft.public.sqlserver.connect)
  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)