I just installed ILLiad and I need to know what I put in the ATLAS SQL Alias Manager for the Server and Database Name?
Symptom
- You installed ILLiad and you need the information you put in the ATLAS SQL Alias Manager
Applies to
- ILLiad
Resolution
Here are the steps you need to take to make sure you have the correct information in the ATLAS SQL Alias Manager:
1. If you are hosted by OCLC, contact OCLC Support and we will give you the credentials you need.
2. If you are self-hosted, you need to check with your internal support.
3. When you open the ATLAS SQL Alias Manager, right-click on the shortcut and "Run as Administrator."
4. When you start putting in the information that you select ILLiad first. Otherwise, you will be under the wrong product.
5. When you save the file name you save it in the directory where you installed ILLiad. So if you installed ILLiad in the c:\program files (x86)\ILLiad folder, that is also where you save your ATLAS SQL Alias Manager settings.
6. When you put in the server and database name and save it, the username and password automatically fill in.
7. After saving the information, also click on the "Set Default" icon. You will be asked about the location, chose OK.
Additional Information
The ATLAS SQL Alias Manager is what is used to connect to your SQL Server from the Client or the Web Server. In the ATLAS SQL Alias Manager, if you have the Server Name set up for a DNS such as oclc-db.illiad.oclc.org and you are moving the SQL server, then you need to have the DNS redirect to the new location. If you have the Server Name set up as an IP address, then you will need to update the IP address on the local computer that runs the ILLiad Client and on your Web Server.
Many SQL Servers do not support the secure box, so it is best not to have that box checked.
Sometimes your computer cannot translate the DNS, so you might have to put in the IP address of the SQL Server such as 206.107.45.228 to make it work. You should get the DNS resolved because it is better to have the DNS for the long run if for some reason OCLC changes the IP address.
You also might want to look at the Atlas SQL Alias Manager documentation.