Michael Katz
asked on
SQL Auth and Integrated Security = True
Hi Experts,
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??
Thank you
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??
Thank you
ASKER
So the sql user and password are worthless that I entered?....Basically you are saying somewhere within SQL I am set up with Windows Auth???
Does that also mean that when a different user runs this report I created will fail if they are not set for Windows Auth?
Does that also mean that when a different user runs this report I created will fail if they are not set for Windows Auth?
SQL Server can be run in either a pure SQL Authorization mode or a mixed mode that allows for Windows NT/AD authorization.
When setup for Windows Authorization, anyone who can login into the domain will be able to run the report. Generally when this is done the Wndows NT/AD EVERYONE group is added to the EVERYONE SQL group and thus have logins. I don't think the users themselves have to be setup for Windows NT/AD authorization.
If you have users you don't want to give access to the database then you will have add the users individually to SQL.
mlmcc
When setup for Windows Authorization, anyone who can login into the domain will be able to run the report. Generally when this is done the Wndows NT/AD EVERYONE group is added to the EVERYONE SQL group and thus have logins. I don't think the users themselves have to be setup for Windows NT/AD authorization.
If you have users you don't want to give access to the database then you will have add the users individually to SQL.
mlmcc
ASKER
But i guess my questions remain, if I am using sql auth, and entered a sql user and sql password and clicked Integrated Security, and No Mixed Auth was created in SQL (implying that only SQL Auth is the only allowed method to connect), why would the reports run?? Is it suffice to say that security for the SQL Server database is beyond what I am aware of?? I did not physically set it up... It just doesnt make sense that I would need to click Integrated Security for these reports to run without a Prompt..
How are you running the reports?
mlmcc
mlmcc
ASKER
Opening up the file....refresh
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Opening it in designer...and then refreshing and double clicking on report..
Yes the report is to be used by others..
They will double click on it as well...the will not run from the designer...
Yes the report is to be used by others..
They will double click on it as well...the will not run from the designer...
Have you tried running it as a user would.
mlmcc
mlmcc
When you use integrated security, your windows credentials are passed to the database (assuming your database is set up to use Windows Authentication) and you do not need to manually enter database credentials.