Print Page | Close Window

how to connect crystal report 8.5 ,sql server 2005

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=979
Printed Date: 20 Apr 2024 at 4:15am


Topic: how to connect crystal report 8.5 ,sql server 2005
Posted By: swapnil
Subject: how to connect crystal report 8.5 ,sql server 2005
Date Posted: 09 Jul 2007 at 3:16am

HI

I m facing problem dat is how to connect crystal report 8.5 n sql server 2005?
every time it gives me LOGON FAILED error or server not exists...
even i wrote server name in d codin...
so please tell me how to over come from dis problem...
send some sample code if possible...
if u will get some solution ... u can mail me on my id...
my ID is :sam_swain7@yahoo.com
 
reply soon....
 
swapnil...
 


Replies:
Posted By: hilfy
Date Posted: 09 Jul 2007 at 11:48am
Are you having this problem on the computer where Crystal is installed or on a computer where an application is running your report?  What type of a connection are you trying to set up?  ODBC? SQL Server Native?  Is the SQL Server client software installed on the computer where you're working?  If you're using ODBC, is the ODBC connection set up correctly?
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: swapnil
Date Posted: 21 Jul 2007 at 9:29am
hi .... thanx for ur reply....
when m going to connect my database with ODBC, it asks me username and password of sql server 2005... but i dont wat is username and password....
As in sqlserver 2003, ther is username and password like 'sa' and ' ' respectively... but i dont the uname and password for this version sqlserver 2005.... if i m connecting my database with OLE DB, again dis problem arises.... so tell me wat wil be the best method to connect my database with crystal report 8.5.... my sqlserver is properly installed on my PC...

plz give solution...
bye.....

Posted By: hilfy
Date Posted: 23 Jul 2007 at 7:27am
You'll have to find out the user name and password for this version of SQL Server - you cannot connect without it.  And it may be that someone changed the password for the sa user ID after it was installed - which is what should be done for security reasons.  If you're using odbc, you can set up the connection to include the user ID and password and at that point Crystal shouldn't ask you for it.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window