Related Topics • HOWTO: Backing Up the ILLiad Database • HOWTO: Breaking the User Link in the ILLiad Database • PROBLEM: Cancellations or OCLC Reasons for No are all updating as Other • HOWTO: Changing the size of a field in the ILLData database • See more

Other Support Options • Contact Atlas Systems Phone Numbers, Support Options, Online Help, and more. • Listserv Pose a question to other users.

Page Tools Print this page E-mail this page

Feedback How helpful was this article? 5 Best 4 3 2 1Worst 0 N/A Suggestions:

SUMMARY

You can change the port that ILLiad uses to connect to Microsoft SQL Server (to get around an arbitrary firewall blockage for example). This involves making a change on each server machine (if you have more than one component to the ILLiad server) and each client machine. This also involves editing a configuration file for OpenURL.

Making this change will disrupt ILLiad service until all components are changed.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE SERVER

1. Open the Microsoft SQL Server Enterprise Manager.
2. Right-click on your server instance (you may have to expand the server groups).
3. Choose Properties.
4. Under the General tab, click the button labeled "Network Configuration". The SQL Server Network Utility will be displayed.
5. On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.
6. The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server (it will most likely be 1433). Changing this entry will change the port that SQL Server listens on. Make the change and hit OK to close the dialog.
7. Hit Apply on the SQL Server Network Utility screen, then OK.
8. The system will tell you that the changes are saved, but that they will not take effect until you stop and restart the SQL Server service. Hit OK.
9. Hit OK to close the Properties dialog.
10. Right-click on your server instance again, and choose to stop the SQL Server service.
11. Once it has stopped, right-click and choose to start the SQL Server service. Restarting it will now use the new port.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE CLIENT

1. Close the ILLiad Client and any Administrative tools (Customization Manager, User Manager, etc.).
2. On each ILLiad Client machine, go to the ILLiad program group and open the Client Network Utility under the Networking folder.
3. On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.
4. The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server (it will most likely be 1433). Changing this entry will change the port that ILLiad connects to on the ILLiad/SQL Server.
5. Change the entry and hit OK to close.
6. Hit OK to close and save the changes.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT FOR OPENURL

1. On your OpenURL server (almost always the same as your ILLiad web server), open your OpenURL directory and browse to {OpenURLDirectory}\jakarta\webapps\OpenURL\web-inf and open the web.xml file using Notepad.
2. Towards the top of that file, there is a line of code that says: jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ILLData
   (localhost may be replaced by the ip address of your SQL Server if it is not the same machine as your OpenURL server.)
3. Change the port 1433 to be the new port that you are using to connect to your SQL Server.
4. Save changes to the file and close it.
5. Under Services stop and restart the ILLiad OpenURL Service.