J have read many answers about
Login failed for user '. The user is not associated with a trusted SQL server connection
error, but I don't want to mess up in my sql server so I want to be sure that what I do is OK.
In my company, we have our own application wchich we use to connect to database. All users use SQL Server Auth except me. I can log using Windows Auth from server and from my second computer.
Now everything works fine.
- My comp is in our domain 'OurDomian'.
- On server in AD is admin account 'SqlAdmin'.
- In MSSMS in Security->Logins there is account: OurDomian\SqlAdmin
- on my comp account OurDomian\SqlAdmin is added
I can log to sql server from my comp using 'Integrated Security' in application with no problem.
Problem starts when I change SqlAdmin password on server.
When I connect from my comp I get the above error. But when I connect from server there is no problem.
I searcher application code and I don't think that I have to change somthing in it. Probably I have to change something with account and permissions.
1. Will it bee enough to delete and add again 'OurDomian\SqlAdmi
View Complete Post