Problem installing Crystal Reports Server XI
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
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
ASKER
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
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
Don't know. I don't have CR XI t try it with.
mlmcc
mlmcc
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
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
ASKER
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
David
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
You don't have old Crystal installed on that machine by any chance? That can mess up things.
Lady Linet
ASKER
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
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Since you are using Windows authentication, are you logged in using a Windows name that has SQL Admin permissions?
mlmcc