| Author |
 Topic  |
|
|
showry
Starting Member
2 Posts |
 Posted - 02/02/2006 : 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
USA
292 Posts |
Posted - 02/02/2006 : 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. |
 |
|
|
Leppy
Starting Member
Ireland
1 Posts |
Posted - 02/09/2006 : 07:16:19
|
| Did you have any luck with that Sean ? I'm having the same problem. |
Edited by - Leppy on 02/09/2006 07:17:45 |
|
|
|
afrika
Flowing Fount of Yak Knowledge
Nigeria
2702 Posts |
|
|
showry
Starting Member
2 Posts |
Posted - 02/12/2006 : 15:36:27
|
| Thanks for the help, it turned out to be an ODBC problem. |
|
|
|
afrika
Flowing Fount of Yak Knowledge
Nigeria
2702 Posts |
|
| |
Topic |
|
Connecting with Crystal Reports
