Link to home
Start Free TrialLog in
Avatar of HeavyBlade
HeavyBladeFlag for Canada

asked on

How to resolve Crystal Reports Server Business View Manager Wrong Connection Error?

I'm part of the IT Department at Norseman Inc.  We just installed the trial version of Crystal Reports Server (XI), and have attempted to connect to it using Business View Manager.  Client and Server versions are the same.  When a connection is attempted, we get the following error:

Unable to connect to CMS 192.168.x.x.  A wrong connection is made to @@CVEDMHQ.CAMPERS-VILLAGE(CVEDMHQ.CAMPERS-VILLAGE). Logon cannot continue.

The end of the IP address has been masked, but is the same IP as CVEDMHQ.  CVEDMHQ refers to the server where the CR Server was set up.

Since we have just begun a research trial of this software, none of us have the experience with CR needed to solve this problem.

Prior to our testing, we had our buyer using CR Server to generate sales reports.  Since testing started, we have been unable to establish a connection, and as a trouble-shooting step, re-installed the trial.  In doing so, our buyer has lost his connection to CR Server, so now we're all in the dark.

Other members of my IT group seem to feel that it is an incorrect user name - as we were never prompted to create one when installing the product.

Any help resolving this issue would be greatly appreciated.

Thank you,
-Michael
Avatar of wykabryan
wykabryan
Flag of United States of America image

Have you created all the nesseccary things in the business view? What version of CR were you using prior to the test? Can you roll back and install the trial version on a different server?
Avatar of HeavyBlade

ASKER

Thanks for the quick response wykabryan.

Unfortunately, I don't know what we need to create for the business view.  I'm referring to the initial log-on prompt that comes up when you open Business View Manager.  But, if we still need things created, could you please tell me what we'd need to create in order to get things going?

We were using the same version of CR (XI) prior to the testing.

Unfortunately, CVEDMHQ is our primary server, so I'd like to resort to re-installation / roll-back as a last resort, if that seems reasonable to you. :)
Oh.. when you first click on business view manager it will prompt you for the following:
System: This would be the server name that the enterprise is installed on
User name:this would be a user that has rights to the CMC and business view creation
Password: the password for the user
Authentication: Depending on how the user was set up you will use one of them.
Oh ok... that makes sense.  

Does System have to be the server name, or can it be the server IP? If I provide the IP I get the same error as reported above, but otherwise I get a standard 'could not resolve host name' error.  This makes sense because the client and the server are on two different domains (not joined), so IP is our primary means of connection.

Trying a different user name (our admin account) and password did not resolve the problem unfortunately.  To make sure, I tried once for all four authentication types.

Just checked in with the rest of our team, the account used to set up CMC and business view creation was on the other domain.  If both the other account and our account are admin accounts, would both have rights to CMS and Business View Creation?

This is just my analysis of the problem and your response of course.  I could still be completely out to lunch. :)
Ok, just some more information on our findings...

We were able to install another instance of CR Server and ran it locally.  When we attempted sign in via this method and using the username of the account that was running during the install we were able to log in.  This strengthens my suspicion that the error has something to do with the different domains.

Hope this information helps.
You know what.. I didnt realize that you said they were on different domains.  Yes, that is the problem. Unless you tie the two servers together this will remain to be an issue. I am assuming there is a security reason for this set up but typically it is either clustered or on the same domain because it introduces to many different variables.
Here is a search of your issue on SAP website.

https://www.sdn.sap.com/irj/scn/advancedsearch?query=setting+BOE+on+multiple+domains&cat=sdn_all

If you look at the 4th article down, while it is not the same apps, it will outline what needs to happen to create a trust between the two server/domains.
Thanks again, I thought that might be the issue too.

Apparently the problem goes deeper, and I only found out today after straightening out some miscommunication with one of the other IT members.  Said member has been trying to log onto the server (using Business View Manager) on the Server itself, and can't log in successfully.

In other words, even on the server we can't log into the server.

Do you have any idea why this could  be? As far as I know, entering the server via VNC and trying to log in directly by-passes the domain problem, so it should work... but should and does are not the same thing...

I'll be experimenting with this myself until I hear back and will keep you informed of my progress. :)

Thanks again for all your help, wykabryan.
Well... just because you login to the server doesnt mean it created that trust in BOE. In the scope of computers a server is just another desktop on the network. If it exist on a different domain than the BVM wont be able to communicate with the CMC or the repository (depending on how you have it set up). As you pointed out earlier, when you install everything locally there is no issue.
Ok.  On the server, we are getting a standard "check logon information" error message for Enterprise and Windows NT Authentication.  The other two authentication methods return a plug-in not available message.

I've tried the CRS root account and the domain admin account and neither will log in.
Can you get to the CMS page and successfully login? Also because there is two servers can you install BVM on the other server and see if you can login?
Opps... the CMS is the service, the CMC is the Central Management Console.
Can you get to the CMC page and successfully login? Also because there is two servers can you install BVM on the other server and see if you can login?
Sorry, I don't think I communicated very well earlier.  What I meant to say is that as a testing measure, we are logging into the server via VNC.  From VNC we are then attempting to log into Business View Manager, so we are only on the one domain.

I apologize for any confusion.
From our testing earlier we were able to reach the CMC page, but we were unable to successfully log on to any of the links.  We should just be able to use any account with domain admin rights, correct?
ASKER CERTIFIED SOLUTION
Avatar of wykabryan
wykabryan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Actually, no, I lie.  I'm thinking of the AdminLaunch page.  Could you tell me how to reach the CMC page from here? I remember we were looking for it before, but didn't have much luck finding it.
On the AdminLaunch page, right in the middle it will say Central Management Console.
Yes.  But there's no hyperlink?
Weird.  We have the link for InfoView, but not for CMC.  That's why we didn't find it earlier...
That is the userlaunch page that you are looking at. The admin will have to main section in the center of tha page. CMC and Infoview.
Yes.  I see the area you're talking about and am logged in as admin.  But for some reason only Infoview has a link.  CMC does not.
can you show me that page. You can block out the url.  
Sorry for the delay.  Sure.  It's been attached.
LaunchPadPage.JPG
Update: We were able to VNC into the server and log into BVM with the following:

Server Name: CVEDMHQ
User Name: Administrator
Password: (no password)
Authentication: Enterprise

Still unable to log in from PCs outside the domain.

Thanks for all your help.  It was very kind of you. :)
Avatar of illusio
If I remember correctly you can't log in to a domain controller if you are in another domain. Regardless the privileges you set. If i also remember correctly then you can create a user on the domain controller that can log in and you create the same user in the other domain (same login, same name, same password). If you use that login the possibility exists that you will be able to log in after all.

Kind regards
Sorry for the late reply, but thanks illusio, I'll see if we can try that.  If nothing else we should be merging the two domains soon, so that will take care of the issue.  I take it that creating the same user on the domain controller and the other domain will 'link' the two accounts?
It will not exactly link the two domains, but it will fool windows a little. It doesn't work for all type of login's but it gets the job done in most occasions. Anyway, you *could* see it as a special type of link.

Another thing that can work is if you define a "trust" between the two domains... This will effectively enable the users of one domain to log on to the other domain. Of course you can still play with the security settings to grant or deny access for all type of "special" places.

Kind regards.