Who's On?

	Membership:
	Latest: sakkatan
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5212

	People Online:
	Visitors: 70
	Members: 0
	Total: 70

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Login to LBI Using Domain Account

1 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

Layne

Basic Member

Posts: 24

New Poster

4/11/2012 6:46 PM

We are using a domain account called LBICrystalReports to attempt to login a LBI Crystal Report. Going into MY REPORTS and editing the Data Settings \ Default User ID, we add the account using the following format for the Default User ID: GCSD\lbicrystalreports. GCSD is our domain. It will not work and the SQL log error shows that the report is attemping to login using SQL Server Authentificaiton even though the account is a domain account. The permission in SQL Server is sufficient for this account and it's setup to use Windows Authentification. Any ideas?

Matthew Nye

Veteran Member

Posts: 514

4/11/2012 7:19 PM

Layne,

I dont have the syntax off hand but youre going to have to create an override data source first and then add a value in "Additional Connection Attributes" to indicate that the connection is using a trusted source, i believe. something along the lines of Integrated Security=SSPI. Of coarse this is all assuming an OLE DB connection to SQL Server. Difference versions of SQL Server may require different attributes. this should get you started in the right direction.

if you dont mind, please post back your successful results.

hth
Matt