SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connecting with Crystal Reports
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

showry
Starting Member

2 Posts

Posted - 02/02/2006 :  06:01:49  Show Profile  Reply with Quote
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

USA
292 Posts

Posted - 02/02/2006 :  13:10:38  Show Profile  Reply with Quote
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

Ireland
1 Posts

Posted - 02/09/2006 :  07:16:19  Show Profile  Reply with Quote
Did you have any luck with that Sean ? I'm having the same problem.

Edited by - Leppy on 02/09/2006 07:17:45
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 02/09/2006 :  07:56:32  Show Profile  Reply with Quote
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 - 02/12/2006 :  15:36:27  Show Profile  Reply with Quote
Thanks for the help, it turned out to be an ODBC problem.
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 02/12/2006 :  15:45:39  Show Profile  Reply with Quote
OK,
take note of www.connectionstrings.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000