Solved

SQL Auth and Integrated Security = True

Posted on 2014-01-27
9
355 Views
Last Modified: 2014-02-11
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
0
Comment
Question by:Mikeyman_01
  • 4
  • 4
9 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 39814325
Crystal Reports doesn't save database credentials.  So, if you're using standard authentication, you'll be prompted for credentials every time you connect to the database within a session.

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.
0
 

Author Comment

by:Mikeyman_01
ID: 39814931
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?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39814991
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
0
 

Author Comment

by:Mikeyman_01
ID: 39815227
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..
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 39815235
How are you running the reports?

mlmcc
0
 

Author Comment

by:Mikeyman_01
ID: 39816303
Opening up the file....refresh
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39816337
OPening it in the designer?

If so, quite often the designer maintains the security so you only have to log into the database once.

Is this report to be used by others?
If so how will they run it?  They won't all; have the designer.

mlmcc
0
 

Author Comment

by:Mikeyman_01
ID: 39816536
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...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39817733
Have you tried running it as a user would.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now