we have an sql error when trying to create a new database in a sql server we have configured the server with the -p option we are trying to connect with sa user from a na 3.60 sql client when trying to connect, the sql server returns the error 18452,28000, that says we haven’t autorizing rights to connect anyone knows what’s happen??? it’s urgent!!!
Are you running a supported version of SQL Server? - Jens
This is a simple error: Login failed for user ‘xyz’. Reason: Not associated with a trusted SQL Server connection. You are trying to connect to SQL Server using windows authentication (i.e. of the user who has logged into windows), but a windows login has not been created on the server for that user. You must create a login in SQL Server using Enterprise Manager for each windows user that should access the server. Or Attain will do this if you add the windows users using Tools/Security/Windows Logins.
ok reply to your replies… sql server version is supported by attain, in fact they (my customer) were trying to make a mirror server in a separate server (another pc in the same lan). first of all, he install sql server 2000, configure the server options and create the NA users and their passwords, giving dbo rights to sa user and to a navision user (a super user), and public rights to the rest of navision users. later, i reinstall NA 3.60. from SQL Option for NA, restore a database backup, create the correct users and passwords, sincronize,… to desestimate a NA install error. finally, i close the database and try to reopen again to test it and the complete installation (sql and NA, this means, test if everything is ok). when prompt for user and password, i type a correct login and a correct password, so we may could enter to the database, but sql returns the especified error. after posting my messages in this forum, the system administrator on customer’s headquarters tells me that he made some modifications on installed sql server. checking modification, he made some several errors (better not to tell…) and i decide to uninstall sql, reboot the server and reinstall sql again. after reinstall sql, restore the database, and create the users, everything were ok. actually this system administrator is looking for another job… XDD anyway, zanx to all
Now I think I see what the problem was (for future reference): The Authentication security property of the server probably had “Windows Only” ticked. This disallows the use of SQL logins (i.e. those with passwords), giving your error. This settings is prompted for when you install a SQL Server and the default, if you do nothing, is windows only. I think your previous installation had this set. When you re-installed your server I think you asked for “SQL Server and windows” for this option, which has solved your problem. You can see this setting in Enterprise Manager. Right-click your server and choose properties. Choose the Security tab, and it is under the Authentication section.
Big, big thx!
Just saved my saturday afternoon!!
Just love old posts on NAV SQL!
And thx to google for finding this post 
holy cow 8 years later and still relevant [Y]