Login failed for user ''xxx''. Reason: Not associated with a trusted SQL

  • I have a strange problem with isql:

    isql -E -S Aristarchus\OVOPS -d ServiceDeskDB -i "Changes 3 - Create Function.sql"

    returns

    Msg 18452, Level 14, State 1:

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

    I would expect this error when we would try to connect with a SQL account, and only Windows authentication is enabled. However, we are in mixed mode: Windows & SQL authentication.

    The account used is a windows account with login rights on the server and db_owner rights on the database ServiceDeskDB.

    The network libraries on the client side are compeltely default: first TCP/IP, then Named Pipes.

    Shared memory protocol is enabled.

    I ran out of ideas. Can somebody help?

    Many thanks,

    Jan

     

     

  • Let's start with a few questions ... Is the SQL Server a member of a domain ? Is the computer you are currently logged into when executing the command a member (and loggde in to) the same domain as the SQL Server ? Is your Windows domain\username account authorized on the SQL Server that you are attempting to connect to ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • i have had a similar error msg before.the problem was that i was trying to use windows logon credentials on an sql server in another domain.my machine is in a workgroup.when i used the sql credentials i logged on fine.


    Everything you can imagine is real.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply