SBS 2003 R2 plus W2K3 terminal server running SQL 2000

Hi Experts,
I have a customer with a small network.
He has a SBS 2K3 R2 PDC and a Windows 2003 member server configured as a Terminal Server. Terminal server is running a SQL Server 2000 to.
There are some mobile users who need to run an application based in SQL. We have configured SBS and TS to run terminal on the member server.
Users can login perfectly to the TS but cannot run the SQL application. They receive an error window with the next message:
Component Crystl32.ocx or one of its dependencies not correctly registered: A file is missing or invalid.
To diagnose we tried to run the application from SBS server. To our surprise it runs OK.
Please I need some help to diagnose the problem.
macastriAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew DavisManagerCommented:
the application that uses the sql, sounds like it wasnt installed on the terminal server in "install mode" this is a must for terminal server otherwise there will be problems. i would re-install it through add-remove programs. when you do this click install app from floppy disk then browse the install location. you will notice at one of the stage just prior to the install launching there will be a window that says to not close this window till the install is complete, this allows the terminal server to install the appas it needs to for all users. generally i install then start the app and chek/customize then click the end of install.

or you could just try copying the ocx and then registering it. (google "register ocx")
0
macastriAuthor Commented:
Thanks very much for you answer Andrew.
Programmer said to me that it is not necessary to install Crystal.
That may be true because when I run the application us a domain administrator member of TS it runs perfectly.
0
macastriAuthor Commented:
After reading on the web a lot of similar problems, the solution is to install application with server in install mode.
How to do that:
1- Open a command window.
2- Type "change logon /disable" (without the quotes).
3- Type "change user /install".
4- Install Application using Control Panel. When I say to use Control Panel, you must use it and take care  not to use another method.
5- When installation is finished, type "change user /execute".
That is all.    
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.