Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2005/2008 : Data Connectivity
Message Icon Topic: how to connect crystal report 8.5 ,sql server 2005 Post Reply Post New Topic
Author Message
swapnil
Newbie
Newbie
Avatar

Joined: 08 Jul 2007
Location: India
Online Status: Offline
Posts: 2
Quote swapnil Replybullet Topic: how to connect crystal report 8.5 ,sql server 2005
    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...
 


Edited by swapnil - 09 Jul 2007 at 3:20am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3320
Quote hilfy Replybullet 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
DecisionFirst Technologies
7-Time SAP BusinessObjects Service Partner of the Year.
www.decisionfirst.com
IP IP Logged
swapnil
Newbie
Newbie
Avatar

Joined: 08 Jul 2007
Location: India
Online Status: Offline
Posts: 2
Quote swapnil Replybullet 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.....

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3320
Quote hilfy Replybullet 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
DecisionFirst Technologies
7-Time SAP BusinessObjects Service Partner of the Year.
www.decisionfirst.com
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.078 seconds.

FREE ADVANCED
Crystal Reports Training!

Plus, free bonus PDF cheat sheet! Advanced Crystal Reports Training Give Me Advanced Training!