SQL server 2005 Connection Error: Cannot generate SSPI context

Question

Provide Used: Microsoft OLE DB Provider for SQL Server. Can anyone help me with this.. I was trying to connect with LLBLgen

Answer 1

In my case, I found the account was locked. Reason was I previously, on another machine more than 3 times tried to login. It did not recognise me - and tthen finally it locked my account.

Reopening account made all work fine.

br Jan

Answer 2

The error you get is almost always caused by a problem with using Windows Authentication. Please try switching to a SQL server login (username/password), or make sure your current Windows login has access to the SQL server and database you're trying to connect to.

-Edoode