• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 761
  • Last Modified:

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
0
bnrtech
Asked:
bnrtech
1 Solution
 
Faiga DiegelCommented:
Are you using windows account or SQL login?
0
 
mlmccCommented:
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
 
bnrtechAuthor Commented:
helpful but also some issue within crystal install itself
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now