|
Motive Power® FAQ
Hardware and Operating System
What is the
recommended hardware for running Motive Power?
How do I find
out if my hardware is certified to run any given version of Windows?
I just upgraded to Windows XP SP2 and now my Motive Power stations will not connect to the server. What do I do?
I just upgraded to Windows
XP SP2 and now I can't connect to my Motive Power files from Word or Excel
or Crystal or other report writer. What do I do?
What is the
recommended hardware for running Motive Power?
Motive Power uses the
Microsoft SQL engine which is fairly hardware intensive. We recommend
Windows XP, Windows Server 2003, Windows Vista, Windows Server 2008, or
Windows 7, a dual core processor, at least 2GB of RAM and a fast hard drive with at least
4GB of free disk space for the server machine (the computer where your
database resides). For the workstation computers, we recommend Windows
XP, Windows Vista, or Windows 7, at least 1GB of RAM and 500 MB or 10%
free space on the hard drive. All hardware
should be on the Microsoft approved list for the version of Windows you
are running.
How do I
find out if my hardware is certified to run any given version of Windows?
Go to
www.microsoft.com/whdc/hcl/default.mspx to check your hardware. If you
have a brand name computer you can look under Systems to see what versions
of Windows have been tested on that machine. If you have a homemade or
locally built computer you need to look up each component separately.
I just upgraded to Windows XP SP2 and now my Motive Power stations will not connect to the server. What do I do?
XP Service Pack 2 tightens security in Windows. It does this by turning off ports and protocols via the firewall. You need to turn on the ports required by SQL server in order to access the Motive Power. Motive Power uses a named instance of SQL server. The name is MSSQL$CAI2. Follow this procedure to enable SQL access for other stations on your network. The commands have been excerpted from Microsoft documentation and edited to match Motive Power.
- Click Start, and then click Run.
- In the Run dialog box, type Firewall.cpl, and then click OK.
- In the Windows Firewall dialog box, click Add a Program on the Exceptions tab.
- In the Add Program dialog box, click the Browse button to locate the instance of SQL Server that you want to add to the exception list. The default installation location for the Motive Power instance of SQL Server is:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
- Select the
name of the instance, and then click OK.
- Under Programs and Services,
select the check box that is next to the name you selected in step 5, and
then click OK.
- Add another exception for
the SQL Browser service by browsing to C:\Program
Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe then click Open, and then click OK.
- Be sure that both of these new exceptions are limited to the local
network.
You can read the entire Microsoft article at
support.microsoft.com/default.aspx?kbid=841251
I just upgraded to Windows XP
SP2 and now I can't connect to my Motive Power files from Word or Excel or
Crystal or other report writer. What do I do?
By default, SP2 closes all ports. You have to open them explicitly. Motive
Power uses CAI2 (for Computer Assistance Inc.) as a "named instance" of SQL
server. You have to take action to allow other programs to look at the
Motive Power data. There are two exceptions that you may need to allow in
order for other programs so access this data.
Go to Control Panel | Security Center and click on Windows Firewall under
Manage Security Settings. If the firewall is OFF then this is not your
problem. If the firewall is ON, click on the Exceptions tab. Choose Add
Port. Give it a name like SQL UDP ACCESS. On the next line give it a port
number of 1434 and choose UDP as the type of port. Next click on Change
Scope and limit the access to My network only or set a custom address. Do
Not make this information available to the entire Internet. Okay the
change in scope. Try to see if your MS Office or report writer program
connects.
If this does not solve your problem you will need to open an additional
port. First you need to know the port number. Click on Start and then Run
and enter SVRNETCN.EXE If you have more than one SQL server program or
instance on this machine, use the drop down and make sure you are looking
at the correct data. Under Enabled protocols highlight TCP/IP and then
click on Properties and note down the default port number. Return to
Control Panel | Security Center and add another port. This time call it
SQL TCP Access and give it the same port number you noted down. Change
scope to limit access to My network or set a custom address.
|
