Crystal Reports OLE connection to SQL server.

I have a crystal report that has an OLE DB connection to a SQL Server Database that stopped working after a windows update. After the update I started to get an OLE provider for SQL Server error:

Logon Failed.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for SQL Server
Description: Cannot generate SSPI context
SQL State: HY00

Any help would be appreciated. Thanks
bnrtechAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You probably need to open the report and do one of two things

DATABASE --> VERIFY DATABASE

Update the data souce to use the new connection
DATABASE --> SET DATASOURCE LOCATION
Create a NEW CONNECTION

mlmcc
0
 
Faiga DiegelSr Database EngineerCommented:
Are you using windows account or SQL login?
0
 
bnrtechAuthor Commented:
helpful but also some issue within crystal install itself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.