?
Solved

Problem installing Crystal Reports Server XI

Posted on 2005-04-07
10
Medium Priority
?
884 Views
Last Modified: 2008-01-09
We've just purchased Problem installing Crystal Reports Server XI but I wanted to get a jump on the project so I downloaded the trial version. I've tried installing it but get a bogus error message ...

I am installing Crystal Reports Server on the same machine as the SQL Server database. I log in as the account that owns all the SQL Server services. I am using Windows authentication only on this install. When I get to the installation step where I'm to enter the user who will create the database, I enter the name and password. In response, I get this error message ...


  Cannot get the server roles name - make sure the server is running and the authentication information is correct


I can guarantee that the user is defined and in the server admin role. I can log in as the user and create databases with no problem. What else could it be? If we can get an answer here I know at least two other people over on the Business Objects forums that will be deeply grateful!

David
0
Comment
Question by:David Little
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 13732594
Just because you can create a database doesn't make you an admin.  

Since you are using Windows authentication, are you logged in using a Windows name that has SQL Admin permissions?

mlmcc
0
 
LVL 2

Author Comment

by:David Little
ID: 13736664
Thanks mlmcc ... I know it's something simple so I'll go through my user set up ...


First, we're running Windows 2000 SBS with SQL Server 2000

The user I have is called "sqlserver". "sqlserver" is a member of the "administrators" AD group. This is the user I use to run all the SQL Server services.

Now to SQL Server..."sqlserver" is a Windows user and has been granted access. If I look at Server Roles, System Administrators is checked. No individual database is checked. I can log into SQL Server as "sqlserver" and if I run the follwoing script ...

    select CURRENT_USER;
    select user_name();

I get the following results ...

    dbo
    dbo

As a test, I also tried to install Crystal Server XI using my name and I KNOW I have SQL Admin permissions. I got the same error.

Please let me know if you see anything I've missed that I should be checking.

David
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 13741975
Don't know.  I don't have CR XI t try it with.

mlmcc
0
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

 
LVL 7

Expert Comment

by:ladylinet
ID: 13811084
 Hmmm...

 Check your Local Policy Editor (under Admin tools).
1) Allow log on locally?
2) Access this computer from the network?

 Anything in Event Viewer log?


Lady Linet
0
 
LVL 2

Author Comment

by:David Little
ID: 13817351
Nothing in the Event Viewer log and the user (actully I've tried it with multiple different users) is in the Administrator role and has both "log on locally" and "access from network".

David
0
 
LVL 7

Expert Comment

by:ladylinet
ID: 13826856
Check MSDN for Windows SBS, I remmeber seeing something permission problem there. I don't have a link sorry, because I don't have SBS at all, stumbled upon it accidentally.
 You don't have old Crystal installed on that machine by any chance? That can mess up things.

Lady Linet
0
 
LVL 2

Author Comment

by:David Little
ID: 13827923
We did have Crystal Reports and Crystal Enterprise installed on the server but I uninstalled them first (which caused us to be SOL for web reports for a while).

I was finally able to get it installed. Here are the steps I took ...

1) I logged in to the server as the user I want to use to run Crystal Reports Server
2) I opened SQL Server Enterprise Manager and created an empty database
3) I created a System DSN using a trusted connection and pointing to this new, empty db
4) I reran the install and this time did not select the "Use MSDE or existing SQL Server" box
5) When I got to the DSN question, I selected the new DSN I had just created

I've got no idea if this will work long term or is the right solution but it's the only way I could get it to install. Now on to configuration.

David
0
 
LVL 7

Expert Comment

by:ladylinet
ID: 13829618
Well, I'm glad that you've managed to install it.
 After you configure it, let us know how do you like it - I can open a question for that :) After all, it's newest, greates and untested version of CR ...

Lady Linet
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 13853251
PAQ'd, 500 points refunded.
CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month16 days, 20 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question