Can't connect to repository after password change

[Andreas_G]

We have our EA-Project on a mssql database. My database user is the same as the domain user. After I changed my domain password, I can't connect to the repository.

When I select the project on the start page it askes for a password. Doesn't matter which password I enter (the current passord or the previous), I get after three times an error like "Microsoft OLE DM Provider for SQL Server [-2147467259] Der SSPI Kontext kann nicht erstellt werden" (Can't create the SSPI context).

My second try, was to create a new connection string.
On the first page I select as db-provider "Microsoft OLE DB for SQL Server".
On the second page (step 1) I select my database, (step 2) use internal  security.
(step 3) when I try to slecet the database I get an error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server existiert nicht oder Zugriff verweigert." (Server did not exist or access denied).

I don't know if it's a problem of EA or a problem of the SQL-Server.

May be you have any ideas.

Best regards
Andreas

[thomaskilian]

I already had my fight with SQL server authentication. My conclusion so far is to NOT USE Windoof authentication but to  setup dedicated DB users. From my experience that works best. Normally I don't change my password very often, so that's probably the reason why I choose that solution. Anyway Windows authentication is BIG FAT SCRAP.