Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connecting with Crystal Reports

Author  Topic 

showry
Starting Member

2 Posts

Posted - 2006-02-02 : 06:01:49
Hi,
I'm very new to SQL Server, I'm coming from an Oracle background.
I've set up a server with windows authentication but I'm having no luck connectiong to it with Crystal Reports XI.
Can anybody go through the basics with me?
Regards
Sean

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-02-02 : 13:10:38
We probably need some more details. It's difficult to tell where you're having the issue...

1. SQL Server. You need to make sure your Windows login has appropriate rights (server, DB, tables, views, procs, etc...). From EM, expand the server...Security...Logins. Double click check your Database access and role. Can you connect and run queries with Query Analyzer?

2. What are you using for your connection in Crystal? If you're using ODBC, you can test that connection as you set it up to verify it works.
Go to Top of Page

Leppy
Starting Member

1 Post

Posted - 2006-02-09 : 07:16:19
Did you have any luck with that Sean ? I'm having the same problem.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-09 : 07:56:32
Welcome to SQLTeam,

windows authentication ? You should be able to log in if you dont change your windows password.

crystal reporst, i have some resources here. See if they would help


Microsoft and Crystal Deployment Docs
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crconcrystalreportsdeploymentoverview.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crconlicensingforcrystalreports.asp
http://support.businessobjects.com/communityCS/TechnicalPapers/crnet_deployment.pdf.asp

General Crystal .NET Forum
http://support.businessobjects.com/forums/content.asp?fid=251&sk=5&

Forum posts with specific questions:
http://support.businessobjects.com/forums/message.asp?fid=251&mid=52179
http://support.businessobjects.com/forums/message.asp?fid=251&mid=127537
http://support.businessobjects.com/forums/message.asp?fid=251&mid=140062
http://support.businessobjects.com/forums/message.asp?fid=251&mid=144477
http://support.businessobjects.com/forums/message.asp?fid=251&mid=148637

More articles:
http://www.edthosting.com/Knowledgebase_Article.aspx?id=122
http://www.dotnetjunkies.com/WebLog/bonggoy/archive/2005/12/08/134211.aspx
http://www.dotnetspider.com/Question2171.aspx
Go to Top of Page

showry
Starting Member

2 Posts

Posted - 2006-02-12 : 15:36:27
Thanks for the help, it turned out to be an ODBC problem.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-02-12 : 15:45:39
OK,
take note of www.connectionstrings.com
Go to Top of Page

charlesbecon
Starting Member

3 Posts

Posted - 2014-05-27 : 03:39:04
check this crystal report tutorial....[url]http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-tutorial.htm[/url]

Charles

Go to Top of Page
   

- Advertisement -