Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: cant connect to sql server 2008 Post Reply Post New Topic
Author Message
elbrenantonio
Newbie
Newbie
Avatar

Joined: 03 Nov 2009
Location: Philippines
Online Status: Offline
Posts: 1
Quote elbrenantonio Replybullet Topic: cant connect to sql server 2008
    Posted: 03 Nov 2009 at 5:33pm
i cant connect to sql server 2008 datbases using crystal report v10 or cr XI, what is the right authentication for this, using the OLE DB (ADO)
 
sql 7 is okey using this authentication:
 
     server: <computer name>
     User ID : sa
     Password: none
     Database: OK.. i've seen a database
 
but in sql server 2008 authentication i have problem:
 
     server: <computer name>
     User ID : none ------------------- what put in here?
     Password: none ------------------- what put in here?
     Database: No database...
 
what shoudl i for this. in sql 7 works fine.
 
please help
     
    
        
I might be wrong... but never in doubt...
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 04 Nov 2009 at 6:27am
using the sql 7 example you would put a user of the database and the password.  In sql7 you were using the sa and the password for sa.  I would speak with your DBA or whoever set up the SQL 2008 and see what a valid user/password is.
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.031 seconds.