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

• Jan-155192

  SSCrazy

  Points: 2613

  More actions

  October 4, 2005 at 3:31 am

  #95364

  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

• Martin Mojzisek

  SSCrazy

  Points: 2207

  More actions

  October 4, 2005 at 11:09 am

  #594928

  Try using osql instead of isql because isql shouldn´t be able to connect to a named instance unless you create an alias.