SQL Auth and Integrated Security = True
Posted on 2014-01-27
I have been writing Crystal Reports for awhile...
I never have bothered with Integrated Security when using SQL Auth reports.. Why is it that I had to check this box within Connections to prevent the prompts from appearing??
Doesn't integrated Security rely on NT Auth??
I have been beating the hell out of myself trying to figure out why prompts for my reports keep coming up.. I changed to Integrated Security.. Still using SQL UserID and Password (and no users are setup via NT auth in SQL) and now the reports work...
What is the relationship between Integrated Security , Crystal Reports and SQL / NT Auth??
What am I not understanding??