1. Check network connection
Make sure you have network connection between workstation and server. Run command line on workstation and type ‘ping xxx.xxx.xxx.xxx’, where xxx.xxx.xxx.xxx – IP address of server. If you have connection you should receive reply packages from server.
Otherwise contact you system administrator to set up network connection.
2. Check ODBC (ODBC for x64 bit operating system)
If you are using 32-bit operating system then run ODBC Administrator from control panel:
“Control panel” -> “Administrative tools” -> “Data source (ODBC)”.
If you are using 64-bit operating system then run ODBC Administrator from Windows installation folder:
%SystemRoot%\SysWOW64\odbcad32.exe, where %SystemRoot% is the windows installation folder, generally it is “C:\Windows”.
On the ODBC Administrator window switch to the “System DNS” tab. You will see four data sources: “MillArchiveModel”, ‘MillCfg’, “MillHist”, “MillWin”. For each of them perform next operations:
Select data source and press “Configure” button.
On first screen in field “Server” enter full name of SQL Server instance. For example: “%ComputerName%\SQLExpress”. If you installed SQL Server from Millenium installation CD then just type the name of the server.
Make sure that workstation user can connect to SQL Server using windows authentication. Otherwise you can setup connection using SQL Server authentication. In this case you will need to enter Login ID and Password in ODBC driver configuration. This login should have access to SQL Server.
Click “Next” on next screens until “Finish” button appears.
Click “Finish”. On new screen click “Test Data Source…”. If message “TESTS COMPLETED SUCCESSFULLY!” appears then data source configured correctly.
Repeat this procedure for all four data sources.
3. If SQL authentication is used, enter password using rfsetpswd.exe
If you are using SQL Server authentication then you will need to add password to MPW.rf file. Go to server. From folder C:\MPW\Scripts (replace C:\MPW with your installation path if you enter different during installation) copy file ‘RfSetPswd.exe’ to installation folder on workstation. Run this file. Click “Browse”.
Select MPW.rf file from workstation installation folder. Click “Open”.
Enter password for Login ID that you entered in ODBC Driver configuration and click “Set”.
System will prompt you that password successfully set. Click “Ok” and close program.
4. Check Windows Firewall. Disable for test, add rule.
Windows Firewall might block connection to server from workstation. To ensure that you can connect to TCP port that Millennium using for connection you can do following:
Run command line, enter ‘telnet xxx.xxx.xxx.xxx 2201’, where xxx.xxx.xxx.xxx – Server IP address.
If telnet command wasn’t recognized, you can enable telnet feature in Control Panel -> Programs and Features (Add or Remove Programs) -> Turn Windows features on or off. Enable Telnet Client and Telnet Server features. Click Ok. Windows will install Telnet feature.
Press enter. If connection was successful you should see blank screen. It means that Telnet connected to TCP port.
If connection wasn’t successful you should check Windows Firewall settings.
Try to disable Firewall at the workstation and at the server and repeat telnet command. Run Millennium at the workstation. If you can connect to server it means that you should add rules to Windows Firewall.
To add rule at the workstation go to Windows Firewall -> Advanced Settings. Right click on ‘Outbound rules’ item -> New rule:
Select rule type – Port and click Next:
Apply this rule to TCP and specify port number 2201. Click Next
Select ‘Allow the connection’ and click Next
Select all, Domain, Private and Public networks. Click Next.
Enter name for rule and click Finish.
Rule should appear in the list of rules:
Do the same procedure at the server, but instead of creating Outbound rule you should create Inbound rule with the same options.
5. Copy MPW.rf from server to workstation
You should have same mpw.rf file at the server and at each workstation. Make sure you have copied mpw.rf file from server to workstation.
6. Check if the Millennium running as a service. If it does, Millennium shouldn’t run as application.
7. Make sure your user exists in SQL Server security.
To add user to SQL Server security do following:
Start Management Studio and connect to server
Go to Security -> Logins -> right click on Logins -> New Login…
Select user login and go to Server Roles page
Check option ‘sysadmin’
Go to page User Mapping. Check 4 Millennium databases. For each database check option ‘db_owner’.