Print Page | Close Window

SQL Server Integrated Security

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2716
Printed Date: 30 Apr 2024 at 2:22pm


Topic: SQL Server Integrated Security
Posted By: mpalecek
Subject: SQL Server Integrated Security
Date Posted: 26 Mar 2008 at 7:41am
I wrote my first report against a SQL Server 2005 data source using integrated security. When I run the report on the computer that I used to create the report it runs fine. If I open the report on another computer (logged in as the same user or another user that should have access) the report asks for username and password (and has a checkbox for integrated security).
 
No username/password combination work and checking use integrated security does not work either.
 
The other thing I noticed about the logon dialog is that the database field is blank but it is not enabled so I cannot enter anything in there. The server field is correct (and not enabled).


Replies:
Posted By: Iago
Date Posted: 15 Apr 2008 at 11:43am
If you are using ODBC I think the seeting in the DSN will override
 
or
Check  Set Datasource Location
Properties
Integrated Security

Posted By: mpalecek
Date Posted: 16 Apr 2008 at 5:15am
I am using an SQL Native connection, no ODBC. I have looked at the settings in Set Datasource Location and it is already set to Integrated Security.
 
I was trying to avoid using ODBC, if I do that I have to install the ODBC entry on every user's machine.

Posted By: Iago
Date Posted: 16 Apr 2008 at 6:10am
This might help
 
http://msdn2.microsoft.com/en-us/library/ms131334.aspx - http://msdn2.microsoft.com/en-us/library/ms131334.aspx
 
It does not sound like this is an issue with a Windows AD account.  Is the problem directly related to certain PCs.

Posted By: mpalecek
Date Posted: 22 Apr 2008 at 7:54am
Thank you, that was it!


Print Page | Close Window