Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: SQL Server Integrated Security Post Reply Post New Topic
Author Message
mpalecek
Newbie
Newbie
Avatar

Joined: 28 Feb 2008
Location: United States
Online Status: Offline
Posts: 9
Quote mpalecek Replybullet Topic: SQL Server Integrated Security
    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).
IP IP Logged
Iago
Groupie
Groupie
Avatar

Joined: 01 Oct 2007
Location: United States
Online Status: Offline
Posts: 52
Quote Iago Replybullet 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
IP IP Logged
mpalecek
Newbie
Newbie
Avatar

Joined: 28 Feb 2008
Location: United States
Online Status: Offline
Posts: 9
Quote mpalecek Replybullet 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.
IP IP Logged
Iago
Groupie
Groupie
Avatar

Joined: 01 Oct 2007
Location: United States
Online Status: Offline
Posts: 52
Quote Iago Replybullet Posted: 16 Apr 2008 at 6:10am
This might help
 
 
It does not sound like this is an issue with a Windows AD account.  Is the problem directly related to certain PCs.
IP IP Logged
mpalecek
Newbie
Newbie
Avatar

Joined: 28 Feb 2008
Location: United States
Online Status: Offline
Posts: 9
Quote mpalecek Replybullet Posted: 22 Apr 2008 at 7:54am
Thank you, that was it!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.